Thread: hidden cells
View Single Post
  #4   Report Post  
Mark
 
Posts: n/a
Default

there are no cells to select the author has selected the entire sheet and
hidden the cells all that is visible is the colum letters, no rows are
visible is there a way to reveal these cells?

"CyberTaz" wrote:

Select the cells and go to FormatCellsProtection and clear the Hidden
checkbox. You may als be dealing with a sheet that has been Protected, in
which case that option will not be active. If so, go to
ToolsProtectionUnprotect Sheet first. If you don't get prompted for a
Password you should then be able to change the Hidden property. If there is a
Password prompt & you don't have the password you'll need to contact whoever
supplied you with the file.

Good Luck |:)

"Mark" wrote:

i have been sent a work book where one of the sheets is blank it appears that
all of the cells have been selected and then hidden is there any way i can
get them back?