Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - Worksheet

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel training courses - Worksheet

Resolved · Low Priority · Version Standard

Reply Mon 16 Jul 2007, 16:57Delegate Jassiara said...

Jassiara has attended:
Excel Intermediate course

Worksheet

How can I have a specific worksheet (tab) selected when opening the spreadsheet?

Many thanks!

For upcoming training course dates see: Pricing & availability

Reply Tue 17 Jul 2007, 10:20Trainer Tracy said...

RE: Worksheet

Hi Jassiara,

Thanks for using the forum. In answer to your question you cannot pre-select a worksheet you can only save the spreadsheet in the tab you want the worksheet to be opened in. If you only saved one sheet in a workbook you would not have this issue? If that is a possibility.

Regards

Tracy

Excel articles

· Tracking In Excel 2003
· Coping With Compatibility In Excel 2007
· How To Create An Excel 2010 Chart To Show Both A Number And A Percent Data Series
· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· Making The Most Of Filtering In Excel

Excel tip:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

View all Excel hints and tips