Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Select the common row and column header (top left corner above "1" and to
the left of "A"). This selects all cells on the worksheet. You can then access the format cells function. HTH |
#2
|
|||
|
|||
hidden cells
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
have tried this but am unable to select a row i beleive they selected the
entire sheet by clicking on the top left corner and then clicked 'Hide' if i type in the cell no i can view what is written but i can't click any where to 'unhide' any suggestions? Thanks Mark "Kev Nurse" wrote: Select the common row and column header (top left corner above "1" and to the left of "A"). This selects all cells on the worksheet. You can then access the format cells function. HTH |
#7
|
|||
|
|||
I think he was trying to hide a few rows of data but it looks like he
selected the entire sheet and then clicked 'Hide' if i type in the cell no i can read the data but there doesnt appear to be any way to 'Unhide' the rows. any ideas? Thanks Mark "Gord Dibben" wrote: 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? |
#8
|
|||
|
|||
Many thanks to all who responded i have since figured it out so for the
benifit of those with a similar problem 1, manually locate a cell i.e. B1 2, selct format, row, unhide 3, this shows row 1 you can now select the entire row and unhide the remaining rows 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hidden cells ????? | Excel Worksheet Functions | |||
Hidden Cells????? | Excel Worksheet Functions | |||
copy only non hidden cells | Excel Worksheet Functions | |||
Chart disappears when source data cells are hidden | Excel Discussion (Misc queries) | |||
Calculating without including Hidden Cells | Excel Discussion (Misc queries) |