workbook viewing

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Workbook viewing

Workbook viewing

resolvedResolved · Low Priority · Version 2003

Duncan has attended:
Excel Advanced course

Workbook viewing

How do you move from 1 workbook tyo another quickly

RE: Workbook viewing

Hello Duncan

Hope you enjoyed your Excel training with BEST STL.

Thank you for your question regarding moving from one workbook to another.

The fastest way to do this is to hold the CTRL key and then press the TAB key. This will scoll you through the workbooks that you have currently open.

Other ways are:
- Click WINDOW in the Menu Bar and then select the workbook you want
- Arrange the windows in CASCADE style (Window > Arrange).

Hope that answers your question.

Regards

Richard
Microsoft Office Specialist Trainer


 

Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

View all Excel hints and tips


Server loaded in 0.08 secs.