Hold your cursor between row IDs where the hidden row is located. This option works well for redisplaying row 1, since there are not rows on both sides of row 1. Select at least one cell from both of the rows around the hidden row(s) to be redisplayed.ĮXAMPLE: If row 5 is hidden, select a cell from rows 4 and 6.įrom the Format menu, in the Visibility section, select Hide & Unhide » Unhide Rows. Select a cell within the row(s) to be hidden.įrom the Format menu, in the Visibility section, select Hide & Unhide » Hide Rows. You can hide rows containing information that you do not need to view or do not want to print. The cursor will change to an open, double sided arrow as shown here.
![to unhide a column in excel to unhide a column in excel](https://www.easyclickacademy.com/wp-content/uploads/2019/04/How-to-unhide-columns-in-excel-unhide-first-column-1024x576.png)
Hold your cursor between column IDs on the right side of the hidden column. This option works well for redisplaying column A, since there are not columns on both sides of column A. HINT: If you cannot select the appropriate cells, you can use the Go To command.įrom the Format menu, in the Visibility section, select Hide & Unhide » Unhide Columns. Select at least one cell from both of the columns around the hidden column(s) to be redisplayed.ĮXAMPLE: If column B is hidden, select a cell from both columns A and C.
![to unhide a column in excel to unhide a column in excel](https://d295c5dn8dhwru.cloudfront.net/wp-content/uploads/2019/08/07123320/26.png)
On the Home command tab, in the Cells group, click Format.įrom the Format menu, in the Visibility section, select Hide & Unhide » Hide Columns. Select a cell within the column(s) to be hidden. You can hide columns of your worksheet containing information that you do not need to view or do not want to print. You can also hide information in specific cells. Rather than rearrange your worksheet for either of these examples, you can simply hide the information. At other times, you might be printing your worksheet and want to print only columns A–F and columns H–J, skipping column G. This article is based on legacy software.Īt times, there may be information in your worksheet which you no longer need to see. (Archives) Microsoft Excel 2007: Hiding Columns, Rows, and Cells (Archives) Microsoft Excel 2007: Hiding Columns, Rows, and Cells.Learn more about UWEC's COVID-19 response. Student Expression, Rights & Responsibilities.
![to unhide a column in excel to unhide a column in excel](https://cdn.ablebits.com/_img-blog/unhide-columns/select-table-icon-excel.png)
#TO UNHIDE A COLUMN IN EXCEL HOW TO#
Here in this example, hidden Columns are Column B and Column C.Īn animation about how to unhide hidden Columns in Excel worksheet is copied below.Īnother method to achieve the same result described above is to select left-side and right-side Columns of the hidden Columns and then run command "Unhide Columns" from Excel Ribbon > "Home" Tab > "Cells" Group > "Format" > "Hide & Unhide", as shown in below image. You can see from below image that the hidden Columns between Column A and Column D are unhidden. Left-side and right-side Columns of the hidden Columns are Column A and Column D. In this example, Columns B and C are hidden. 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 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.
![to unhide a column in excel to unhide a column in excel](https://excelunlocked.com/wp-content/uploads/2020/02/How-to-Hide-or-Unhide-a-Row-or-Column-in-Excel.png)
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. Sometimes you may want to hide some sensitive or unwanted columns from your Excel worksheet.