LibreOffice Calc is a free spreadsheet program. People use it for lists, calculations, tables, and reports. Students, teachers, accountants, and small business owners all rely on it.

Reaching for the mouse on every action is slow, especially in long sheets. Keyboard shortcuts let you format cells, move around, and edit data without opening menus.

What are shortcut keys?

A shortcut is a key combination that runs one command. For example:

• Ctrl + C copies the selected cells.
• Ctrl + V pastes them somewhere else.

Shortcuts help most with repeat work like attendance records, sales reports, expense sheets, exam results, and inventory lists. Learn the ones you use daily and ignore the rest.

Essential shortcuts

These cover files, editing, and searching.

Example: You have a list of 200 products and one name is misspelled throughout.

1. Press Ctrl + H.
2. Type the wrong spelling and the right one.
3. Review the matches.
4. Apply the replacement.

Save with Ctrl + S often, and always before a big change.

Cell formatting shortcuts

Formatting makes a sheet easier to read. These are handy for invoices, reports, and result sheets.

Some of these can behave differently depending on your operating system, keyboard layout, or LibreOffice version. If one doesn’t work, check Tools > Customize > Keyboard.

A quick example

Say you’re building a monthly expense report:

• Make the column headings bold.
• Apply currency format to the amounts.
• Apply percentage format to the budget comparison column.

Use Ctrl + 1 when you need more control over decimals, dates, borders, or alignment.

One thing to remember: formatting changes how a value looks, not what it is. A cell showing a currency symbol still holds a number, and formulas can still use it.

Navigation shortcuts

Scrolling through thousands of rows wastes time. These shortcuts get you where you’re going.

To go to a specific cell, use the Name Box next to the formula bar. Type a reference like D2500 and press Enter.

Example: A sales report has 5,000 rows and you need cell D2500. Typing it in the Name Box is much faster than scrolling.

The original draft listed Ctrl + L for “go to cell.” In Calc, Ctrl + L aligns text left, so I replaced it with the Name Box method.

Data entry and editing shortcuts

Typing and fixing data takes up most spreadsheet time. These cut down on repeated work.

Fill commands need a selected range. For filling to the right, use Sheet > Fill Cells > Fill Right. The draft’s Alt + R isn’t a reliable default.

Tips for learning shortcuts

1. Pick three to five shortcuts you use every day.
2. Practice them for a week before adding more.
3. Keep this table nearby until they feel automatic.
4. If a shortcut fails, check whether another app or your keyboard layout is taking it.