Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

-- 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
add comment

1 Answer 1

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.

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? –  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
add comment

Your Answer

 
discard

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.