[Solved] Keyboard shortcut to edit in formula bar

Discuss the spreadsheet application
Locked
PTALL
Posts: 1
Joined: Sun Oct 20, 2024 9:06 pm

[Solved] Keyboard shortcut to edit in formula bar

Post by PTALL »

I am an Excel user and want to try, and eventually switch, to Open Office.
Something that I cannot seem to accomplish in Calc:
When trying to edit the contents of a cell I press F2.
However, the editing is done directly in the cell. What I want, is to edit in the formula bar at the top of the screen/page.
Is there a way to customize this behavior? To have the cursor appear in the formula bar when editing the contents of a cell instead of directly in the cell?
Last edited by MrProgrammer on Wed Nov 13, 2024 7:24 pm, edited 2 times in total.
Reason: Edited topic's subject
Open Office: 4.1.15
Windows 10 (x64), version 22H2
User avatar
MrProgrammer
Moderator
Posts: 5430
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Edit directly in Cell

Post by MrProgrammer »

Hi, and welcome to the forum. You mentioned Excel in your topic so I have moved it from the Beginners forum to the Calc forum.
PTALL wrote: Sun Oct 20, 2024 9:14 pm What I want, is to edit in the formula bar at the top of the screen/page.
Instead of pressing F2, click in the formula bar, or press:
• ⌘⇧F2 on MacOS
• Ctrl Shift F2 on other platforms

If this solved your problem please go to your first post use the Edit ✏️ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

Differences in use between Calc and Excel
[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.7.8, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
LastUnicorn
Posts: 812
Joined: Sat Mar 29, 2008 2:41 am
Location: Scotland

Re: Edit directly in Cell

Post by LastUnicorn »

PTALL wrote: Sun Oct 20, 2024 9:14 pm I am an Excel user and want to try, and eventually switch, to Open Office.
As you are new to all this you might be better of starting on the most sure foot and switching to LibreOffice. There are several good reasons for making the switch anyway, some of which are mentioned here: [Tutorial] Considering a Switch from OpenOffice to LibreOffice? Some Useful Information
LibreOffice 25.8.4.2 (x64) installed to Windows 11 Pro. 25H2
Apache OpenOffice Portable 4.1.16 [Portable Apps]
For Java I use Adoptium Temurin JRE LTS Releases.
Locked