fuzzygruf: (smiley)
[personal profile] fuzzygruf

I forgot about Split screens until I accidentally got one today and had to find out how to get rid of it. Figuring that out helped me see that split screens could be useful.

Go to cell where you want split the screen. In the View tab, click on Split in the Window section. This lets you scroll through different parts of the worksheet. This works vertically and/or horizontally. Just like in real life.

A similar option is nearby: View Side by Side. This lets you view two different worksheets, similar to split screen.

To view different tabs in the same workbook, in the Window section click "New Window" and then "Arrange All."

Date: 2014-08-19 11:06 pm (UTC)
From: [identity profile] billeyler.livejournal.com
...or that you can have multiple copies of Excel open at the same time and pull up a file on each. I have two screens at work and don't use split screen anymore (although it was very useful for a while). Be sure to turn of the lock scroll on the menu.

Profile

fuzzygruf: (Default)
fuzzygruf

April 2017

S M T W T F S
      1
2345678
9 101112131415
16171819202122
23242526272829
30      

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Sep. 25th, 2017 02:39 am
Powered by Dreamwidth Studios