Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding even (or odd) rows in excel 2003
I am curious as how to hide even , or odd rows in 2003 , not based on
information in them but the actual row numbers themselves. Jason |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding even (or odd) rows in excel 2003
easy with a little macro:
Sub hide_um() Application.ScreenUpdating = False For i = 2 To 65536 Step 2 Rows(i).EntireRow.Hidden = True Next Application.ScreenUpdating = True End Sub -- Gary''s Student gsnu200703 "9d1awd" wrote: I am curious as how to hide even , or odd rows in 2003 , not based on information in them but the actual row numbers themselves. Jason |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding even (or odd) rows in excel 2003
Hi Jason
One way In a spare column enter following formula =MOD(ROW(),2)=0 Copy down as far as required. Highlight first cell, DataFilterAutofilterselect from dropdown TRUE -- Regards Roger Govier "9d1awd" wrote in message ... I am curious as how to hide even , or odd rows in 2003 , not based on information in them but the actual row numbers themselves. Jason |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding even (or odd) rows in excel 2003
Jason,
Two ways: Manually. Hide row 1 (or row 2). Then press F5 and enter 1:2. Press Ctrl-C, then select rows 3 through your last even numbered row that you want to hide, and press Ctrl-V. Through Filters. Enter the formula =MOD(ROW(),2) into a column, through all the rows of interest. Then apply autofilters, and choose to show either 1 or 0 in that column. HTH, Bernie MS Excel MVP "9d1awd" wrote in message ... I am curious as how to hide even , or odd rows in 2003 , not based on information in them but the actual row numbers themselves. Jason |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding even (or odd) rows in excel 2003
And, for completeness, you could use a macro: Select the range of rows, and run this
Sub HideRows() Dim myRow As Range Dim HideEven As Boolean HideEven = MsgBox("Hide Even rows?", vbYesNo) = vbYes For Each myRow In Selection.Rows myRow.Hidden = False If HideEven And myRow.Row Mod 2 = 0 Then myRow.Hidden = True If Not HideEven And myRow.Row Mod 2 = 1 Then myRow.Hidden = True Next myRow End Sub -- HTH, Bernie MS Excel MVP "9d1awd" wrote in message ... I am curious as how to hide even , or odd rows in 2003 , not based on information in them but the actual row numbers themselves. Jason |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding even (or odd) rows in excel 2003
thank you to all of you for the help , i got it working , the help was much
appreciated :) Jason "9d1awd" wrote: I am curious as how to hide even , or odd rows in 2003 , not based on information in them but the actual row numbers themselves. Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening Excel 2003 files in Excel 97 | Excel Discussion (Misc queries) | |||
does excel 2003 support more than 65k rows? | Excel Discussion (Misc queries) | |||
How can I add additional rows beyond the 65,536 in excel 2003 | Excel Worksheet Functions | |||
Excell VS Office | Excel Discussion (Misc queries) | |||
how do I unhide Excel 2003 spreadsheet rows with usual method. | Excel Discussion (Misc queries) |