Can i hide columns in excel

You can hide, and later unhide, columns by right-clicking in the spreadsheet. You can also achieve this by using the drop-down menu in the home tab. Select the column you wish to hide. Select an entire column by clicking on its corresponding letter at the top of the page. Right-click to hide columns. Highlight the column on either side of the column you wish to unhide in your document. Select multiple columns by clicking on the letter at the top corresponding to each column and holding the shift key.

Highlight adjacent cells to unhide a hidden column. You can also manually click or drag to expand a hidden column. Hidden columns are indicated by a thicker line. Move your cursor over this line until it turns into a double bar with arrows. Double click to reveal the column or click and drag to manually expand the hidden column.

Navigate to the "Visibility" section. You'll find options to hide and unhide both rows and columns. Select "Unhide Columns" from the list. At other times, you might be printing your worksheet and want to print only columns A—F and columns H—J, skipping column G. Rather than rearrange your worksheet for either of these examples, you can simply hide the information. You can also hide information in specific cells.

You can hide columns of your worksheet containing information that you do not need to view or do not want to print. On the Home command tab, in the Cells group, click Format. The column is hidden. Select at least one cell from both of the columns around the hidden column s to be redisplayed.

The column reappears. This option works well for redisplaying column A, since there are not columns on both sides of column A. Hold your cursor between column IDs on the right side of the hidden column. The cursor will change to an open, double sided arrow as shown here.

The row is hidden. Select at least one cell from both of the rows around the hidden row s to be redisplayed. The row appears. The following steps below outline how to use the Group option in Excel for versions , , , and Grouping only works with Columns and Rows that are contiguous together.

Not only are your columns or rows hidden but Excel has added show hide buttons to help you toggle your view:. Did you like this step-by-step tutorial? Watch it completely free! Topics: Excel.