[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.

Thanks,

Bill
Last edited by Hagar Delest on Fri Nov 04, 2011 11:59 am, edited 1 time in total.
Reason: tagged [Solved].
MiataRoadster
 
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
mriosv
 
Posts: 650
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'.
OpenOffice 3.3 on PCLinuxOS. There are 3 kinds of people: those who can count and those who can't.
User avatar
kingfisher
Volunteer
 
Posts: 1860
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 3.4.1. bld 9593
on MS Windows 7 64 SP1
Chillblast fusion i5

I'm learning to see things differently
Richarda44
 
Posts: 151
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.

Thanks,

Bill
OpenOffice 3.3.0 on Mac OS 10.7.2
MiataRoadster
 
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...
OpenOffice.org 3.3.0 OOO330m20(Build:9567),LibreOffice 3.5.2.2 on Windows XP.SP2
If you think that I did not answer your question, make allowances for my imperfect English
User avatar
JohnSUN-Pensioner
Volunteer
 
Posts: 568
Joined: Fri Jan 14, 2011 1:21 pm
Location: Kyiv, Ukraine


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 23 guests