Click here for AnswerPool.com Home page


Google

    AnswerPool.com  Hop To Forum Categories  Computers  Hop To Forums  Software    every other line in excel

Moderators: Dwight
Go
Post
Find
Notify
Tools
Reply
  
every other line in excel
 Login/Join 
Cyndiluwho_99
Silver
Enthusiast
Picture of Cyndiluwho_99
posted
Hi y'all!!

I have an excel spreadsheet at work that has over 2000 lines. It's real hard to read, so I want to put a space in between each line.

Is there a shortcut that will do this for the whole worksheet (or even large portions of it) or do I have to "insert" from now til Christmas to get those lines in there?

Thanks, friends!
 
Posts: 723 | Location: Riverside, CA, USA | Registered: 09-27-03Reply With QuoteReport This Post
Rarius
posted Hide Post
I took a look at your request, Cyndi, and I am unable to see how that can be done easily outside of a script. However, I suggest you might think about this way:

Format the text:
Highlight all the text that you wish to change. (Simply pressing CTRL+A will highlight the entire worksheet)
Right click anywhere in the highlighted section and choose 'Format Cells'
In the box that appears enter 25.5, this will double the height of the rows.
Then select: Tools --> Options
in options make sure the View tab is selected
Look at the section: Window Options
where it says Gridlines, uncheck the box so that it is blank.
Click ok

This will space out the rows and clear the grid lines on the sheet, making it very easy to read.
You can still navigate around the spreadsheet using the same commands etc.

Have fun!
 
Posts: 22 | Location: Montreal | Registered: 08-03-04Reply With QuoteReport This Post
Rarius
posted Hide Post
Appoligies... for Format Cells, read: Row Height!!

Hey I have an excuse, I have just woken up and in desperate need of a caffiene transfusion! Smile
 
Posts: 22 | Location: Montreal | Registered: 08-03-04Reply With QuoteReport This Post
Georgia85
Diamond Enthusiast

Picture of Georgia85
posted Hide Post
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-02Reply With QuoteReport This Post
Cyndiluwho_99
Silver
Enthusiast
Picture of Cyndiluwho_99
posted Hide Post
Thanks, y'all....Wound up doing as Georgia suggested, a few at a time
 
Posts: 723 | Location: Riverside, CA, USA | Registered: 09-27-03Reply With QuoteReport This Post
Georgia85
Diamond Enthusiast

Picture of Georgia85
posted Hide Post
Hey! Glad that worked for ya Smile
 
Posts: 9193 | Location: Atlanta, GA, USA | Registered: 06-03-02Reply With QuoteReport This Post
Chris F
posted Hide Post
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.
 
Posts: 195 | Location: Illinois | Registered: 06-05-04Reply With QuoteReport This Post
  Powered by Social Strata  
 

    AnswerPool.com  Hop To Forum Categories  Computers  Hop To Forums  Software    every other line in excel

© 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!