ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   unhide all? (https://www.excelbanter.com/excel-discussion-misc-queries/189444-unhide-all.html)

annoni

unhide all?
 
Is there a shortcut to unhide all columns and rows that are hidden at once?

Mike H

unhide all?
 
Hi,

Select everything on the sheet by clicking the box to the left of A for
column A

Hold down the Alt key and tap

O R U
O C U

Mike

"annoni" wrote:

Is there a shortcut to unhide all columns and rows that are hidden at once?


annoni

unhide all?
 
I've just found out how from the previous answers....

Select the worksheet (clicking by top right corner) format column
unhide...Thanks.

"annoni" wrote:

Is there a shortcut to unhide all columns and rows that are hidden at once?



All times are GMT +1. The time now is 06:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com