Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: Excel 2007  (Read 7556 times)

0 Members and 1 Guest are viewing this topic.

02bin3

  • Guest
Excel 2007
« 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? 

BC_Programmer


    Mastermind
  • Typing is no substitute for thinking.
  • Thanked: 1140
    • Yes
    • Yes
    • BC-Programming.com
  • Certifications: List
  • Computer: Specs
  • Experience: Beginner
  • OS: Windows 11
Re: Excel 2007
« Reply #1 on: March 15, 2010, 01:04:37 PM »
Why do you want to double space?
I was trying to dereference Null Pointers before it was cool.

02bin3

  • Guest
Re: Excel 2007
« Reply #2 on: March 15, 2010, 01:16:28 PM »
So that I can have space to make written notes under each item on my paperwork when my computer is not handy.

rthompson80819



    Specialist

    Thanked: 94
  • Experience: Experienced
  • OS: Windows 7
Re: Excel 2007
« Reply #3 on: March 15, 2010, 01:33:32 PM »
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.

02bin3

  • Guest
Re: Excel 2007
« Reply #4 on: March 15, 2010, 01:40:55 PM »
Thank you.  I will try that. :)

Medaitor



    Rookie

    Thanked: 1
    Re: Excel 2007
    « Reply #5 on: March 20, 2010, 11:20:38 AM »
    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.

    02bin3

    • Guest
    Re: Excel 2007
    « Reply #6 on: March 20, 2010, 12:01:50 PM »
    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.