Excel's Custom Views tool lets you create a snapshot of your spreadsheet, allowing you to toggle between layouts.

Q. I work with large spreadsheets. These spreadsheets have hundreds or even thousands of rows and often 10 or more columns. It’s so much to process that I become confused and make mistakes. Does Excel ...

Computer programs frustrate users when something that worked before stops working, especially when there is no clear indication as to why. With Excel 2007, Excel 2010 and Excel 2013, the "Custom Views ...

What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format, and ...

Much of the data that you use Excel to analyze comes in a list form. You might need to sort the data, filter it, sum it, and perhaps even chart it. Excel tables provide superior tools for working with ...