excel training microsoft - excel viewing worksheets
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

resolvedResolved · Low Priority · Version Standard

replyReply Tue 21 Aug 2007, 16:02Delegate 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

For upcoming training course dates see: Pricing & availability

replyReply Wed 22 Aug 2007, 05:32Trainer 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

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

RE: EXCEL viewing 2 worksheets side by side

that's great, thankyou :)

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

RE: EXCEL viewing 2 worksheets side by side

Phew! I am glad

If there is anything else let me know

Tracy

 

Excel tip:

Go to source of a cell

The default setting in Excel is when you double click in a cell it actives the formula in the cell. If you have created a link and want to directly go to that link (say if on another sheet, click on Tools -options and take off the tick for eidt it directly in cell

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard