When working with data sheets, you may create figures that are sensitive, or that make the worksheet look messy. Hiding columns in Excel 2007 is an easy way to clean up messy calculations, or protect sensitive data from public view. Hiding columns doesn't change or eliminate the data; they are still present. They are simply not displayed.
To hide a column in Excel 2007, select the entire column. Select Home > Format > Hide & Unhide > Hide Columns. The selected column is hidden, and you are returned to the active worksheet. Effectively, this action sets the column width to 0. You may also hide a column using the Home > Format > Width command. In the dialog box, set the column width to 0. Your column will be hidden.
You may hide multiple columns simultaneously by selecting all columns to be hidden and using the Hide Columns dialog box, or the Width command to set the selected columns' widths to zero. The columns you select can be adjacent or non-adjacent.
Excel provides a keyboard shortcut for hiding columns. Select a cell in the column you wish to hide. Press Ctrl + 0. The column will be hidden. Alternately, you can select the column header. Right-click to activate the contextual menu and select "Hide." The column will be hidden.
Excel will not display the column header for hidden columns, but you may still refer to hidden columns in formula. Searches will still be performed on hidden columns as well.
To unhide a column, select at least one cell on both the left and right of the hidden column(s). Select Home > Format > Hide & Unhide > Unhide Columns. Your hidden column(s) will reappear.
Excel also provides a similar keyboard shortcut to unhide columns. Select at least one cell on either side of the hidden column(s). Press Ctrl + ) to unhide the column(s). Alternately, you may right-click your selection and choose "Unhide" from the contextual menu.
ไม่มีความคิดเห็น:
แสดงความคิดเห็น