One custom format field can scale numbers, add icons, apply color rules, and clean up visual clutter instantly.

Just as you can quickly hide and unhide columns, you can hide or reveal hidden rows in your Excel spreadsheet as well. In addition to freezing rows, you may find it helpful to conceal rows you are no ...

Help! I hid the two top rows of an Excel file, and now I can’t figure out how to get them back because I can’t find a way to access them to reverse the Hide command. Or right-click and click on Hide. ...

The typical unhiding techniques don’t work everywhere in Excel. Learn an easy to remember method for unhiding row 1 and column A. Hiding and unhiding rows and columns is a straightforward and easy ...

Sometimes we have spreadsheets overrun with data and it can be quite cumbersome where Microsoft Excel is concerned. Not everyone wants to see the data all at the same time, so the best option to take ...

A few overlooked Excel shortcuts let you enter, clean, and reorganize data without leaving the grid.