If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Blank rows between data
I have a spreadsheet with blank rows between each row of data. First of
all, how can I set it up to skip the row automatically when entering and second, when sorting, I need to keep the blank row in between? I don't want to lose the blank rows. How do I go about achieveing this? Thank you, --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Blank rows between data
If the blank rows are there just to give the appearance of double spacing, then
maybe you could elminate them and just double the row height. "sdrendon " wrote: I have a spreadsheet with blank rows between each row of data. First of all, how can I set it up to skip the row automatically when entering and second, when sorting, I need to keep the blank row in between? I don't want to lose the blank rows. How do I go about achieveing this? Thank you, --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Contact categories data blank - mismapping? | Peter Lunn | Contacts | 1 | May 18th, 2004 12:13 AM |
Deleting rows with no data using Auto Filter and Helper column | John | Worksheet Functions | 1 | April 19th, 2004 06:52 AM |
Average 5 columns of data skipping blank columns | marvin | Worksheet Functions | 10 | January 28th, 2004 06:33 PM |
Deleting Blank rows | Jarrod | Worksheet Functions | 4 | September 18th, 2003 10:07 PM |