If you want to hide and unhide columns and rows in Microsoft Excel, then know it is easier than you might have thought. We explain how.

You can hide and unhide rows in Excel by right-clicking, or reveal all hidden rows using the "Format" option in the "Home" tab.

Microsoft Excel’s sheet view collaboration feature is not new, but now it supports hiding rows and columns and applying groups.

Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear in the data. It's similar to the SUBTOTAL function but provides more ...

This is where the number-crunching fun starts. Learn the ins and outs of the logical formulas that represent the heart of Excel.

How to Hide Empty Data in Excel Graphs. If you have an Excel spreadsheet that contains empty data, such as empty rows or columns, and plot a graph from the spreadsheet, Excel plots all empty data.

Don't waste time removing these empty rows manually! Instead, use this tip to ensure you don't miss any rows or accidentally delete the incorrect rows.

When you need to delete records based on a single value in Microsoft Excel, use this Visual Basic procedure. It can make your life a lot easier.