Cyber

When a cell has the "hidden" property enabled it just hides the cell contents
in the formula bar.

It will still show up in the cell itself so don't think this is OP's problem.

Mark

Why do you think data is hidden?

Do you see anything in the formula bar when you select a cell?

Are your row numbers and column letters consecutive or some missing?

If so, hit CTRL + A(twice in xl2003) and right-click on a row or column header
and "unhide".

OR..........Perhaps both Cyber's "hidden" and a custom format of ;;;


Gord Dibben Excel MVP



On Wed, 23 Feb 2005 07:35:10 -0800, "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?