up vote 0 down vote favorite
share [g+] share [fb]

-- Excel 2003 SP3 --

I have a spreadsheet which I know for certain has a large amount of hidden rows which are correctly hiding on my colleagues machines, and were correctly hiding on mine two days ago, but this morning I find the hidden flag is being ignored and all that hidden data is rendered.

Is there some checkbox, configuration option, or function key I have accidentally pressed or need to press?

link|improve this question
feedback

1 Answer

up vote 0 down vote 
Format > Rows > Show

and

Format > Rows > Hide

No function key for these commands, unless someone has recorded a macro to execute them and assigned it to a key combination.

link|improve this answer
Dont' have Excel to try this right now, but can't you just select the rows and right click to the left of them? – Yar Mar 20 '10 at 17:39
No, this is how to hide/show them actively. My problem is that data which is hiding when other people view it is not hiding when I view it. The hiding part is not working. – annakata Mar 22 '10 at 12:22
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.