| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need multiple header rows
Does anyone know how I can have two header rows? So that when I sort using "data sort" I can easily ignore the first 2 rows from my data range. Thanks Paolo -- PaoloScaglioni ------------------------------------------------------------------------ PaoloScaglioni's Profile: http://www.excelforum.com/member.php...o&userid=35020 View this thread: http://www.excelforum.com/showthread...hreadid=547559 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need multiple header rows
"PaoloScaglioni"
<PaoloScaglioni.28qkoa_1149186901.1552@excelforu m-nospam.com wrote in message news:PaoloScaglioni.28qkoa_1149186901.1552@excelfo rum-nospam.com... Does anyone know how I can have two header rows? So that when I sort using "data sort" I can easily ignore the first 2 rows from my data range. Thanks Select the rows you want, from row 3 downwards, before you sort. -- David Biddulph |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need multiple header rows
Place the cursor in Cell A3 and do Windows FreezePanes
hth Vaya con Dios, Chuck, CABGx3 "PaoloScaglioni" wrote: Does anyone know how I can have two header rows? So that when I sort using "data sort" I can easily ignore the first 2 rows from my data range. Thanks Paolo -- PaoloScaglioni ------------------------------------------------------------------------ PaoloScaglioni's Profile: http://www.excelforum.com/member.php...o&userid=35020 View this thread: http://www.excelforum.com/showthread...hreadid=547559 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need multiple header rows
Split your screen between rows 1 and 2, then freeze them. Highlight row 3 to the end. Sort your data (you will have to use "No Headers" option. -- bgeier ------------------------------------------------------------------------ bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822 View this thread: http://www.excelforum.com/showthread...hreadid=547559 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need multiple header rows
The freeze panes option freezes the rows OK but they are still sorted by the data sort option. Any other ideas? -- PaoloScaglioni ------------------------------------------------------------------------ PaoloScaglioni's Profile: http://www.excelforum.com/member.php...o&userid=35020 View this thread: http://www.excelforum.com/showthread...hreadid=547559 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need multiple header rows
I just tried this again on my machine (WinXP, XL2003) and it worked. When you selected your data did you make sure your header rows were NOT selected? Also, I was wrong before about not being able to use header rows, you can still use the header row option. -- bgeier ------------------------------------------------------------------------ bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822 View this thread: http://www.excelforum.com/showthread...hreadid=547559 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| resetting last cell | Excel Discussion (Misc queries) | |||
| Count on multiple values with duplicate rows | Excel Worksheet Functions | |||
| Select rows of data in a worksheet on one criteria in multiple co | Excel Worksheet Functions | |||
| averaging specific rows in multiple arrays | Excel Worksheet Functions | |||
| Convert multiple columns to rows | Excel Worksheet Functions | |||
Linear Mode
