Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

-- 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?

share|improve this question
Format > Rows > Show 


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.

share|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? – Dan Rosenstark 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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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