Computer Hope
Software => Computer software => Topic started by: 02bin3 on March 15, 2010, 12:47:09 PM
-
I use Excel but I am a total novice when it comes to this program. I've asked this question, worded in many different ways, of the Excel ?HELP program and haven't had answer. So, after exhausting other avenues, here I am! I have an Excel Document of 108 lines (rows) and I would like to double space between the rows. How do I accomplish this without having to insert a row one by one throughout the whole document?
-
Why do you want to double space?
-
So that I can have space to make written notes under each item on my paperwork when my computer is not handy.
-
The easiest thing to do would be increase the height of the rows, but leave the font the same. Highlight the entire range then format, row height, and change it to what ever you want or need to make notes.
-
Thank you. I will try that. :)
-
If you will have to do this over and over again with other excel documents of the same nature versus this one time then I believe you could create a macro. Once you record the macro while the manual steps the first time it will do all of the work for you the next time you need it by simply running the macro in the next document.
-
Thank you for your followup. I am not familiar with working with MACROs as in previous years I had read warnings about working with MACROs and had therefor steered away from them. But, I will look into your suggestion as I can see further need for this type of format down the road.