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 |
Signs that your smartphone is infected with virtual currency mining malware. Cybercriminals can install malicious code to let your smartphone mine virtual currency for them. Below is the receiving sign
Mistakes to avoid when using Google Calendar. You are wasting time by not using the calendar effectively. Therefore, avoid the mistakes below when using Google Calendar.
Tips for using Canva to make movies and edit videos that you may not know. Canva may not be the first tool that comes to mind when mentioning video making or filming, but
Discover the vibrant social scene of baccarat on Tedbet, where players worldwide connect, chat, and enjoy the excitement of live dealer games.
Ways to make your Apple Watch more private, If you feel like people can easily access your information on your Apple Watch, don't worry, you can apply these tips.
Everything you need to know about IGTV, IGTV is not only the choice of stars or KOLs, it is also fully utilized by businesses to promote marketing strategies.
The easiest majors to get a job today, what majors are easy to get a job at? Which major is the easiest to get a job after graduating? This is the top concern of parents and children
XLOOKUP vs VLOOKUP: Which Excel function is better?, XLOOKUP and VLOOKUP functions in Excel both find a value in a table or list and return related results. Although
National High School Graduation Exam Score Range 2023 (9 subjects), High School Graduation Exam Score Range 2023 was announced by the Ministry of Education and Training on July 18, 2023. We invite you to follow along!
Summary of how to find videos on TikTok, Finding videos on TikTok is not difficult. Let's learn together how to find the original video on TikTok or find the Tik Tok clip you want to watch
Differences between Power BI and Excel, Power BI and Excel have many similarities in functionality and data presentation. However, there is still a difference between Power BI and Excel
The best features of DaVinci Resolve 18, DaVinci Resolve 18 adds a bunch of new features. Below are outstanding features worth upgrading to
Top applications for converting photos into paintings on phones. Today, WebTech360 will continue to introduce to everyone a number of applications for converting photos into paintings.
NoxPlayer: Details of the latest 7.0.1.2 update, NoxPlayer is an extremely familiar Android emulator on PC. In each of its updates, NoxPlayer
What makes BlueStacks X worth using over other cloud gaming platforms, BlueStacks X is a completely new, free cloud gaming platform. Compare to
Applications that should not be installed if you want data security. Applications on smartphones are not always safe. Here are the types of apps you should avoid
1Password vs. LastPass: Which password management software is right for you?, Are you looking for a suitable password manager? 1Password and LastPass are two popular options
Tips to easily remove spyware from your computer. Do you suspect your computer is infected with spyware? Don't know how to remove spyware from your PC? Don't worry. In this article, you
BlueStacks 5 improves FPS, consumes less RAM and is more powerful, Bluestacks Systems, Inc. just introduced the latest BlueStacks 5 to global gamers. Even though it's just in stage
Improved mouse sensitivity for Free Fire on BlueStacks, BlueStacks has made important improvements for Free Fire gamers. Please upgrade BlueStacks 4.230.10
