My boss thinks I did this but....

esfransen

New Member
Joined
Nov 12, 2002
Messages
4
Greetings all,
We have a spredsheet that has two cells that are hidden right in the middle of cells are displayed. In other words, if there are a group of cells that are arrainged three by three, the middle cell is hidden the formatting is set to general, the sheet is unprotected. And my boss thinks I did this and it is not desired but I don't know it came about. I even pasted special from where the formatting is correct into this cell but to no avail. Please help.
Eric
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

RichardS

Well-known Member
Joined
Feb 16, 2002
Messages
761
You haven't accidentally hidden coluumns or rows, have you? Do the columns labels go in alphabetical order and row labels in numeric? Or am I being a bit simplistic.

Richard
 

esfransen

New Member
Joined
Nov 12, 2002
Messages
4
Thanks for your responses. No rows or columns are hidden, all are in sequnetial order. By hidden I mean you a=cannot see the reult of the formula in the cell unless it is highlighted. Highlighted by selecting more than one cell so the "hidden" cell is in the purple highlighting. The font color is set to automatic.
Eric
 

Von Pookie

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686

ADVERTISEMENT

Maybe there's a conditional format set?

Select the "hidden" cell, then go to Format|Conditional Formatting and see if there are any conditions set.
 

esfransen

New Member
Joined
Nov 12, 2002
Messages
4
oops I take that back. Not being fluent in conditional formatting I looked there and saw that there were no conditions selected 1,2 or 3, but there was a less than condtion formula to set the color to white! thanks for the prompt to look again!
Eric
 

Watch MrExcel Video

Forum statistics

Threads
1,122,418
Messages
5,596,028
Members
414,039
Latest member
southike

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top