28. Tips & Shortcuts
Here, we list some shortcuts and techniques you can use to enable you to work faster especially if you prefer to use keyboard keys rather than the mouse.
1. Quick navigation to first row.
When you are at faraway row, say 10000, you can quickly go to the first row: Hold down the Ctrl key and press Home. This is refered to as the Ctrl+Home combination.
2. Quick navigation to a particular cell.
When you are at certain cell, you can quickly jump to any faraway cell. You must know the address of the cell or any cell near it. Click menu Edit/Go To to open the Go To dialog box. In a box under the Reference label, write the cell address (eg. A112). Click OK.
Оr,
Using the keyboard, press Alt (to activate the menu bar), then press E (for Edit), then press G key (for Go To), then write the address of the target cell, and press Enter.
3. To copy the content of the cell above the current cell to the current cell
At the current cell, press Ctrl. While still pressing the key, press the D key. This is called Ctrl+D combination. When you release the keys, the content, formula and format of the cell above it will be copied.
4. To copy content of the cell on the left of the current cell to the current cell
At the current cell, press Ctrl. While still pressing the key, press the R key. This is called Ctrl+R combination. When you release the keys, the content, formula and format of the cell on its left will be copied.
5. To delete a current row
At the current cell, press Alt (to activate the menu bar), then press E (for Edit), then press D key (for Delete), then press R key (for Row). The whole row of the current cell will be deleted.
209
6. To save current file
On the keyboard, press Alt (to activate the menu bar), then press F (for File), then press S key (for Save). Or, use the Ctrl+S combination.
7. To find a text, number or date
On the keyboard, press Alt (to activate the menu bar), then press E (for Edit), then press F (for Find), then write the item you want to find, finally press Enter. Excel will highlight the cell containing the item.
8. To highlight all filled cells from the current cell to the last filled cell in the same column
At the current cell, press Ctrl+Shift+↓ combination to highlight all the cells from the current cell to the last filled cell in the same column. Press Ctrl+Shift+↑ to highlight cells from the bottom.
9. To make a current cell content ready for copying
At the current cell, press Ctrl+C (for Copy). Or press Alt key (to activate the menu bar), then press E key (for Edit), then press C key (for Copy).
10. To paste into a current cell the content of a cell already copied.
At the current cell, press Ctrl+V. Or press Alt key (to activate the menu bar), then press E key (for Edit), then press V key (for Paste).
11. To move from current sheet to the sheet on the left
At the current sheet, press Ctrl+Page Up keys. The sheet on the left will be in focus.
12. To move from current sheet to the sheet on the right
At the current sheet, press Ctrl+Page Down keys. The sheet on the right will be in focus.
13. To highlight a contiguous range of cells downward, one cell at a time
At the current cell, press Shift+↓ keys. Each additional one pressing of the arrow-down key (while still holding down the Shift key) will add another cell into the selection.
210
14. To highlight a contiguous range of cells downward, one screen at a time At the current cell, press Shift+Page Down keys.
15. To highlight non-contiguous cells
Select the first cell. Press Ctrl key. While still holding down the key, click on the intended cells, one by one.
16. To insert a row at the current cell
At the current cell, press Alt key (to activate the menu bar), then press I key (for Insert), then press R key (for Row).
17. To select all cells which contain no formula.
Make sure the active cell is inside the data area. Click menu Edit/Go To to open the Go To dialog box. Click on the Specials button to open the Go To Specials dialog box. Select Constants. Click OK.
Or,
by using the keyboard: Press Alt (to activate the menu bar), then press E (for Edit), then press G (for Go To), then press Alt+S keys (for Specials), then press 0 key (for Constants), finally press Enter.
18. To go to the last row in the data area
Press Ctrl+End keys, then release all the keys.
19. To turn positive number to negative and vice versa when pasting a copied number
Say you want copy a number 100 and you want it to become 100 when pasted to another cell. Use menu Edit/Copy to copy. Then use menu Edit/Paste Special. In the Special dialog box that appears, select the Substract option. Click OK.
20. Look at the status bar to see totals
When you highlight cells which contain numbers, you can see their total at the status bar.
211
No comments:
Post a Comment