Quickly hide and display specific columns in Excel 2007

Sometimes the same Excel table requires several different display formats. For example, payroll records, accounting staff in the process may need to display the staff's title, grade and other related information, but when printed out to employees to see when this information is not necessary to show, as long as there is money on the line. This requires that specific columns such as titles, levels, and so on be hidden before the list is printed to the employee. It is obviously troublesome to repeat the display of the list. There are two ways in Excel2007 to quickly hide the display of specific columns.

The first trick: grading display

The outlining feature in Excel enables you to quickly hide and display specified rows and columns. To hide the title, grade, the performance of the C, D, F listed as an example:

Select the C, D columns, switch to the Data tab, and click the Group icon, which displays the rating 1, 2 buttons on the side of the worksheet. Also select column F to combine. Now just click the 1 button to hide the C, D, f columns and click the 2 button to restore the display (Figure 1). If you click the "-" button on the e column, you can hide only the C and D columns, and then click Resume Display again. The same is true for rows, except that the 1 and 2 buttons that are then placed on the left side of the row.

Note: Hidden rows or Columns are selected at the same time as they are selected by dragging or pressing the SHIFT key, and when you copy and paste, you will find that the hidden content is also copied. For this, you can click ALT + when you drag or press the SHIFT key to select the area. Key, so that only visible cells are selected, not the rows or columns that are hidden.

Second trick: Save the View

In the View tab, click Custom View to open the View Manager window, click the Add button, enter the name Show all (Figure 2), and make sure that you can add a show all item in the View Manager window. Then press the list of employees to see the C, D, f column, select Hide, and then click Custom View to open the View Manager window and click Add to increase an employee edition item. At this point you can also hide the rows as you want, and add other view items.

Just click Custom View on the View tab to open the View Manager window (Figure 3), double-click the "Employees" button to hide the column into a table for employees, and in the View manager, double-click Show All to restore the status that is not hidden. So all the hidden row and column operations can be done through a double click, is it quite simple?

The above two methods of operation are very simple, specific which is more practical depends on your own needs.