Excel Macro VBA Tip 8 – Hide UnHide Rows and Columns in Excel with a Macro

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.

Learn to hide and unhide columns and rows in Microsoft Excel using a macro. This is a great lesson to learn if you want to display a limited amount of information without having to delete any excess information or data. This tutorial teaches you how to hide multiple columns and rows as well as unhide them in Excel with a macro.

For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachMsOffice.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

(Visited 1 times, 1 visits today)

You might be interested in

Comment (5)

  1. sweet vid!!! i need some help though, please help if you can. is there a way i can tell it to look at a cell reference, then hide rows accroding to the contents of that cell?

  2. Thanks for the nice tutorial. I've got another question regarding the hide/unhide macro. Is it possible to hide rows without specifying numbers, i.e., "hide/unhide the next 4 rows"? I've like to create a macro that I can repeat throughout a worksheet without constantly updating the row numbers in visual basic.

LEAVE YOUR COMMENT

Your email address will not be published. Required fields are marked *