Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .