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

How to hide rows and columns and use groups in a shared Microsoft Excel workbook Your email has been sent A few years ago, Microsoft Excel improved collaboration by adding sheet view to shared ...

Creating a macro in Microsoft Excel allows you to program automatic tasks into a spreadsheet or template that can contain multiple commands or functions for easy access and use. After these macros are ...

Using the formula in Excel can make your day-to-day tasks easier. Excel has formulas for almost all operations. Having said that, if you want to hide formulae if you are sharing your Excel spreadsheet ...

Microsoft Excel by default shows a horizontal and vertical scroll bar in an Excel workbook. It lets you move through the worksheet so that you can scroll the data on the page easily. But if you don’t ...

When you've got a chart-heavy Excel spreadsheet, you can display one chart and let the viewer switch to see the others from a drop-down. The Pointy Haired Dilbert blog runs down the details of this ...

Did you know that you can hide data in individual cells or ranges of cells in Excel without changing your spreadsheet's content or structure? It's surprising that Microsoft Excel doesn't have a ...

Some of my reports list Social Security numbers. Since the reports are often viewed by others, I need a convenient but secure way to hide those numbers—such as making only the last four digits visible ...

Pro tip: Three ways to hide zero values in an Excel sheet Your email has been sent Although zero values are valid, you might need to hide them. Here are three methods for hiding zero values in an ...