Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Hiding rows in Excel 2007 using macros

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 16-10-2009
Member
 
Join Date: Apr 2009
Posts: 42
Hiding rows in Excel 2007 using macros
  

I am using excel 2007 on my windows xp computer and i want to know the procedure for Hiding rows in Excel 2007 using macros. Do i need to change any setting any work sheet to hide row?

Reply With Quote
  #2  
Old 16-10-2009
Member
 
Join Date: May 2008
Posts: 4,828
Re: Hiding rows in Excel 2007 using macros

A very handy feature of Excel is its ability to hide rows and columns from a sheet without affecting calculations in any way. To hide row in excel 2007 : Right click on the row header of the row to be hidden. Choose Hide from the menu. The selected row and the row number will be be hidden from view.
Reply With Quote
  #3  
Old 16-10-2009
Member
 
Join Date: Dec 2008
Posts: 371
Re: Hiding rows in Excel 2007 using macros

Follow the example given below to hide and unhide the row :
Code:

Sub HideShow()
Rows(6).Hidden = Not Rows(6).Hidden
End Sub
Reply With Quote
  #4  
Old 16-10-2009
Member
 
Join Date: May 2008
Posts: 4,338
Re: Hiding rows in Excel 2007 using macros

Hiding rows or columns in excel can be performed by selecting the row or column you wish to hide and going to Format>Row (or Column) >Hide or try the given program :
Code:
Sub HiddenRow()
   For Each cell In ActiveSheet.Range("Q6:Q137")
       If cell1.Value = "y" Then cell1.EntireRow.Hidden = True
   Next
End Sub
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Hiding rows in Excel 2007 using macros"
Thread Thread Starter Forum Replies Last Post
Is it possible to have rows above 65,000 in Excel 2007 Nyota MS Office Support 2 21-02-2012 05:07 PM
Excel 2007 macros have disappeared LakshanA Windows Software 4 09-11-2010 08:13 AM
How to Run Excel 2003 Macros in Excel 2007 Ekanga Windows Software 5 19-07-2010 02:37 PM
Hiding zero values on a chart in Excel 2007 mellisahi Windows Software 4 12-11-2009 08:37 AM
2007 Excel Headache: Macros DHR Windows Software 4 28-04-2009 06:18 AM


All times are GMT +5.5. The time now is 03:03 AM.