hiden columns in excell

[scottian]

I have an excell spreadsheet that has been asked to look at, ive noticed that a number of columns are hidden however ive tried to resize the columns but no luck, also the workbook and spreadsheets arent protected, any ideas how i view the hidden columns

"My God! It's full of stars...

 

[jonsi]

Highlight from the Column before the hidden ones until the column after. Then Right Click. Choose Unhide.

 

[AnotherHiggins]

Select all cells - either press <CTRL>+<A> or click in the box to the left of A and above 1. Now click on the line between the A and B column headings. Drag it left or right just a touch.

As long as the sheet is not protected, any cells that were hidden will now be visible and will have the same width as all other cells.

Advantage over using UnHide:
A column width that is set to 0 will not become visible by using the "unhide" method.

Hope that helps.

[tt]__________________________________________
My name is John, and I approved this post.[/tt]

To get the best answers fast, please read faq181-2886

 

[asrisk]

Another alternative: hover the mouse between the two column headings (e.g. A and C), you will see the pointer change to the icon for column resizing. Move right slightly, and the thick vertical bar of the resize icon will become two thinner parallel ones - click and drag to the right and the hidden column will be revealed.

-------
I am not responsible for any "Sponsored Links" which may appear in my messages.

 

[KenWright]

Click the grey square above the Row Header 1 and to the left of the Column header A.

Do Format / Column / Unhide

then

Format / Column / Width / Standard Width

All should now be visible, though do note you will lose any changes you have made to other column widths.

Regards
Ken................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------