Log in

Excel split screens - fuzzygruf's blog

> Recent Entries
> Archive
> Friends
> Profile
> Homepage

LJ Update
LJ Recent Comments
Search LJ FAQs
Edit LJ userpics
Manage filters
LJ collage
Edit LJ links
LJ guests and statistics
upload to scrapbook
LJ Stats
LJ portal

August 19th, 2014

Previous Entry Share Next Entry
10:00 am, August 19th - Excel split screens

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."


(1 comment | Leave a comment)


[User Picture]
Date:August 19th, 2014 11:06 pm (UTC)
...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.

> Go to Top