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

You can hide and unhide rows in Excel by right-clicking, or reveal all hidden rows using the "Format" option in the "Home" tab. Hiding rows in Excel is especially helpful when working in large ...

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

There are several tricks you can use to organize or otherwise clean up your spreadsheets across multiple apps, from automated calculations to setting up filters. In fact, it's often necessary (or at ...

In addition to storing typed data in each cell of a spreadsheet, Microsoft Excel allows you to perform functions on one cell and show the result in another cell. The most basic function, a link, ...

You can freeze a row in Excel so it's easier to compare data as you scroll through the spreadsheet. You can choose to only freeze the first visible row in your Excel sheet, or freeze multiple rows. To ...

How to display multiple subtotal rows in a Microsoft Excel PivotTable Your email has been sent Microsoft Excel PivotTables are a great way to summarize data. They’re easy to create and display ...