Join Curt Frye for an in-depth discussion in this video Displaying a workbook's full path, part of Excel 2013: Shortcuts.
One of the great things about modern computers is the amount of data that you can store on their hard drives. I mean, they are absolutely immense compared to what you could buy even four or five years ago. The downside is that you have to create folders within folders, within folders, to store and organize all that data, and it can be difficult to tell people where to go on a hard drive and even harder to write it out. In this movie I will show you how to find the folder that a particular file is stored in, and copy it quickly. As my example, I will use the FullPath sample file, which you can find in the Chapter 3 folder of your Exercise Files archive.
To get the address of a file you need to display the Save As dialog box, and the quickest way to do that is to press the F12 key. So I'll press F12, and when I do, I get the Save As dialog box. Now I will move the mouse pointer up to the address bar, which tells you which folder you're in, and click the folder icon at the left edge, and that's this image here. When I click it, the contents in the address bar change to display the path to the current folder, and you can see it's currently selected and highlighted in blue.
Now I just copy that text, and I am done with the Save As dialog box, so I can click Cancel to close it. Now I have copied the path to the folder into the clipboard so I can paste it into my workbook. So I'll click cell E2 and paste, and when I do, I get the full paths of the folder that contains the file. And then if I want to edit it to add the file name, I can just double-click the cell to start editing and then click to the right of the existing value, type a\, and then FullPath.xlsx, and press Return.
So now if I need to tell anyone where to find the file, perhaps in an email, or if I am programming in Visual Basic for applications and I want to give a reference to the file, all I need to do is use this string and I can tell people or programs exactly where to look for it.
Author
Released
2/28/2013- Entering a data series using the fill handle
- Creating hyperlinks
- Setting a print area
- Applying a table style
- Creating substitute data sets using scenarios
- Wrapping and shrinking text
- Creating a data entry form
- Removing duplicate values
- Inserting the current date or time
- Generating a list of unique random numbers
- Calculating running totals
- Analyzing a formula for errors
- Summarizing data with charts and PivotTables
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel 2013 Essential Training
with Dennis Taylor6h 32m Appropriate for all -
Office 2013 New Features
with David Rivers2h 31m Appropriate for all -
Cleaning Up Your Excel 2010 Data
with Dennis Taylor1h 27m Appropriate for all
-
Introduction
-
Welcome55s
-
-
1. Top Ten Shortcuts
-
Super-hiding worksheets3m 39s
-
2. Controlling the Excel Program and Interface
-
Customizing the Ribbon4m 57s
-
3. Managing Workbooks and Worksheets
-
Setting a print area2m 32s
-
Zooming in or out quickly2m 48s
-
4. Organizing Data
-
Creating a custom view4m 16s
-
Finding a target value3m 24s
-
-
5. Entering and Formatting Data
-
Picking data from a list1m 40s
-
Creating a data entry form3m 25s
-
6. Managing a Data Series
-
Extending a date series3m 47s
-
Removing duplicate values3m 34s
-
-
7. Working with Dates and Times
-
8. Creating Useful Formulas
-
Rounding values6m 30s
-
9. Managing Formulas
-
Calculating running totals1m 55s
-
Commenting within a formula2m 28s
-
Watching a cell's value3m 16s
-
-
10. Summarizing Data Using Charts and PivotTables
-
Creating recommended charts1m 37s
-
Delaying PivotTable updates2m 28s
-
Conclusion
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Displaying a workbook's full path