Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Inserting row/column (Excel Windows 2000)

    Could some remind me what the command is to insert a row or a column into a spreadsheet. Thanks.

    Farmer

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Inserting row/column (Excel Windows 2000)

    To insert a new row 10 (and push existing data down):

    Rows("10:10").Insert

    To insert a new column F (and push existing data to the right):

    Columns("F:F").Insert

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inserting row/column (Excel Windows 2000)

    Thanks for that. Suppose. I just want to insert one extra row when sitting in an empty cell, say I'm in cell A56 and want to insert an extra row there. Thanks.

    F

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Inserting row/column (Excel Windows 2000)

    If you want to insert a row at the currently active cell, use

    ActiveCell.EntireRow.Insert

    Simiularly, use EntireColumn if you want to insert a column.

  5. #5
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inserting row/column (Excel Windows 2000)

    Much appreciated.

    f

Posting Permissions

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