file paths

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » File Paths

File Paths

resolvedResolved · High Priority · Version 2003

Gareth has attended:
Dreamweaver 8 Introduction course
Excel Intermediate course
Excel Advanced course

File Paths

How can I default a new spreadsheet to always show the file path. I know how to do footers. I want to actually ammend the main new template for this.

Thanks

RE: File Paths

Hi Gareth, one way is to customise the interface to remove the File-New icon, and replace it with a macro that generates a new spreadsheet from your customised template.

However, find you XLStart folder on your c:\ drive and place your customised spreadsheet in there, renaming it as "Book.xls". I have found that doing this forces Excel to start with the customisations already in place, which may be a better solution for you.

Hope this is helpful,

Anthony

Wed 27 May 2009: Automatically marked as resolved.


 

Excel tip:

Keyboard Shortcuts to Add Rows or Columns

Couple of other keyboard shortcuts. Shift+spacebar selects a row, Ctrl+spacebar selects a column. Select either row or column (or several) and use Ctrl and + to insert or Ctrl and - to delete rows or columns.

View all Excel hints and tips


Server loaded in 0.12 secs.