Mar 24 2012
In Excel 2007, quickly hide and show specific ranks-excel2003 tutorial-excel tutorial-office tutorial network: today OFFICE tutorial to solve the problem: in Excel 2007 to quickly hide and show specific ranks; quickly take a look at it when the same Excel spreadsheet requires several different display formats. Such as payroll records table Microsoft office 2007, accountants in the treatment may need to show staff job title, grade, and other related information, but in print it out to the staff to see today OFFICE tutorial to solve the question is: In Excel 2007, fast hide and show specific ranks; hurry to see it
Sometimes with an Excel spreadsheet requires several different display formats. Get rid of the header horizontal line, such as payroll records table, accountants may need in dealing with personnel at the same time show titles, grades and other information, but in print it out to the staff to see when there is no need shows, as long as the amount on linea. This requires that before the print to the staff to see a list of these titles, grade specific column hidden. So always repeat the hidden display ranks is obviously a lot of trouble. There are two ways to quickly hide the display specific ranks in Excel2007.
The first one: Outline
The classification in Excel functions can be simple to quickly hide and display the specified ranks. To hide the title, grade, performance where C, D,, F, column, for example:
C, D, column select, switch to the Data tab, click the portfolio icon on the worksheet side will show the classification of the 1,2 button. Select Column F, the same combination. Simply click a button to hide columns C and D, F, and click the 2 button to restore the display. Click on column E – button can only hide columns C, D, and click again to restore the display. Line is the same settings, but the combination underwent 1, 2 button is the left side of the line the subject.
Note: The hidden rows or columns will also be selected by dragging the selection or press the Shift key to select, copy and paste, you will find the hidden content copied.This can be a drag, or press the Shift key to select the area, and then click Alt +; key combination, which would select only visible cells, not including those hidden rows or columns.
The second measure: save view
On the View tab, click Custom View to open the View Manager window, click the Add button, enter a name for all, to determine an all displayed can be increased in the View Manager window. Then look at the list to employees need to select the C and D, F, column right-click choose to hide, and then click Custom View to open the View Manager window office 2007, click Add to increase employee. You can also by a variety of needs free to hide the corresponding ranks, and then add the other view.
Simply click to view Explorer window, open a custom view from the double-click selection of the staff version of the View tab to hide the corresponding column into the form to the staff to see in the View Manager, double-click Show All you can restore the hidden state. So that all the hidden ranks of operation can be completed by a double-click is not very easy to use them?