Weekly Computer Tip # 70
3 July 2004

Navigation keyboard shortcuts (Microsoft Excel)

To reveal columns that are not initially visible on your worksheet you can scroll the Workbook window to the right by clicking on the right arrow on the Horizontal scroll bar to scroll column by column, or by pressing and holding down the mouse button with the mouse pointer positioned on the right arrow to scroll by several columns. However,

Did you know ...

You can quickly move left or right one screen using keyboard shortcuts.

Here's how:

1. To move right one screen, press ALT + PgUp (PageUp)
2. To move left one screen, press ALT + PgDn (PageDown)

By the way, does anybody remember the effect of pressing CTRL + PgUp and CTRL + PgDn? (see tip # 37) ...

1. To move to the next sheet in a workbook, press CTRL + PgUp (PageUp)
2. To move to the previous sheet in a workbook, press CTRL + PgDn (PageDown)

Excellent time-saving tips! (I feel - hope you do too.)

Just before you go, if anyone is interested in the hands-off Excel with Excel seminar I told you about in tip # 65 and would like to save money ... the early bird discount ends 15 July. Remember: as a weekly tip subscriber you're entitled to an additional discount of 10% bringing the price down to GBP120.50 only. Bring a guest for an additional GBP111.75 - the benefit from attending the seminar as a group is enormous, if only so that you will all "speak the same language" so you can support one another as you continue to learn and experiment with Excel. For more information and a booking form see http://www.roem.co.uk/events.html

Until next week.

PS I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.

Home   Training   Support   Clients   Contact Details   News   Disclaimer