[Solved] Shortcut to insert rows?

Discuss the spreadsheet application
Post Reply
MiataRoadster
Posts: 2
Joined: Wed Nov 02, 2011 2:06 am

[Solved] Shortcut to insert rows?

Post by MiataRoadster »

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.

Thanks,

Bill
Last edited by Hagar Delest on Fri Nov 04, 2011 11:59 am, edited 1 time in total.
Reason: tagged [Solved].
mriosv
Volunteer
Posts: 651
Joined: Mon Mar 09, 2009 1:12 am
Location: Galiza (España)

Re: shortcut to insert rows?

Post by mriosv »

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: http://user.services.openoffice.org/en/ ... ?f=5&t=166
- [Tutorial] Ten concepts that every Calc user should know http://user.services.openoffice.org/en/ ... 75&t=39529
LibreOffice 3.5.4 AOo-3.4 on Win 7 Ultimate
User avatar
kingfisher
Volunteer
Posts: 2123
Joined: Tue Nov 20, 2007 10:53 am

Re: shortcut to insert rows?

Post by kingfisher »

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.9 on Linux
Richarda44
Posts: 351
Joined: Sat May 24, 2008 6:59 pm

Re: Shortcut to insert rows?

Post by Richarda44 »

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
MiataRoadster
Posts: 2
Joined: Wed Nov 02, 2011 2:06 am

Re: Shortcut to insert rows?

Post by MiataRoadster »

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.

Thanks,

Bill
OpenOffice 3.3.0 on Mac OS 10.7.2
User avatar
JohnSUN-Pensioner
Volunteer
Posts: 876
Joined: Fri Jan 14, 2011 1:21 pm
Location: Kyiv, Ukraine

Re: Shortcut to insert rows?

Post by JohnSUN-Pensioner »

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.5, LibreOffice 6.4.4.2 (x64) on Windows 7
If you think that I did not answer your question, make allowances for my imperfect English
Post Reply