Windows

Insert A Row Or Column In Excel

Posted by on Mar 26, 2009 | One Comment

Inserting a new row or column in a worksheet is a snap for experienced Excel users. However, it likely isn’t for those who are new to the application.

To add a new row or column, select the existing row or column that you want the new one to appear before. From the Insert menu, choose the Columns option or the Rows option, depending on what you want to insert. Excel will add the new column or row into your worksheet.

If you like prefer using the keyboard, you can add new columns and rows using keystrokes. Select the appropriate column or row, as you did in the previous steps, and pres CTRL++ (the CTRL key and the plus sign at the same time).

[rsslist:http://ah.pricegrabber.com/export_feeds.php?pid=hjehfab&document_type=rss&limit=25&topcat_id=all&category=topcat:all&col_description=1&form_keyword=excel+tips]

  • Ann F

    I just downloaded Microsoft Office Home & Student 2010. Unlike what your tip says re inserting rows or columns, clicking Insert at the head of my excel sheet proiduces a bunch’o useless (to me) stuff like “pivot table” “table” “art” “column: (but it’s a column chart, not a plain column), complete with cutesy icons.

    I am longing for my old excel version where Insert had column, and row, simply and plainly available.

    Why in earth would Microsoft think this crappy, complicated set of stuff – without a clear way to just INSERT a g.d. row or column – is an improvement. Inserting columns and rows, along with Sum (and where did that go?) were the things I (and I imagine many others) actually used.

    BAH Microsoft!