ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Hidden cells ????? (https://www.excelbanter.com/excel-worksheet-functions/10827-hidden-cells.html)

T.B.

Hidden cells ?????
 
How do you tell where a hidden cell is ? I have a colume that will not add
up correctly and I think I have a hidden Cell Somewhere. How to find it , how
to fix it, and how did it get hid in the first place? Thank you Please
Help!
--
TB


hi,
hidden cell - no.
hidden row - maybe
hidden column - maybe
Select the entire sheet
goto formatrowsunhide
goto formatcolumnsunhide
all hidden rows and columns should be visible now.

-----Original Message-----
How do you tell where a hidden cell is ? I have a

colume that will not add
up correctly and I think I have a hidden Cell Somewhere.

How to find it , how
to fix it, and how did it get hid in the first

place? Thank you Please
Help!
--
TB
.


Ken Wright

Please stick to your original thread - You have already had an answer and a
request for clarification of your problem.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

wrote in message
...
hi,
hidden cell - no.
hidden row - maybe
hidden column - maybe
Select the entire sheet
goto formatrowsunhide
goto formatcolumnsunhide
all hidden rows and columns should be visible now.

-----Original Message-----
How do you tell where a hidden cell is ? I have a

colume that will not add
up correctly and I think I have a hidden Cell Somewhere.

How to find it , how
to fix it, and how did it get hid in the first

place? Thank you Please
Help!
--
TB
.





All times are GMT +1. The time now is 07:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com