Adding multiple rows/columns to a spreadsheet in LibreOffice Calc

Inserting more than one row/column at a time

  • To insert multiple rows into a Calc spreadsheet at one time, select the same number of rows as you want to add, beginning at the row AFTER where you want the insertion to be, then
    • Ctrl-click/right-click on the row header (where the row numbers are) within your selection, and choose Insert Rows from the contextual menu, or
    • Click on the “Insert Rows” button in your toolbar (if it’s visible there), or
    • Choose Rows from the Insert menu.
  • To insert multiple columns, just follow the above instructions subtituting ‘columns’ for ‘rows’ – it works exactly the same way.

Source: http://neowiki.neooffice.org/index.php/Adding_multiple_rows/columns_to_a_spreadsheet_in_Calc

 

About SoCRaT

Software Engineer, OSS & Linux Geek
This entry was posted in Ubuntu and tagged , , . Bookmark the permalink.

One Response to Adding multiple rows/columns to a spreadsheet in LibreOffice Calc

  1. Remo says:

    And for Columns?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s