Some columns went missing...

G

Guest

i can't view column's B through D on a spreadsheet of mine. it skips right
from column A to column F. I tried the 'unhide' function to see if they had
been hidden (the spreadsheet is accessed and used by multiple people) but it
appears that they have not - nothing becomes unhidden when i select the
adjacent column then go to format>column>unhide.

If the columns were deleted, the alphabet wouldn't be broken up like that,
right? I have also tried freezing and unfreezing panes... everything. i can't
find these colums.

any help or advice on how to see them, or figure out where they went would
be wonderful. thanks in advance.
 
G

Guest

Try this.
Instead of clicking on the column header, go to the little grey box where
the column headers and the row headers meet ( top left corner).
Click on it so that it highlights the whole page and then right click on any
column header and select unhide.

HTH
Michael M
 
C

CLR

Perhaps their column widths have been set to zero..........

Vaya con Dios,
Chuck, CABGx3
 
G

Gord Dibben

Could be that the columns' width has been set to a small number like 0.1

Select across A:E and Format>Column>Width>8.43


Gord Dibben MS Excel MVP
 
J

jonny

xosder said:
i can't view column's B through D on a spreadsheet of mine. it skips right
from column A to column F. I tried the 'unhide' function to see if they had
been hidden (the spreadsheet is accessed and used by multiple people) but it
appears that they have not - nothing becomes unhidden when i select the
adjacent column then go to format>column>unhide.

If the columns were deleted, the alphabet wouldn't be broken up like that,
right? I have also tried freezing and unfreezing panes... everything. i can't
find these colums.

any help or advice on how to see them, or figure out where they went would
be wonderful. thanks in advance.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with conditionally unhiding columns 1
Unhide column difficulty 3
MS Excel unhiding columns tip 1
How can I see column headings of hidden columns in Excel before u. 10
Button hides unhides columns, how? 3
filters for selective columns? 2
Problem sorting a range of columns using VBA 1
Chart disappears if you hide rows/colums with data. 1

Top