hide and unhide row or clumn

[rizexcel]

Is hide/unhide row/column function available in excel?

 

[VoG]

See Show or hide columns and rows - Excel - Office.com

 

[rizexcel]

Is hide/unhide row/column function available in excel?

 

[sweeneytime]

Highlight row/column, right click, hide/unhide is at the bottom.

 

[rizexcel]

Thanks for reply. Actually I want to know hide/unhide function like hide() or hiderow() etc.

 

[VoG]

Do you mean in VBA like this

Rows("5:10").Hidden = True

 

[rizexcel]

yes

 

[sweeneytime]

No worries, you'll make it easier on those answering if you mention you would like the VBA code instead of mentioning excel,

Cheers,
Sweeneytime

Sub hide()

    Range("A1").EntireColumn.Hidden = True
    Range("A1").EntireColumn.Hidden = False
    
    Range("A1").EntireRow.Hidden = True
    Range("A1").EntireRow.Hidden = False
    
    
    


End Sub

 

[rizexcel]

any relative function in excel?

 

[rizexcel]

Can a particular row or column be hide through formula in excel?