|
|
|
Go  | Post  | Find  | Notify  | | Reply  | | Admin  | New PM!  |
Diamond Enthusiast


| Cyndi, I don't think there is an automatic way to insert between your lines of data but there is a shortcut that will eliminate manually inserting after every line. On each line click a different cell in a different column. Just hold down the Ctrl key as you select each cell in each row. They don't have to be diagonal but they do have to be in a different column than the above cell selected. Then on your toolbar click on the "insert row" tool button (or under Insert menu select "row") This will automatically insert a row between each line of data as far as you have selected the cells.
For example, if your sheet has 6 columns used then you could select A1, B2, C3, D4, E5, F6. Then "insert row" and you will now have empty rows between rows 1, 2, 3, 4, 5, 6. If you have the patience you can select the cells throughout your entire worksheet and automatically insert the rows at one time. But it's probably a little easier to do rows of 10 or so at a time. | | | | Posts: 9193 | Location: Atlanta, GA, USA | Registered: 06-03-02 |  
IP
|
|
| If I'd gotten to read this before Georgia replied, I'd have given you the same suggestion she did. I think that's the only way to do it. | | | |
 | Please Wait. Your request is being processed... |
© 2002-2012 AnswerPool.com
All Rights Reserved
Using This Site Means You Accept Its Terms of Service and Privacy Policy
Keep Back 300'
Close Cover Before Striking
3D Glasses Required for Optimal Viewing
Now in HD and Surround Sound
Offer Void Where Prohibited by Law
There's a Bathroom on the Right
Caution - Objects May Be Closer Than They Appear
Anything You Post May Be Used Against You in the Court of Public Opinion
Notice: All Employees and Customers Are Required to Wash Their Hands and Feet Before Posting by the Board of Health
Hands and Feet MUST Be Kept Inside Vehicle at All Times Please Extinguish All Smoking Materials During Take-Offs and Landings
The white zone is for immediate loading and unloading of passengers only.
There is no stopping in the red zone. Please line up alphabetically in chronological order according to height. I know it's only rock 'n roll but I like it, like it, yes, I do International Users Must Remove Shoes and Shirt Before Boarding Visit www.TitanicHeadlines.com
Visit DiscussionPool.com! |