![how to hide and unhide a column in excel how to hide and unhide a column in excel](https://cdn4syt-solveyourtech.netdna-ssl.com/wp-content/uploads/2015/06/excel-2010-unhide-column-a-5.jpg)
Using the Ctrl + D shortcut fills a column instead of a row. To fill more than one cell, select the source cell and press Ctrl + Shift + Right arrow to select additional ones.
![how to hide and unhide a column in excel how to hide and unhide a column in excel](https://www.knowledgewave.com/hs-fs/hubfs/hideexcelrows4.png)
In Microsoft Excel and other spreadsheet programs, pressing Ctrl + R fills the row cell(s) to the right with the contents of the selected cell. Ctrl+Shift+) to Unhide Columns – If this doesn’t work for you try Alt,O,C,U (old Excel 2003 shortcut that still works).There are several dedicated keyboard shortcuts to hide and unhide rows and columns. What is the shortcut key to unhide columns in Excel?
HOW TO HIDE AND UNHIDE A COLUMN IN EXCEL HOW TO
How to delete the strikethrough rule in Excel?.How to apply strikethrough to range of cells in Excel?.What is the keyboard shortcut for strikethrough in Excel?.How to use keyboard shortcut to unhide columns in Excel?.How do you unhide columns quickly in Excel?.What is the shortcut key to unhide columns in Excel?.University of Wisconsin-Eau Claire 105 Garfield Avenue P.O. The dialog box refreshes to display options corresponding to the selected category. Under Category, make the appropriate selection.
![how to hide and unhide a column in excel how to hide and unhide a column in excel](https://www.dummies.com/wp-content/uploads/72747.image0.jpg)
In the Type text box, type three semicolons ( ). You have the ability to hide the contents of individual cells if you do not need to view their contents or you simply do not want to print certain cells.įrom the Home command tab, in the Cells group, click Format » select Format Cells. 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. 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.
![how to hide and unhide a column in excel how to hide and unhide a column in excel](https://www.got-it.ai/solutions/excel-chat/wp-content/uploads/2019/08/16.png)
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. 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