Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Data Sort in Excel2000
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Data Sort in Excel2000
Just a thought....
Instead of inserting new rows just to add space, select the data range and increase the row heights <format<row<height...double the current height. That creates the same effect while making it easier to navigate through the data list and adding no complications to sorting. Is that something you can work with? *********** Regards, Ron XL2002, WinXP "rbul1" wrote: Can I retain blank rows within an Excel worksheet sort? I have a worksheet containing single rows of data alternated with blank cell rows for readability. I would like to do a data sort on the name column and retain the alternate blank rows, is this possible? Thanks, Bob |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Data Sort in Excel2000
Another way is to copy the sort column to an empty adjacent column.
Then in the new column, use John Walkenbach's technique shown here... http://j-walk.com/ss/excel/usertips/tip040.htm to fill in the blank cells. Sort on the new column and then delete it. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "rbul1" wrote in message Can I retain blank rows within an Excel worksheet sort? I have a worksheet containing single rows of data alternated with blank cell rows for readability. I would like to do a data sort on the name column and retain the alternate blank rows, is this possible? Thanks, Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Unable to sort data in excel with cells containing if & hlookup | Excel Worksheet Functions | |||
Can an Excel Spreadsheet automatically sort new data? | Excel Worksheet Functions | |||
how do i import data from excel, sort it then that information is. | Excel Discussion (Misc queries) | |||
Can you sort Excel data by font color? | Excel Discussion (Misc queries) |