View original (French)

Unhide all hidden columns and rows

Solved
mousaillon Posted messages 61 Status Membre -  
oumnas Posted messages 19 Status Membre -
Hello,
I work with Excel 2010 on XP Pro. We have already seen in other discussions how to hide all empty and unnecessary rows and columns as follows:
A little reminder:
Position yourself on the first column to be deleted
Ctrl + Shift + Right Arrow then right-click and Hide for columns
Position yourself on the first row to be deleted
Ctrl + Shift + Down Arrow then right-click and Hide for rows.
For me, I only need to see a certain number of rows and columns. It's an aesthetic choice to only see a range that serves as an interface with buttons and macros. I could have gone for an automatic opening of a UserForm but I made this choice for ease of evolution and use for other users.
But what I would like to know is the reverse operation. I have tested quite a few things but nothing works. Rest assured, I haven't saved this deletion until I have the reverse solution.
If anyone has the solution, it would really help me out. Thank you.

4 réponses

Réponse 1 / 4
Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   6 453
 
Hello
.. I don't quite understand the problem, since to display it, you just need to select the columns before and after the hidden one, and right-click "unhide"?

Best regards

--
The quality of the answer largely depends on the clarity of the question, thank you!
2