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

excel software training - spread sheets

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel software training - Spread sheets

excel software training - Spread sheets

ResolvedVersion Standard

Michelle has attended:
Excel Introduction course
Outlook Advanced course

Spread sheets

How do I work on two spreadsheets at the same time?

RE: Spread sheets

Hi Michelle, Thanks for the post, In answer to your question; Open the Workbook that you wish to work on, select each sheet you wish to view and on each one apply the menu command; Window, New Window.
When all have been selected go to the Window menu again and apply the Arrange command, choose from the options offered.
Note: If you wish to view all the sheets in the Workbook, select the option; Windows of Active Workbook.

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.