Excel Tips – View Worksheet Side by Side

by Chris Leong

It’s been very long since i posted another office tips and tricks page. I sometimes needs to do that and it really is frustrating when you need to switch between Excel files. I guess this tip will be useful for those who needs to compare worksheet side by side.

So here how you can view your worksheets side by side.

On the View tab, in the Window group, click New Window.

Inst

clip_image004

On the View tab, in the Window group, click View Side by Side .

clip_image006

In the Compare Side by Side dialog box, click the worksheets that you want to compare. To scroll both worksheets at the same time, click Synchronous Scrolling  in the Window group on the View tab.

 

Thanks to Lee Chun Onn that provide me. Have a tips and tricks that you want to share. Email me 🙂

Advertisements