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.

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

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

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.

The larger a spreadsheet gets, the more likely you'll want to start hiding rows or columns or maybe you've been given a sheet that has hidden rows or columns.

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.