Unhide ALL hidden rows & columns in Excel

[aretotaco]

Hi, I would like to unhide all hidden rows and columns in every tab of different Excels.

I have a for each file in folder activity which processes every excel file that I have. In the process, I want to unhide all hidden rows and columns in the Excel without having to edit the trust/macro settings in the Excel (if using vba).

I have tried vba but it requires the macro setting to be set in the Excel.

I have also tried keyboard shortcut of ctrl shift 9 and ctrl shift 0 but it does not unhide all hidden cells.

[ABHIMANYU_THITE1 (ABHIMANYU THITE)]

Hi @aretotaco

Rather than using Shortcut on excel, VBA is the more reliable thing.

Sub UnHideColumns()
Sheets(“Sheet1”).Columns(“A:Z”).Hidden=False
End Sub

Replace Sheet1 - with your sheet name
Replace A:Z with your range of columns
you can check out image is to apply trust setting

[Gokul_Jayakumar (Gokul Jai)]

Hello @aretotaco
Try this for send hot key

1. Use excel application scope
2. Use Send hot key activity with CTRL+A to select all. Need to indicate the excel sheet
3. Delay for 2 seconds
4. Use sendhotkey with CTRL+ HOUL (For unhide column) or CTRL+HOUO(For unhide row)
5. Use save work book activiuty
   
   

Note: Above hot key is used for MS 2021. Key may changes for different version