Ask Your Question
0

How do I start editing a cell using my keyboard in Mac? [closed]

asked 2015-10-12 21:51:41 +0200

madfedaykin gravatar image

I would normally just hit Enter in other spreadsheet applications. Hitting Enter while in a cell in Calc moves me to the cell below.

Using the mouse to click on a cell is such a chore if you are editing hundreds of cells.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-17 16:56:11.390827

1 Answer

Sort by » oldest newest most voted
0

answered 2015-10-14 05:34:09 +0200

sansdomino gravatar image

This can be set up under Tools → Customize. Select Functions → Internal → Toggle Edit Mode in the lower pane; the Enter key (symbolized as "↩") (or to any other key/combo, if you wish) from the upper pane; click Modify.

edit flag offensive delete link more

Comments

Thanks! That worked for me.

LibreOffice should change the default key for Toggle Edit Mode from F2 to other keys in their Mac versions of Calc. F2 in Mac is for brighting up your screen.

madfedaykin gravatar imagemadfedaykin ( 2015-10-15 06:28:12 +0200 )edit

This also works on Linux, though Enter is listed as "Return", not "↩". Also, this is all on the "Keyboard" tab of the Tools → Customize dialog.

One minor nit: If you start entering text into a cell just by typing (ie: without pressing anything Enter), pressing Enter acts weird with this setting. You have to press Enter twice to stop editing the cell. Seems like a bug.

xenomachina gravatar imagexenomachina ( 2016-12-14 21:00:25 +0200 )edit

In May of 2017 on a Mac you can find this option using cmd-, then look for the LibreOffice Calc section and General. There are checkboxes for "Press Enter to move selection" and "Press Enter to switch to edit mode".

Awfki gravatar imageAwfki ( 2017-05-14 12:26:24 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2015-10-12 21:51:41 +0200

Seen: 1,315 times

Last updated: Oct 12 '15