How to Hide Columns and Rows in Excel . Hiding rows and columns in your Excel spreadsheet is straightforward, as expected. To do this, select the column or row you want to hide.

Not only can you freeze rows and columns in Excel, you can hide them! Hiding columns in Excel is pretty straightforward and quick. Here's how to do it: Step 1: Select the column you want to hide.

1] Hide selected Columns in Microsoft Excel When it comes down to hiding columns in Microsoft Excel, this is an easy task to get done. So, without any other delays, let us explain how to do it.

In this article, you’ll learn how to hide and unhide columns, as well as the not-so-intuitive steps for unhiding column A. PREMIUM: Build your skills with this Excel power user guide .

The other option to hide the row and column headers in Excel is to click the File tab. On the backstage view, click Options on the left. An Excel Options dialog box will appear.

How to unhide all hidden columns in Excel. 1. Open Microsoft Excel on your PC or Mac computer.. 2. To unhide all hidden columns in Excel, navigate to the "Home" tab. 3. Click "Format," which is ...

How to unhide all rows in Excel. 1. To unhide all hidden rows in Excel, navigate to the "Home" tab.. 2. Click "Format," which is located towards the right hand side of the toolbar.

Microsoft Excel 2010 does not plot hidden rows or columns, so you need to hide the empty rows or columns. Strangely, in Excel 2010, unhiding the data is easier than hiding it. Open the spreadsheet ...