Excel Macro code to Unhide all Rows and Columns

Home
Macros Code
Worksheet Macro code
Unhide all Rows and Columns

How to Unhide all Rows and Columns in excel sheet through VBA Macro Code

For using this VBA macro code in excel to Unhide all Rows and Columns you will have copy below Macro code in Excel Visual Basic Editor

Sub UnhideRowsColumns()
Columns.EntireColumn.Hidden = False
Rows.EntireRow.Hidden = False
End Sub

Unhide all Rows and Columns in excel: Instead of unhiding rows and columns on by one manually you can use this code to do this in a single go.

Excel Template Categories

Download Free PowerPoint Templates

Blue-Fluid-Business-Plan-powerpoint-template-or-google-slides-theme-720x405-1

Abstract ink Drop PPT template Feature image

3D-Printers-PowerPoint-Diagram-post-image

Arrows-bar-banner-PowerPoint-Diagram-Template-post-image

Brainstorming-PowerPoint-Diagram-Template-post-image

Business-man-banner-PowerPoint-Diagram-Template-post-image

What is a Macro Code?

In MS Excel, macro code is a programming code which is written in VBA (Visual Basic for Applications) language.

The idea is to use macro code for automating various activities which you perform manually in Excel, otherwise.

For example, you can use a code to print only a particular range of cells just with a single click instead of selecting the range -> File Tab -> Print -> Print Select -> OK Button.

How to use a Macro Code in Excel

Before you use excel VBA codes, make sure you have your developer tab on your Excel ribbon to access VBA editor. Once you activate developer tab you can follow below steps to paste a VBA code into VBA editor.