![]() ![]() 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. 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. (Legacy) Microsoft Excel 2007: Hiding Columns, Rows, and Cells ![]()
0 Comments
Leave a Reply. |