« Creating A Series Of Workdays | Main | Macros: A Lotto Number Generator »
October 22, 2005
Paste Special IV: Inserting rows
Another quick tip illustrating the versatility of the Paste Special function.To insert an empty row into an existing table...
Step 1: Select and Copy a single empty cell in your table.
Step 2: Select the row above which you wish to insert an empty row - then select Edit - Paste Special - below...
The key setting has been circled. Existing selection is shifted down while blank cell is copied across the table
The end result is shown below.
Posted by Dave at October 22, 2005 09:43 PM
Comments
To get a BLANK row it seems to be faster and easier to just use Insert>Row. But to get a row with the same formulas as the highlighted row then this tip about the copy paste special works great.
Also can be used to insert multiple rows.
Posted by: Bluie at October 23, 2005 10:58 AM
Perfect! This Paste Special/Shift Down feature is just what a lot of my students ask for. I shall mention it next time and reference your site.
Paste Special is a really powerful and underused tool. There's a dropdown aspect to the Paste icon on the toolbar, too, so one can select some of the options, at least, there. Choosing to paste formatted or unformatted text from that dropdown icon gets around the annoyances of pasting from Word to just about anything else. (It comes in in a big frame for me, most of the time.) Just copy as usual from Word, click and hold down on the Paste icon on the toolbar, choose either Formatted or Unformatted text, both seem to work, and there you go.
Not that this is a Calc tip, but I just really like the Paste Special features.
~ Solveig
Posted by: Solveig Haugland at November 11, 2005 11:26 AM
How do I insert multiple blank rows into an existing
Open Office calc spreadsheet? Is there a keyboard command?
Thanks,
Andy
Posted by: Andy at February 10, 2006 12:54 PM