Group columns for instant hiding and unhiding


November 9th, 2005 by admin admin

There are times when you need to hide a group of columns. At other times, these columns needs to be unhidden and another set of columns needs to be hidden. If you are in such a situation, this is something you should look at.

Assuming below is the layout for a worksheet.

A        B        C        D        E        F        G        H

1
2
3
4
5

To hide column A, E and F at one go, this is what you should do.

1. Go to Cell A1. From the menu bar, select data, group and outline, group. In the popup box named group, select columns.

2. Highlight the cells E1 and F1. From the menu bar, select data, group and outline, group. In the popup box named group, select columns.

3. You will notice that there are 2 buttons called 1 and 2 on the top left hand corner above the column labels. See diagram.

When you click on 1, the column A, E and F will be hidden. When you click on 2, the columns will appear again. You can try grouping more columns and see how the presentation changes.

Leave a Reply

You must be logged in to post a comment.

s2Member®