#How to unhide columns in excel how to#

After selecting left-side and right-side Columns of the hidden Columns, right-click on selected Columns and select 'Unhide' from the context menu. To unhide hidden Columns, select left-side and right-side Columns of the hidden Columns.

#How to unhide columns in excel how to#

How to unhide hidden Columns in Excel worksheet That means, Column B and Column C are hidden.ДЄn animation about how to hide Columns in Excel worksheet is copied below.ДЄnother method to achieve the same result described above is to select the Columns you want to hide first and then run command 'Hide Columns' from Excel Ribbon > 'Home' Tab > 'Cells' Group > 'Format' > 'Hide & Unhide', as shown in below image. The skipped Column letters between Column A and Column D are hidden. You can see from below images that the selected Columns in above example are hidden.ДЄ double-line between Column letter A and Column letter D shows that there are Columns hidden between those Columns. After selecting the Columns, right-click on the selected Columns and click 'Hide' from the context menu as shown below. To hide Columns from Excel worksheet, first select the Columns which you want to hide. Hiding Columns from Excel worksheet is very useful if you do not want to display some Columns of Excel worksheet containing sensitive/unwanted information to other users or if you do not want some Columns of sensitive/unwanted information appear in Excel worksheet's printouts.

After you hid Columns from Excel worksheet, the hidden Columns are not printed. You can hide a Column or a Range of Columns from Excel worksheet. For instance, one user may want to hide columns while the other may wish to view the entire data in one go.Sometimes you may want to hide some sensitive or unwanted columns from your Excel worksheet. With the вЂњcustom view,вЂќ a user can save particular display settings.

Select the highlighted part and follow any preceding technique (methods #1 to #4) to unhide columns B and C.

Moreover, a line between the column labels appears that shows the hidden columns.

The visible part of the table is highlighted (shown in the succeeding image).

Click вЂњspecialвЂќ and select the check box вЂњvisible cells only.вЂќ Click вЂњOk.вЂќ.

In the Home tab, click вЂњfind and selectвЂќ drop-down and choose вЂњgo to.вЂќ Alternatively, click вЂњgo to special.вЂќ.

The steps to locate and unhide the hidden columns are listed as follows: Alternatively, in the Home tab, click вЂњfind and selectвЂќ drop-down and choose вЂњgo to.вЂќ read more (shown in the succeeding image) and press the вЂњEnterвЂќ key. The name is usually the row character followed by the column number, such as cell A1.

Type A1 in the name box Name Box In Excel, the name box is located on the left side of the window and is used to give a name to a table or a cell.

The steps to unhide only the first column are listed as follows: read more is unknown and the cell data is known. For instance, if we have data in cell A2 and want to use that in cell A1, use =A2 in cell A1, and this will copy the A2 value in A1. Note: This method works in case the cell reference Cell Reference Cell reference in excel is referring the other cells to a cell to use its values or properties.

Select any preceding technique (methods #1 to #4) to unhide columns B and C.

Click вЂњfind nextвЂќ and close the вЂњfind and replaceвЂќ dialog box.

Click вЂњoptions>вЂќ and select the check box вЂњmatch entire cell contents.вЂќ.

Enter the data of one of the hidden cells in the вЂњfind whatвЂќ box.

Press вЂњCtrl+FвЂќ and the вЂњfind and replaceвЂќ dialog box appears.

Choose any preceding technique (methods #1 to #4) to unhide columns B and C.

Specify any cell reference of the hidden column like B1:C1 in the вЂњgo toвЂќ dialog box.

In the Home tab, click вЂњfind and selectвЂќ drop-down and choose вЂњgo to.вЂќ Alternatively, press the shortcut key F5.

In the succeeding image, column B and C are hidden.

Enter any number as the вЂњcolumn width.вЂќ.Right-click on the selected columns and choose вЂњcolumn width.вЂќ.Right-click on the selected columns and choose вЂњunhide.вЂќ.Press the shortcut вЂњAlt H O U L.вЂќ Press one key at a time.From the вЂњhide and unhideвЂќ option, select вЂњunhide columns.вЂќ.In the Home tab, under the вЂњcellsвЂќ group, click the вЂњformatвЂќ dropdown.Select the columns to the left and right of the hidden column.