::: Excel tips 11 :::

>> Faster access to worksheets <<

When working with large workbooks in which all of the worksheet tabs are not visible, your users may get frustrated with scrolling to find the sheet they need. Here's a really quick tip to pass on. Right-click on any of the tab-scrolling buttons (to the left of the sheet tabs) and a shortcut menu will pop up. You can then select the tab you want.

-----------------------------------------------------------------

>> Inserting the full file path in headers and footers <<

Excel 97 doesn't offer you the option of displaying the full file path in worksheet headers and footers. With a little basic VBA editing, you can add this functionality to users' systems.
. Go to Tools | Macro | Visual Basic Editor.
. Go to the View menu and select Code.
. Type the following:
Sub PathFooter()
ActiveSheet.PageSetup
LeftFooter=ActiveWorkbook
FullName
End sub
. Go to File | Close.
Return to your workbook and save the file. You can now run your macro by navigating to Macros and choosing the one named PathFooter.