[Calc] Keyboard shortcut to delete current row when focus on one of its cells?

users
#1

Hello,

I need a keyboard shortcut to delete the current row

CTRL+- only works when 1) reaching for the mouse and 2) clicking on its ID
number on the left-most column (1,2,3, ie. the "grey part")… which beats the
point of keyboard shortcuts.

Do you know of a way?

Thank you.

#2

Ctrl+hyphen, R, Enter?

I trust this helps.

Brian Barker

#3

Thanks. I'd rather a single shortcut eg. CTRL+SHIFT+-. I'll see if I can find
a way.

#4

Found it:
1. Tools > Customize > Keyboard
2. Category = Edit, Function = Delete Rows
3. Shortcut Keys = CTRL+Del
4. "Modify" to assign shortcut

#5

Hi,
You need to add a new keyboard shortcut. To add, go Tools >
Customize... > Keyboard tab. In the bottom portion of the panel, select
the Edit Category, and then the "Delete Rows" line in the Function
list. Then highlight a suitable keyboard shortcut in the Shortcut Keys
area (maybe Ctrl+Delete), and press Modify. This will assign the
"Delete Rows" tothe shortcut key you selected.
I hope this helps.Rémy.

#6

Thanks. I'd rather a single shortcut eg. CTRL+SHIFT+-. I'll see if I can
find
a way.

Thanks for what? Nobody answered yet, as far as I can see.

Anyway, I would just make a macro and then create a shortcut to start that
macro.

Kind regards

Johnny Rosenberg

#7

That's what I've been using for years.

Glad you found the setup.

Mark

#8

>I need a keyboard shortcut to delete the current
>row. CTRL+- only works when 1) reaching for the
>mouse and 2) clicking on its ID number on the
>left-most column (1,2,3, ie. the "grey part")…
>which beats the point of keyboard shortcuts.

Ctrl+hyphen, R, Enter?

FWIW, on my system, CTRL+hyphen pops up a Delete Cells dialog, R does
nothing and Enter causes the dialog to close while executing the first
action - Shift cells up. LO 6.2.7.1

#9

That's odd. Figure 36 in the Calc Guide 6.2 shows the Delete cells dialogue with the first letter of "rows" in "Delete entire row(s)" underlined. This means that pressing "R" *should* move the selection to this option. (Figure 16 in Calc Guide 6.4 shows the same.)

Brian Barker

#10

>>>I need a keyboard shortcut to delete the
>>>current row. CTRL+- only works when 1)
>>>reaching for the mouse and 2) clicking on its
>>>ID number on the left-most column (1,2,3, ie.
>>>the "grey part")… which beats the point of keyboard shortcuts.
>>
>>Ctrl+hyphen, R, Enter?
>
>FWIW, on my system, CTRL+hyphen pops up a Delete
>Cells dialog, R does nothing and Enter causes
>the dialog to close while executing the first
>action - Shift cells up. LO 6.2.7.1

That's odd. Figure 36 in the Calc Guide 6.2 shows
the Delete cells dialogue with the first letter
of "rows" in "Delete entire row(s)" underlined.
This means that pressing "R" *should* move the
selection to this option. (Figure 16 in Calc Guide 6.4 shows the
same.)

Well the diagram in the book also has the buttons at the bottom in a
different order. Either they used a different version of the software,
or maybe a different desktop environment. The joy of linux :slight_smile:

But no, there are no underlines on the selections in [my] real life.

#11

Nor mine -  on 6.4.5.2

Philip

#12

That suggests you are running Linux.

The image Dave is referring to was taken from a Windows 7 install of the
Calc Guide 6.2. We (The Documentation Team) always take captures of the
guide we are writing about. As much as we would like to, we cannot cover
every possible visual difference between each operating system.

The conclusion to this thread is that Ctrl+- opens the dialog in both
Linux and Windows (cannot speak for macOS), but the D key only functions
as described by Brian under Windows, which is why Linux users don't see
the underline. Although less convenient, Linux users can use the up and
down arrow keys can be used to select the required option.

Dave

#13

>> Well the diagram in the book also has the buttons at the bottom in
>> a different order. Either they used a different version of the
>> software, or maybe a different desktop environment. The joy of
>> linux:)
>>
>> But no, there are no underlines on the selections in [my] real
>> life.
>
> Nor mine -  on 6.4.5.2
>
> Philip

That suggests you are running Linux.

The image Dave is referring to was taken from a Windows 7 install of
the Calc Guide 6.2. We (The Documentation Team) always take captures
of the guide we are writing about. As much as we would like to, we
cannot cover every possible visual difference between each operating
system.

The conclusion to this thread is that Ctrl+- opens the dialog in both
Linux and Windows (cannot speak for macOS), but the D key only
functions as described by Brian under Windows, which is why Linux
users don't see the underline. Although less convenient, Linux users
can use the up and down arrow keys can be used to select the required
option.

Since I believe such underlines were implemented on Unix/Linux before
Windows, it's disappointing to me that the functionality isn't there in
the Linux implementation.

And in this case where there's a functional difference rather than a
visual difference, it would be nice to see that documented.

But thanks for explaining the situation. PS I think you mean R key
rather than D key.

#14

Sorry for the late response, I'm on digest mode.

While this isn't a one keyboard shortcut, you can do the following:

I use the following to achieve the delete current row when in a cell.

When in the cell,
press shift+spacebar (highlight row)
and then the ctrl+- (to delete row)

B.