Tuesday, June 21, 2011

Excel - how to display the column a

One of the major features of Microsoft Excel is that we can hide individual columns, column groups, and even several groups of columns. Similarly, we can hide the lines.

For example, to hide the columns e and F, just click and drag the e header on the e column in the header of column (f) f. Then, right-click in the selected E - F header and select hide from the popup menu.

When we want to see again the hidden columns, the show command is used.

Continuing the same example, click on the header D (or any header before the hidden columns) and drag on the hidden columns in the column to the right (in this case G). Click the headers of D - G selected, and then select Show.

This is nothing to hide and show columns.

But what happens if you have hidden A column? There is no column on the left that you select and drag. How we can display A column?

This is a non-obvious feature of Excel comes into play.

The box at the intersection of the letters of the column and line numbers is the key. If you click on this box, you select all the rows and columns.

Once they are selected, simply click on one of the letters of the displayed column. Which will display the popup Menu. Select view from the menu, and you are done.

Related Post :

0 comment:

Post a Comment