is it possible to unhide a column in excel spreadsheet

Then press Ctrl + Shift + 9 keyboard combination to unhide all rows, or press Ctrl + Shift + 0 to show all hidden columns. If you want to unhide all rows or columns on a sheet, make sure the whole worksheet is selected. Part 3: Quickly Unhide All Hidden Rows or Columns Right-click the selected column headers and pick Unhide. To unhide a column, select the columns before and after the hidden columns. Then, right-click on the selection and click Unhide from the popup menu. Since row 3 is hidden, we want to select rows 2 to 4.

To unhide a row, just select the row above and the row below the hidden row. Part 2: Unhide a Whole Row or Column in Excel 2016 But you’ll see double lines at column or row headers, which indicates a column or row is hidden.

The selected row or column will be hidden from view straight away.

Right-click the selected row or column, and then click the Hide option.

If you wish to hide an entire column, click the column letter to select it. In this blog, you will unlock several ways to hide or unhide a row or column.

Select the whole row you want to hide by clicking the row number. This is a quick guide on how to hide and unhide a row or column in Excel.

Go into Data>Filter, and if the Autofilter has a tick mark, >click it and see if this reveals all the rows.

Part 1: Hide a Whole Row or Column in Excel 2016 Gord Dibben Excel MVP On Thu, 00:04:20 -0000, 'Bob Phillips' <.uk> wrote: >Do any of your columns have a dropdown arrow on them there might be a >filter applied.

How can I hide a full column in Excel worksheet without deleting it? If you don’t want others to see a specific row or avoid printing a certain column, you can hide the entire row or column in Excel 2016.

Is it possible to unhide a column in excel spreadsheet