Hidden rows or columns have a double line in the row/column list One reason to hide a row or column is so you can take a quick screen image of a summary without the intervening columns. Now the month and total columns appear beside each other. Go to Home | Cells | Format and select Hide & Unhide | Hide Rows. More on unhiding below but for the moment …: to unhide just add the Shift key:Ĭontrol + Shift + 0 – unhides a column. Select the columns or rows, right-click and choose Hide. Hidden rows/columns still work in calculations, they can be referenced in formulas etc. Make your worksheets look more compact and focused by hiding unwanted columns or rows.
University of Wisconsin-Eau Claire 105 Garfield Avenue P.O.Thanks for joining us! You'll get a welcome message in a few moments. Under Category, select the appropriate date, time, or number format. 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. Hold your cursor between row IDs on the side of the hidden row. 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, select Row » Unhide. Macintosh: Press and click the row ID » select Hide. Windows: Right click the row ID » select Hide. Select a cell within the row(s) to be hidden. If there is information on your worksheet you do not need to see or if you want to print only certain rows, you can hide those rows you do not want to see or print. Macintosh: Press and click » select Unhide. The cursor will change to an open, double sided arrow as shown here. Hold your cursor between column IDs on the 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, select Column » Unhide. 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. Macintosh: Press and click the column ID » select Hide. Windows: Right click the column ID » select Hide. Select a cell within the column(s) to be hidden.įrom the Format menu, select Column » Hide. If there is information on your worksheet you do not need to see or if you want to print only certain columns, you can hide those columns you do not want to see or 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) Excel 2003/2004: Hiding Columns, Rows, and Cells
0 kommentar(er)
