Results 1 to 4 of 4

Thread: Hiding rows in Excel 2007 using macros

  1. #1
    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?

  2. #2
    Join Date
    May 2008
    Posts
    4,834

    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.

  3. #3
    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

  4. #4
    Join Date
    May 2008
    Posts
    4,348

    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

Similar Threads

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •