| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
When I sort a list, How can I keep blank rows between the fields?
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When I sort a list, How can I keep blank rows between the fields?
What is the need for the spaces between the records? Not knowing this I can
only suggest the following. A: You could keep the spaces by having an extra column with an "X" or something on each line including the spaced ones. Then sort the "X" field first. or B: Increase (double) the Row Height like you do the column width. -- Thanks, Kevin "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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When I sort a list, How can I keep blank rows between the fiel
It is our sign in sheet and we need a balnk space under our names for our
signature...its a district finance policy thing... "AFSSkier" wrote: What is the need for the spaces between the records? Not knowing this I can only suggest the following. A: You could keep the spaces by having an extra column with an "X" or something on each line including the spaced ones. Then sort the "X" field first. or B: Increase (double) the Row Height like you do the column width. -- Thanks, Kevin "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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When I sort a list, How can I keep blank rows between the fiel
Still the only option I see is to do one of my suggestions. Option B, you
could increase the row height & format the cells so your names print at the top, leaving room below to sign. Goto Format Cells/Alignment/Vertical/Top. With this you can sort as you do now. Option A is too much maintenance. -- Thanks, Kevin "Erin" wrote: It is our sign in sheet and we need a balnk space under our names for our signature...its a district finance policy thing... "AFSSkier" wrote: What is the need for the spaces between the records? Not knowing this I can only suggest the following. A: You could keep the spaces by having an extra column with an "X" or something on each line including the spaced ones. Then sort the "X" field first. or B: Increase (double) the Row Height like you do the column width. -- Thanks, Kevin "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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When I sort a list, How can I keep blank rows between the fiel
See my post using Excel and MS-Word in one of your other posts.
P. -- Overcome Sales Barriers http://salesbarriers.typepad.com/ "AFSSkier" wrote: Still the only option I see is to do one of my suggestions. Option B, you could increase the row height & format the cells so your names print at the top, leaving room below to sign. Goto Format Cells/Alignment/Vertical/Top. With this you can sort as you do now. Option A is too much maintenance. -- Thanks, Kevin "Erin" wrote: It is our sign in sheet and we need a balnk space under our names for our signature...its a district finance policy thing... "AFSSkier" wrote: What is the need for the spaces between the records? Not knowing this I can only suggest the following. A: You could keep the spaces by having an extra column with an "X" or something on each line including the spaced ones. Then sort the "X" field first. or B: Increase (double) the Row Height like you do the column width. -- Thanks, Kevin "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! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignoring Blank value in a drop down list | Excel Worksheet Functions | |||
| Sort with a List | Excel Worksheet Functions | |||
| How do I sort (or group?) a spreadsheet by similar rows? | Excel Worksheet Functions | |||
| HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST? | Excel Discussion (Misc queries) | |||
| Insert rows | Excel Worksheet Functions | |||
Linear Mode
