This month, I’ll show you an easier way to display a file’s location using the Quick Access Toolbar (QAT). But these approaches can be awkward to apply–and they all come with inherent problems.
#MICROSOFT WORD 2016 RIBBON WORKSHEET HOW TO#
The article How to display the filename and path in a Word document or title bar discusses methods for displaying a Word file’s path and name that are compatible with both Ribbon and menu versions. For more info, visit our Terms of Use page. This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews. We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships. Here's a trick to add a control to the QAT so you always know the current file's location. With seamless storage built into the Office interface, it's easy to lose sight of where you're saving files.
#MICROSOFT WORD 2016 RIBBON WORKSHEET FULL#
If the range doesn't exist, the desired workbook is still opened, but Excel informs you that the range name is invalid.How to display an Office file’s full location in the Quick Access Toolbar Excel is opened and the range is displayed. Note that when you use a named range, you don't need to surround it by apostrophes as is done with worksheet names. Budgets/Annual/Budget2010.xlsx#DeptTotals If you use named ranges in your workbook, you can use the name of a range you want displayed instead of using a sheet and cell name: If you want to make sure that a specific cell is displayed on the target worksheet, you can further refine the address in this manner: Note that the worksheet name is surrounded by apostrophes and separated from the workbook name by a pound sign. Budgets/Annual/Budget2010.xlsx#'Sheet3' To open a specific worksheet, simply tack the worksheet's name onto the end of the address, prefaced by a pound sign as shown here: For instance, if you, in step 4, navigate to a workbook named Budget2010.xlsx, the Address bar might contain something like this: If you want to display a specific worksheet, all you need to do is modify what appears in the Address box as you are setting up the hyperlink. When you do this, the Excel workbook you specified in step 4 is opened, and the first worksheet in the workbook is displayed. Your hyperlink is now created, and you can Ctrl+click to access the target of the hyperlink.