Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 data sort
I have a long list of books that I update often. Between authors I have blank
lines. When I do a data sort the blank lines drop to the bottom of the list. I want the blank lines to remain in place between each author. The data sort worked on a prior version of Excel, but not on Excel 2003. -- Frank |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 data sort
Hi,
The sort command has always worked by moving the blanks to the bottom, this is not a feature of 2003. The solution is to either create a dummy column to control the sort order or to fill in the blank rows with the item above and formatting it to not be visible. Dummy column method: 1. Suppose the column you are sorting on, with the alternating blank rows, is column A with titles on row 1. In an adjacent blank column enter the following formula and copy it down as far as necessary: =IF(A2="",A1,A2) 2. With the formulas selected press Ctrl+C (copy), choose Edit, Paste Special, Values. 3. Use this column to control your sort. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "seafms" wrote: I have a long list of books that I update often. Between authors I have blank lines. When I do a data sort the blank lines drop to the bottom of the list. I want the blank lines to remain in place between each author. The data sort worked on a prior version of Excel, but not on Excel 2003. -- Frank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Sort #ERR in copied data - Exel 2003 | Excel Discussion (Misc queries) | |||
Data sort excel 2003 | Excel Worksheet Functions | |||
Excel 2003 Data Sort & Subtotaling not working properly | Excel Discussion (Misc queries) | |||
sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
In Excel 2003 SP1, "sort" on the Data drop-down menu is grayed ou. | Excel Worksheet Functions |