Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: adding rows in an entire spreadsheet

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a large spreadsheet with no blank rows. I wish to add a blank row between each row of data. Surely, I don't have to do this one row at a time! Thank you. Also, what are "smilies" and "BBcode"?

  2. #2
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try using a macro with step 2.

    For x = 2 to N step 2
    (code for inserting row)
    next x


  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    this is a smilie :



    achieved by typing the colon then the dash then the close-parenthesis

    BB Code when OFF switches off any HTML commands (Hypertext Markup Language - the commands that intruct your browser to display appropriately) as sometimes the typing that explainins your excel formula porblems is interpretted as HTML, so Mr Excel has given us the ability to switch this off.


    :: Pharma Z - Family drugstore ::

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •