[Solved] Shortcut to insert rows?

Discuss the spreadsheet application

[Solved] Shortcut to insert rows?

Postby MiataRoadster » Wed Nov 02, 2011 2:12 am

Is there a keyboard/cursor combination for quickly inserting multiple rows or columns?

In Exsell, you hold down a key and click on the adjacent row or column to insert new ones.


Last edited by Hagar Delest on Fri Nov 04, 2011 11:59 am, edited 1 time in total.
Reason: tagged [Solved].
Posts: 2
Joined: Wed Nov 02, 2011 2:06 am

Re: shortcut to insert rows?

Postby mriosv » Wed Nov 02, 2011 3:19 am

Welcome to the forum MiataRoadster

'Ctrl+Plus key' Insert cells (as in menu Insert - Cells)

In the OOo help you can find all shortcuts.

It is also good to read:
- The survival guide of the forum: viewtopic.php?f=5&t=166
- [Tutorial] Ten concepts that every Calc user should know viewtopic.php?f=75&t=39529
LibreOffice 3.5.4 AOo-3.4 on Win 7 Ultimate
Posts: 651
Joined: Mon Mar 09, 2009 1:12 am
Location: Galiza (España)

Re: shortcut to insert rows?

Postby kingfisher » Wed Nov 02, 2011 5:05 am

In my version of Open Office, there are no shortcut keys to insert rows or columns. You can create shortcuts using Tools > Customise > Keyboard tab.

On that tab, in the box labelled 'Category' select 'Insert'. In the next box (labelled 'Function'), scroll down to 'Insert Columns', for example. In the top box labelled "Shortcut Keys," select a shortcut you wish to use. Press the button labelled 'Modify' and the name of the function you have allocated to the shortcut keys will appear in the box at the bottom right labelled 'Keys'. When you have finished allocating shortcuts, press 'OK'.
Apache OpenOffice 4.1.2 (64 bit) on PCLinuxOS
User avatar
Posts: 2109
Joined: Tue Nov 20, 2007 10:53 am

Re: Shortcut to insert rows?

Postby Richarda44 » Thu Nov 03, 2011 10:11 pm

In my version just highlight a whole row (or collumn) and then press Ctrl and +
OOo 4.1.1. bld 9593 on MS Windows 10 64 SP1 Chillblast fusion i5 and Acer Aspire E1-572 Laptop

There's got to be a better way
And for all accountants - The change is coming
Posts: 300
Joined: Sat May 24, 2008 6:59 pm

Re: Shortcut to insert rows?

Postby MiataRoadster » Fri Nov 04, 2011 6:52 am

I figured out that whoever does the documentation didn't distinguish between "adding a cell" and what I was looking for (and is not mentioned anywhere) adding a row or column.


OpenOffice 3.3.0 on Mac OS 10.7.2
Posts: 2
Joined: Wed Nov 02, 2011 2:06 am

Re: Shortcut to insert rows?

Postby JohnSUN-Pensioner » Fri Nov 04, 2011 8:16 am

The final decision:
Insert a row above the current cell - Shift+Space, Ctrl+"Plus"
Insert a column to the left of the current cell - Shift+Ctrl+Space, Ctrl+"Plus"

Will be inserted as many rows (or columns) as selected now
I may not have a lot to give but what I got I'll give to you...
Apache OpenOffice 4.1.1 AOO411m6(Build:9775),LibreOffice on Windows 7
If you think that I did not answer your question, make allowances for my imperfect English
User avatar
Posts: 684
Joined: Fri Jan 14, 2011 1:21 pm
Location: Kyiv, Ukraine

Return to Calc

Who is online

Users browsing this forum: No registered users and 15 guests