LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default When I sort a list, How can I keep blank rows between the fields?


Erin wrote:
We have a list from our school district that needs to have spaces inbetween
the typed in fields. When we add new prople to the list and try to sort it,
we can not get it to keep the spaces inbetween the names...help!


Have you used Alt/Enter within a cell to have two (or more lines of
text within the cell?

Type a name, then hit Alt/Enter and the cursor will remain within the
cell and allow you to enter a line. You can also use Alt/Enter to add
blank space between the text. Copy that down the page, and go back to
add more names in any order. Then sort the list and there you are.
Joe

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ignoring Blank value in a drop down list shail Excel Worksheet Functions 15 August 28th 06 12:39 PM
Sort with a List Ray A Excel Worksheet Functions 0 September 7th 05 01:06 AM
How do I sort (or group?) a spreadsheet by similar rows? steve Excel Worksheet Functions 3 August 27th 05 06:33 PM
HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST? Phil A. Excel Discussion (Misc queries) 1 April 19th 05 04:10 PM
Insert rows Mr. G. Excel Worksheet Functions 3 March 31st 05 03:49 AM


All times are GMT +1. The time now is 02:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"