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

excel training microsoft - excel viewing worksheets

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training microsoft - EXCEL viewing 2 worksheets side by side

excel training microsoft - EXCEL viewing 2 worksheets side by side

ResolvedVersion Standard

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

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

RE: EXCEL viewing 2 worksheets side by side

that's great, thankyou :)

RE: EXCEL viewing 2 worksheets side by side

Phew! I am glad

If there is anything else let me know

Tracy

Excel tip:

Quickly select a block of data

To quickly select a block of data make sure your active cell is somewhere whithin the block of data and then press Ctrl+* or Ctrl+Shift+8.

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.