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

excel software training - Spread sheets

ResolvedVersion Standard

Tue 1 May 2007, 16:10 Delegate Michelle said...

Michelle has attended:
Excel Introduction course
Outlook Advanced course

Spread sheets

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

Tue 1 May 2007, 16:26 Trainer Pete said...

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.

Training courses

98.7 % recommend us

More live stats...

Training information:

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

excel software training - Spread sheets

Spread sheets

RE: Spread sheets

Excel articles

Excel tip:

Quickly insert a function