Most common Keyboard Shortcuts and Formulas
Though it’s often said there’re many productivity hacks that will make manipulating your spredsheet faster and easier, it’d be enough first to make youreslf familiar with the most handy and practical keyboard shortcuts, and formulas. By learning a few simple methods, you can speed up your workflow and save your valuable time.
1. the most important Google Sheets shortcuts
- Copy and Paste
- Paste values only
- Skip to edges
- Select all (and delete all)
- Select a range manually
- Activate the cell for editing at the end of the cell contents
- Move to the next line in a cell
- Insert the current date in a cell
- MAX & MIN
- COUNT & COUNTA
Click and drag your mouse over the cells you want to copy to highlight them. Then, single-click on the top cell where you’d like to paste and press Ctrl + V.
Paste： Windows Ctrl + V | Mac ⌘ + V
It will paste the values only of the copied range without formulas and formatting like a color, cell borders, and allow users to obtain just the numers or letters.
Sheets undo feature allows us cancel previous actions. You can step back in time and fix any accidental changes or deletion that you didn’t intend for.
It allows you to repeat the last action. It’s handy particularly when you repeat the action that requres clicking a icon in the toolbar each time. For example, you need to click the Merge icon for each uniting cells by default. But, once after you’ve done this, you can repeat it just by pressing Ctrl + Y or F4.
You can jump to the end of a row or column, holding Ctrl and pressing one of the four arrow keys. It instantly takes you to the edges of a large dataset or lengthy list without scrolling all through it. It’s easy, but extremely powerful.
Mac ⌘+ ⇦ ⇧ ⇨ ⇩
It’s helpful especially when you want to cut or copy all at once.
Sometimes, using a mouse actually slows you down and in this case, it most likely does. When you have a range to copy, you would click the top-left cell in the range and click and hold down the left mouse button and drag to the lower rightmost cell in the range. However, it often lets you mistakenly drag over the range, you end up fixing it by dragging the mouse back again. Shift + arrow keys, on the other hand, makes you do this more precisely.
F2 can be one of the most practical keys in Sheets. It helps you quickly and easily edit the data of a cell by leading to Sheets edit mode without clicking the cell.
Instead of the shortcut, the formula “= TODAY()” also returns the current date.
2. the most basic Google Sheets formulas
“= SUM (B2:B8)” is to sum up the multiple cells within the range from B2 to B8. In selecting the range, the shortcut key No. 7 “Select a range manually” lets you do this more easily and accurately. If you simply want to add up a few numbers, you can use the SUM function or arithmetic operator as below. Both would return 1500.00.
The function evaluates a set of values in the range and gives you the average of all the numbers in B2:B8, omitting the text.
While MAX is to return the maximum number in the range, MIN is to give you the minimum.
While COUNT only counts numerical cells in the range, COUNTA takes all cells with contents into account, whether numbers or not.
Syntax ⇨ IF(logical_expression, value_if_true, value_if_false)
・logical_expression : An expression or reference to a cell containing an expression that represents some logical value like TRUE or FALSE.
・value_if_true : The value the function returns if logical_expression is TRUE. In this example, “sell”.
・value_if_false (blank by default) : The value the function returns if logical_expression is FALSE. In this example, “hold”.