LibreOffice Calc is a spreadsheet software that is as useful as Excel. The keyboard shortcuts below will help you use LibreOffice Calc faster and more effectively .
Shortcut table in LibreOffice Calc
| Shortcuts | Action |
| Directional | |
| Ctrl + Home | Move the cursor to A1 |
| Ctrl + End | Move the cursor to the cell containing the latest data |
| Home | Move the cursor to the first cell of the row |
| End | Move the cursor to the last cell of the row |
| Shift + Home | Select from the current cell to the first cell of the row |
| Shift + End | Select from the current cell to the last cell in the row |
| Shift + Page up | Select from the current cell up one page |
| Shift + Page down | Select from the current cell down one page |
| Ctrl + ← | Moves the cursor to the left of the current data range |
| Ctrl + → | Moves the cursor to the right of the current data range |
| Ctrl + ↑ | Moves the cursor above the current data range |
| Ctrl + ↓ | Moves the cursor below the current data range |
| Ctrl + Shift + Arrow | Select the entire cell containing data, following the direction of the arrow |
| Ctrl + Page up | Move sheet to the left |
| Ctrl + Page down | Move sheet to the right |
| Alt + Page up | Move one screen to the left |
| Alt + Page down | Move one screen to the right |
| Alt + ↓ | Reduce current row height |
| Alt + ↑ | Increase current row height |
| Alt + → | Increase the current column width |
| Alt + ← | Reduce the current column width |
| Alt + Shift + Arrow | Match column widths and row heights to the current cell |
| Shift + Ctrl + Page up | Add the previous sheet to the current sheet |
| Shift + Ctrl + Page down | Add the next sheet to the current sheet |
| Ctrl + * | Select the data range in the cursor |
| Ctrl + / | Select the matrix formula in the mouse pointer |
| Ctrl + Plus | Insert cells |
| Ctrl + Minus | Delete cells |
| Enter | Move the cursor down one cell |
| Ctrl + ` | Show/Hide formulas |
| Format | |
| Ctrl + 1 | Open cell format |
| Ctrl + Shift + 1 | Two decimal places |
| Ctrl + Shift + 2 | Exponential format |
| Ctrl + Shift + 3 | Date and month format |
| Ctrl + Shift + 4 | Currency format |
| Ctrl + Shift + 5 | Percent format |
| Ctrl + Shift + 6 | Standard format |
| Function | |
| Ctrl + F1 | Show comments |
| F2 | Enter edit mode |
| Ctrl + F2 | Open the Function wizard |
| Shift + Ctrl + F2 | Move the cursor to the input line |
| Ctrl + F3 | Open Define names |
| Shift + Ctrl + F4 | Show/hide database browser |
| F4 | Reorder references |
| F5 | Show/Hide Navigator |
| Shift + F5 | Find cells calculated by selected cell |
| Shift + Ctrl + F5 | Move the cursor to the Sheet area |
| F7 | Spell check |
| Shift + F7 | Find cells to calculate selected cells |
| Ctrl + F7 | Open Thesaurus |
| F8 | Enable/Disable selection mode |
| Ctrl + F8 | Highlight the cell containing the values |
| F9 | Recalculate the formula in the current cell |
| Ctrl + F9 | Update chart |
| Ctrl + Shift + F9 | Recalculate formulas in all sheets |
| F11 | Open Styles |
| Shift + F11 | Create a document template |
| Shift + Ctrl + F11 | Update sample |
| F12 | Data range group is selected |
| Ctrl + F12 | Ungroup the selected data range |
Montreal, a city brimming with culture, history, and Poutine (a famous Canadian dish), deserves an internet connection that can keep up. Whether you’re a streamer glued to Twitch, a workaholic juggling video conferences, or a casual web surfer, a reliable and fast internet plan is essential.
What is ChatGPT? Why is it creating a global fever? In recent days, the ChatGPT chatbox is creating a global craze. Not only that ChatGPT is creating
Google Drive for desktop will be discontinued in March 2018, Google has officially announced that it will stop supporting Google Drive for desktop and then the company will remove the application.
The latest Adobe Flash Player update contains virtual currency mining malware, researchers from security firm Palo Alto Networks warn users if they download the wrong update
One Ordinary Day - Movie schedule One Ordinary Day, One Ordinary Day (Vietnamese name: One Ordinary Day) is an attractive Korean film about a crime topic.
Simple ways to fix AirDrop not working error, AirDrop not working on iPhone, iPad, Mac what to do? This article will provide you with simple ways
Status for opening the new school year 2023 - 2024, TOP 50 Status for opening the new school year 2023 - 2024 to help you freely choose unique statuses and statuses for yourself!
Top photo editing applications similar to Snap Camera, Snap Camera is a free camera application that helps apply Snapchat filters. In addition to Snap Camera, you can refer to these
Ways to fix file attachment errors on Gmail, Why can't I download files in Gmail? Why can't you attach files to Gmail? Here are the causes and how
Is it safe to use public Wifi?, Public Wifi helps you connect to the Internet for free. However, is it safe to use public wifi? Join WebTech360
TOP best computer screen recording software 2024, Which is the best lightweight, free, high-quality computer screen recording software? Let's find out the top with WebTech360
Tips for using Google Chrome that students need to know, Google Chrome is the most popular web browser today. You probably already know how to use it, however, if
Please upgrade TeamViewer immediately or your computer will be hijacked. Teamviewer has just released an emergency patch that allows hackers to take control of your computer.
Should you use Tor and VPN at the same time? Tor and VPN both provide privacy protection but in different ways. So should privacy and security features be combined?
Signs of a fake Instagram account. Are you wondering whether the Instagram account you are following or contacting is genuine or legitimate? Signs below
Explore BlueStacks X on PC, BlueStacks X allows you to open Android games using cloud computing on your web browser. With BlueStacks X, you are no longer limited
Play Fish Release game online on My Viettel to receive free data packages, voice calls, SMS, Viettel's Online Fish Release program will take place from January 30, 2021 to
Unreal Engine 5: All information about the latest game development technology, Unreal Engine 5 is the latest version of the famous game development tool Unreal Engine of
What is an email address? How to get an email address?, What is an email address? What is email address entry? This article will answer all your related questions
Every WhatsApp shortcut for your computer you need to know, WhatsApp is one of the most popular free messaging apps today. The keyboard shortcuts below will help
