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. (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.Unhide a single column by click-and-dragging the double-bar (which represents a hidden column) in the column header. The sheet owner and Admins can unhide all columns by clicking the More icon in any header and selecting Unhide All Columns.
Then click the More icon and select Hide Column. To hide multiple columns, hold down the (Windows) / (Mac) key as you single-click on the header of each column you want to hide.
To hide a single column, hover over the column name and then click the More icon. While collaborators with Editor and Viewer access won't be able to unhide the columns within Smartsheet, they can export the sheet to Excel or send it as an Excel attachment and un-hide the columns from that program. Hiding is useful when your goal is to format the sheet such that it displays only the most relevant information. The filter will impact only your view of the sheet and other collaborators can apply their own filters as needed. Though this functionality isn't available for rows, you can apply a filter to the sheet to hide rows based on criteria they contain. The sheet owner and licensed collaborators with Admin access to the sheet can hide a column to remove it from view while still keeping its content available in the sheet.
0 kommentar(er)
