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?
[Solved] Keyboard shortcut to edit in formula bar
[Solved] Keyboard shortcut to edit in formula bar
Last edited by MrProgrammer on Wed Nov 13, 2024 7:24 pm, edited 2 times in total.
Reason: Edited topic's subject
Reason: Edited topic's subject
Open Office: 4.1.15
Windows 10 (x64), version 22H2
Windows 10 (x64), version 22H2
- MrProgrammer
- Moderator
- Posts: 5430
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Edit directly in Cell
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.
• ⌘⇧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
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).
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).
- LastUnicorn
- Posts: 812
- Joined: Sat Mar 29, 2008 2:41 am
- Location: Scotland
Re: Edit directly in Cell
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.
Apache OpenOffice Portable 4.1.16 [Portable Apps]
For Java I use Adoptium Temurin JRE LTS Releases.