Learn: How Are Mechanical Keyboards Different From Regular Keyboards?
How is a mechanical keyboard different from a regular keyboard? Let's find out the difference between these two types of keyboard in the following article of WebTech360!
Summary of 70+ Most Useful Excel Shortcut Keys You Know
If you use Excel software basically, we will think it is not difficult, but for accountants or storekeepers, this is a software with a number of words, extremely complex calculation formulas, not easy. to use, especially in work that needs to be mastered to help solve problems faster. So keyboard shortcuts play an extremely important role to optimize your time. Join WebTech360 to learn the most useful Excel shortcuts to work most efficiently .
What Are Shortcut Keys?
During daily computer use, a shortcut is a sequence of keys or a combination of key combinations on the computer keyboard to call and execute commands in the software.
Most keyboard shortcuts will require the user to press a key or a sequence of keys in turn. While other shortcuts require pressing and holding multiple keys simultaneously. Depending on the operating system, the program and the user's settings, the shortcut operation will be different.
In this article, we will guide you through the most useful Excel shortcuts , apply them immediately to your daily work to save time and increase your work productivity many times!
Excel shortcuts to help you work as fast as "Lightning"
70+ Most Useful Excel Shortcut Keys You Should Know
In addition to the ways of remembering the familiar keyboard shortcuts that are often used as taking notes or getting used to them. You can easily memorize a lot more keyboard shortcuts just by categorizing them into groups.
Today we will reveal the most useful shortcuts in Excel by headings for your convenience to follow and remember.
Working with the shortcut Ctrl
List of the most useful Excel keyboard shortcuts for manipulating the Ctrl key:
CTRL + TAB Switch between open Excel files
CTRL + PAGE UP Switch to the left sheet
CTRL + PAGE DOWN Switch to the right sheet
CTRL + HOME Move back to the first row and column in the sheet
CTRL + END Move back to the last row and column in the sheet
CTRL + N Create a new file
CTRL + O Open a saved file
CTRL + P Print file
CTRL + S Save the page
CTRL + W Close current Excel sheet
CTRL + SHIFT + A Inserts a comma ( ) and arguments after entering the function name
F4 or CTRL + Y Repeat the last action
CTRL + C Copy selection
CTRL + D Copy the value from the cell above the current cell into the current cell
CTRL + R Copy data from left to right
CTRL + V Paste the value stored in the clipboard
CTRL + X Cut the selected part
CTRL + Z Go back to the last action
CTRL + DELETE Delete all text in a line
CTRL + – Delete rows and columns
CTRL + ; Update date
CTRL + 0 Hide selected columns
CTRL + 1 Calls up the Format Cells dialog box
CTRL + 5 Enable/disable centerline and non-centerline mode
CTRL + 9 Hide selected lines
CTRL + B Enable/disable the bold part
CTRL + I Turn italic on/off
CTRL + U Turn the underline on/off
CTRL + SHIFT + – Removes the border for the selected cells
CTRL + SHIFT + # Reformat Data type for day, month, year
CTRL + SHIFT + $ Reformat Curency number with two decimal places
CTRL + SHIFT + % Reformat Percentage Numbers (no decimal places)
CTRL + SHIFT + & Add Outline
CTRL + SHIFT + ( Show hidden lines
CTRL + SHIFT + : Enter time
CTRL + SHIFT + ? Format Numer with two decimal places
CTRL + SHIFT + ^ Reformat Exponential numbers to two decimal places
CTRL + SHIFT + ~ Format Numbers as General
CTRL + SHIFT + ” Copy the value of the upper cell to the cursor position of the current cell
CTRL + SHIFT + = Insert blank cells or blank lines
CTRL + SHIFT + 0 Show currently selected columns
CTRL + SHIFT + 5 Format is a percentage
CTRL + SHIFT + 9 Show currently selected lines
CTRL + ARROW Move to the position of the last cell containing the data before the empty cell
CTRL + SHIFT + END Extend selection to the last used cell
CTRL + SHIFT + HOME Extend the selection to the top of the worksheet
CTRL + SPACEBAR Select all columns
CTRL + ' Copies the upper cell value at the cursor position of the current cell
CTRL + K Inserts a Hyperlink.
Working with the Shift key
List of the most useful Excel keyboard shortcuts for manipulating the Shift key:
SHIFT + ARROW Select an area
SHIFT + ENTER Fill in the data in the cell and move up to the upper position in the selection
SHIFT + HOME Extend the selection back to the first line
SHIFT + PAGE DOWN Extend selection down one screen
SHIFT + PAGE UP Extend selection up one screen
SHIFT + SPACEBAR Select an entire line
SHIFT + F2 Insert more comments
SHIFT + TAB Write data to the cell and move left the selection.
Working with the Alt . key
List of the most useful Excel keyboard shortcuts for working with the Alt key:
ALT + TAB Switch between programs
ALT + = Call the Auto Sum function
ALT + ENTER Down one line in cell
ALT + DOWN ARROW Displays a list of values in the current column
ALT + DP Shortcut Insert / PivotTable
ALT + AE Shortcut Data / Text to Column
ALT + DB Shortcut Data / Subtotal
ALT + OHU Show hidden sheet
ALT + OHH Hide sheet
ALT + OCA Auto Align Column Width
ALT + ES Paste Special
ALT + DFF Shortcut Data / Filter
ALT + WF + ENTER Keyboard Shortcut View / Freeze or Unfreeze Panes
ALT + WS Shortcut View / Split
ALT + N + (Type of chart) Insert chart types.
Office computer configuration 2021 for office people
- Mainboard: Gigabyte H410m-H
- CPU: Intel Core I3 10100 Up To 4.3g | 4 Core | 8 Thread
- Ram: Lexar 8gb Ddr4 2666mhz (1x8gb)
- SSD: Gigabyte SSD 240g Sata III
- Power: Aerocool Vx Plus 400 400w
Case : Jetek Kamado (No Fans)
This is the minimum configuration for office work, if you want to watch movies, play games at a higher level, you should upgrade this configuration.
Those are the 3 most useful groups of shortcuts in Excel that WebTech360 has made, making it easy for you to remember as well as classifying groups that will make it convenient for you to use these shortcuts. If you find it useful, continue to follow WebTech360 for more interesting information.
Instructions on How to Use the VLOOKUP Function in Excel
Using the VLOOKUP function in Excel brings many benefits to you in study and work. Find out more with WebTech360 through the article below
Instructions to Create Table of Contents In Word Anyone Can Do It
Try getting started with creating a table of contents in Word. If you do not know how, please refer to the useful information shared by WebTech360!
Reveal 5 Ways To Round Numbers In Excel With Round, Roundup Functions
Want to round numbers in Excel but don't know how? The following article will show you how to round numbers in Excel.
What is the integrated graphics card in the CPU? Advantages of integrated graphics card
What is the integrated graphics card in the CPU? Integrated graphics cards possess many advantages that are highly appreciated by users. Why do so many people choose this card?
What is Coffee Lake? What you need to know about this new Intel Chip
Coffee Lake is a CPU generation that has witnessed a completely different change from Intel. Let's learn more about this chip.
Summary of 70+ Most Useful Excel Shortcut Keys You Know
Keyboard shortcuts play an extremely important role to optimize your time. Join WebTech360 to learn useful Excel shortcuts to work efficiently.
7 fastest ways to take screenshots of computers and laptops on Windows 10
Are you new to computers and don't know how to take screenshots of your laptop or computer? Let's refer and pocket right away the very simple and quick way to take photos later.
Experience buying old computer monitors
The following buying experience for used computer monitors is guaranteed to help you feel more confident when choosing, regardless of whether the monitor has been used before or not.
How To Register New Gmail, Create Gmail, Create Gmail Account
Gmail brings a lot of benefits to human communication and information exchange activities. So how to register or create a new gmail?
Top 10 Quality And Competitive Price Copiers
Copiers are increasingly improving in quality and price. Each copier will have a different configuration and price to meet consumer needs.
Top 10 Best Selling Canon Printers in the Market in 2023
This Canon printer product is always of good quality. Below are the printer products of the most selected brands.
Instructions for Downloading .Net Framework and installing it on your computer
Instructions for Downloading .Net Framework and how to install it easily and quickly for the machine to be able to use after only a few minutes.
5 Simple Ways to Capture Macbook Screen, Guaranteed Clarity
Taking Macbook screen is extremely easy and simple. Because Macbook provides quite a lot of these features for users to be more convenient during use.
The Most Modern And Effective Wifi Extender on the Market
Wi-Fi range extender is very necessary for you at the present time. To learn more about the product, you should refer to the information in the article below.
How To Recover Gmail Password For Those Who Forget It
How to retrieve Gmail password without phone number is super simple and fast with only 5 steps. Find out more details in the following article.
Download Viber For PC, Laptop Fastest, Easiest
Viber is a very popular online calling and messaging application today. This article will show you in detail how to download Viber for PC, laptop quickly.
Summary of Important Computer Shortcuts You Must Know
Computer shortcuts help you perform computer operations faster and more professionally. Below is a list of important keyboard shortcuts that you should keep in mind.
What is Bypass? Important Information iPhone Bypass You Didnt Know
What is Bypass? Advantages and disadvantages and the most accurate and effective way to identify IDs. All of the above questions will be answered in the article below.
Things To Know About SSDs And HDDs
To help customers better understand SSD and HDD, WebTech360 has shared what they need to know about SSD and HDD through the article below.