View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MT Stringer MT Stringer is offline
external usenet poster
 
Posts: 1
Default how do I open a hidden column?

Maybe the columns aren't "hidden" afterall. If the "unhide" methods don't
work for you, the column width may be set to zero. To test this theory, click
the button at the top left corner of the spreadsheet. It will select the
entire worksheet. Go to Format-columns-width and enter a value such as 21.
That should set all column widths at 21 pixels. You will find out immediately
if the column widths are set to zero. You can always "undo" if that doesn't
work or if it messes up your other column widths.
Good luck.
Mike

"JP" wrote:

This is a spreadsheet with hidden columns that I need to see.
Clicking & dragging at the top of the column is not working.
Could this be a protection problem?