Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sorting in Excel 2003
When I sort columns that contain blank cells, Excel throws them down to
the bottom. Is there any way to get them to appear at the top of the sort? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sorting in Excel 2003
Hi, You could try replacing the blanks with a space by clicking Crtl + H then leave go straight to replace with. Click in cell and press the space bar once. Then sort Ascending order VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=561267 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sorting in Excel 2003
Hi,
if the cell is empty, it goes at he bottom of the list when you sort, but you can for example create new column and put there formula like =if(a2="","",a2) which displays the same data as original column (for example A). In this case blank cell will return blank, but because there is formula in it, blank cells are not treated as blank and they appear at the top of the sort list. Regards, Nika Lampe "Stars" je napisal: When I sort columns that contain blank cells, Excel throws them down to the bottom. Is there any way to get them to appear at the top of the sort? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel 2003 can't do case sensitive sorting! | Excel Discussion (Misc queries) | |||
Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) |