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...

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...

Running Total/ Cumulative Sum in Excel

  Hey Guys! You should have noticed that I'm writing on MS Excel for last few days! To be honest I'm trying to learn some simple and useful tricks of Excel. And I'm also trying to share my knowledge with you. In this post I've come with such a little trick which maybe very useful if you face such situation. Let's begin . . .    Running Total/ Cumulative Sum It means the summation of numbers in a list and it will be updated each time when a number is added or changes. Look at the image below -    Look at the image. There are two columns with numbers. The first one is simply the number list. But the 2nd one is the summation of the list. Each time a new number is added to the first column the second one shows the summation. How to do this?  It's not a magic. Very simple sum formula is used to perform this task. But there is a little trick. You just need to lock the first cell and then every time it will update the running total list.  Here is my list. Sim...