excel training microsoft - EXCEL viewing 2 worksheets side by side

Resolved · Low Priority · Version Standard

Tue 21 Aug 2007, 16:02 Delegate Christine said...

Christine has attended:
Excel Intermediate course

EXCEL viewing 2 worksheets side by side

How do you view 2 worksheets in the same workbook side by side

Wed 22 Aug 2007, 05:32 Trainer Tracy said...

RE: EXCEL viewing 2 worksheets side by side

Hi Christine,

Thanks for the question.

If you want to view the same worksheet next to each other, open the initial worksheet. The go to the window menu and select 'New', this will create a duplicate window. Then select Arrange All under the window menu. Now you should see the two worksheets side by side.

Good luck

Tracy

Wed 22 Aug 2007, 09:21 Delegate Christine said...

RE: EXCEL viewing 2 worksheets side by side

that's great, thankyou :)

Thu 23 Aug 2007, 10:26 Trainer Tracy said...

RE: EXCEL viewing 2 worksheets side by side

Phew! I am glad

If there is anything else let me know

Tracy

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips