| Home : May 27 2017 Computer News : 7 Excel tips for huge spreadsheets: Split Screen, Freeze Panes, Format Painter and more |
|
7 Excel tips for huge spreadsheets: Split Screen, Freeze Panes, Format Painter and more |
May 27, 2017
The bigger and uglier your Excel spreadsheet gets, the more you need to use certain features or tricks to keep a handle on the data. The seven features covered here will help you navigate, organize, and readjust your spreadsheet with as little hassle as possible. 1. Split Screen
One of the most helpful features for large spreadsheets is the Split Screen command. The Split Screen allows you to view two, three, or four windows of your spreadsheet. Use this feature to work on one section of your spreadsheet while you view another section; or use it to compare (side by side) two sections of the spreadsheet. Once you try it, you'll find lots of reasons to use it.To read this article in full or to leave a comment, please click here
Link: http://www.pcworld.com/article/3153964/business-software/7-excel-tips-for-huge-spreadsheets-split-screen-freeze-panes-format-painter-and-more.html#tk.rss_howto
|
|
|
|
|
