microsoft excel training - Keyboard shortcuts between sheets

The UK's most regular instructor-led training courses.
Training information: microsoft excel training · Excel training courses · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Keyboard shortcuts between sheets

Sam has attended:
Excel Introduction course
Word Intermediate course

by - delegate Sam [1 post] (2007 Feb 12 Mon, 16:23) Reply

What is the keyboard shortcut for moving between sheets?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 9 Tue	Bloomsbury	2	book now	£215	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
2003	2008 Sep 11 Thu	Southwark	4	book now	£207	£215
2002/XP	2008 Sep 16 Tue	Tooting	0	FULL
2003	2008 Sep 16 Tue	Bayswater	4	book now	£195	£205
2003	2008 Sep 18 Thu	Bloomsbury	2	book now	£215	£215
Full Schedule: See all 137 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: keyboard shortcuts between sheets

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 13 Tue, 15:30) Reply

Hi Sam, the keyboard shortcut is holding the Ctrl button down and press page up together.

Thanks

Tracy

· Microsoft Excel Features and Functions for Accountants
· Do You Really Need Excel VBA Training?
· Benefits of learning about Excel charts
· What's Better Than the Help Function in Excel? Microsoft Training
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips