Skip to main content

How to Show the File Location in MS Word and Excel?



Document File Path


In MS Word and Excel you can show the location of your file (File Path). Usually the file path is placed at the footer of the document. And when it is placed at the document footer, it automatically appears at the each page of that document. 


Why to Use the File Path (Location of the File): 

Well this is really important for those people who want to keep the source of the document printed with it. If the file path is printed with the document then it is quite easier for us to trace the path next time when you search for it on the hard disk. It looks like the image below: 

File Location on the Document Footer

Thus it is easier for you to locate a saved document. 


Why You Shouldn't Use the File Path: 

Definitely it is revelation of information. If the file is a highly classified document and if the file path is used there, then others (who do not have access to that file) might be accessed that file through the path printed with the document! For example: it may be the question of the Varsity Admission Test or Job Test. 


How to Show the File Path in a Document: 

Well this is not a difficult task but really tough to find if you are not familiar with this option previously. And I will discuss about how to show the file path as well as how to hide. I am an user of Office 2010. But don't like to avoid the Office 2003 users. :) 


Show/ Hide File Path in Office 2003: 

Ms Word 2003: There are two ways available for you to do this task. You can follow any of the two methods. But at first you have to make sure that the file is previously saved. If you apply this to an unsaved document then it will show only Document 1 instead of showing the file path. 

Method 1: Open a Document > Go to the View Menu > Choose Header and Footer > Go to the Footer > Insert Auto Text > Hit on Filename and Path. Done! 

Take help of the image below: 


Insert File Path from Header and Footer Option


Method 2: Somewhat difficult. Open a Document > View Menu > Header and Footer > Go to Footer > Insert Menu > Field > Choose Document Information from Categories > Select FileName from Field Names section > Select Add path to filename from the right most column > Hit Ok. Finish. 

Look at the image below: 

Insert File Location from Field


MS Excel 2003: 

There is only one method and this is very easy. Open a previously created MS Excel Book. Simply go to the View Menu. Click on the Header and Footer option. Now select Edit Footer.  Here you you can insert the file path.  



Show/ Hide File Path in Office 2007 and 2010: 

Here the procedure is somewhat different from Office 2003. Because Office 2007 and 10 has the ribbon instead of menu. 


MS Word 2007 and 2010: 

Don't know why the Auto Text doesn't show the file path. But you can insert the file path from field. 

First you have to open a saved document. Then go to the footer (Just double click on the footer margin to activate footer). Now go to the Insert Menu > Quick Parts from the right side > Hit on the down arrow and choose Field > Select Document Information from Categories > Choose FileName > Mark Add Path to FileName. Done! 


Insert File Path in Office 2010 from Field


MS Excel 2007 and 2010: 

Open a saved excel book. Go to the Insert Menu > Hit on the Header & Footer from the right side of the ribbon > A new menu will appear named Design > Now move to the Document Footer > Select File Path > Done. 

Look at the images below: 



Field option under insert menu



Insert File Path in Excel 2010



MS Word 2013

Run MS Word 2013 > Open a previously saved document > Double click on the Header or Footer Section > Now you will get the Design tab > Move to the Insert Section under Design tab > Document Info > Choose File Path > Done!

Insert File Path in Word 2013




How to Remove the File Path? 

You may notice that I have only talked about how to insert file path. But nothing was discussed about how to remove it! If you have already inserted the file path and can't remove it then simply go to the footer. Press Ctrl + A and hit the delete button to remove everything from footer. Or just select the file path from the footer and delete it. That's it. 


Stay with Marks PC Solution to get more interesting IT topics!




Comments

  1. In this type of process. We need to copy or move ling path files and at that time we can use Long Path Tool. This is perfect to use.

    ReplyDelete

Post a Comment

Popular posts from this blog

GTA San Andreas Cheat Code (PDF)

After Vice City, San Andreas is the most popular game released by Grand Theft Auto (GTA). Usually GTA releases role playing game. San Andreas is such a game where you can act like a person. You can do everything. You have to take part in missions and complete them.  To make your missions easier, there are lots of cheat codes. If you can properly apply these codes, the tough parts of the game will be easier. Cheat codes are somewhat like keyboard shortcuts of computer programs.  I've shared 63 cheat codes below. There were more cheat codes in my collection, but I've omitted the less important cheats. Effects or result of the cheats are on the left side, and the codes are on the right side.  You can copy the following codes in your PC. And for your convenience, I've also uploaded a PDF file of these codes. You will find the download link at the bottom.  Effect Cheat Code Adrenaline Mode MUNASEF All Cars Explode ALL...

Office 2016 Activator (KMSPico 10.1.5)

It's been couple of months after the release of final version of Microsoft Office 2016. And maybe you're tired of finding for a working activator for this version. Today I'm gonna share Office 2016 activator with you - no more waiting!! About the Activator   Name: KMSPico 10.1.5 File Size: 3 MB (Approx) File Type: Zipped Folder 100% Neat & Clean - No virus! Activating Capacity . . . KMSPico 10.1.5 is successfully leading the KMS world for last few months. If everything is okay, success rate is 100%. This tool has been tested and verified by Marks PC Solution. With this tool, you can activate -  Office 2016, 2013 & 2010 Windows 10, 8.1 & 8 Hopefully this version will work for both 32 bit & 64 bit versions of Windows. Installing Office 2016 Collect/ Download Office 2016 Professional Plus from Microsoft or somewhere else. Install it as trial version without any key. Use the follow...

Joining Texts from Multiple Cells in Excel

  Programs like MS Excel is full of functions. There are many useful functions that we don't use or we don't know about. One of them is CONCATENATE. It means joining or linking. With this function you can join texts from multiple cells. Let's see how . . . Suppose you're working in an Excel Worksheet where you need to combine texts from different cells. I'm gonna show you an example. Let's consider the image below -    What do you see ? I've imputed First Name and Last Name. In Full Name column I've used the formula i.e. CONCATENATE. And in the last column I've added Mr. with the full name.    So how do you use this formula ? Here it is -  =CONCATENATE(A2," ",B2) Observe it carefully. You can add more than 02 cells with this functions. Here I've just used 02 cells. You may think what is this " " for ? You may notice that there is a space between the two i.e. " & ".  If you don't use " " then you...