Quickly add up data
Quickly add up an entire column or row of data by clicking in the first empty adjacent cell and pressing ALT+= (that’s the equals key). Excel will then automatically sum all of the numbers it can find in that row or column.
If you want to see quickly which cells contain a formula, or would prefer all the formulas on a page to be visible, just press CRTL+’ (that’s the acute accent key, beside the “1” on most keyboards). You can toggle back to the values view by pressing the same keys again.
Combine text from two or more cells into one
Say you’ve got first names and last names in separate columns, and you want to combine them into one. In a third cell type =(. Then click the cell that contains the first text you wish to combine and type &” “& (a space enclosed in quotation marks). Click the next cell with the text that you want to combine. Hit enter, and you’re set.
Find and replace across an entire worksheet
Finding specific text in a document using the CTRL+F shortcut is pretty well known. Less well known is that hitting CTRL+H will open up the find and replace dialog box, allowing you to replace data in multiple cells in one go.
Jump to the start or end of a column
You’re hundreds of rows into a spreadsheet, and you need to get back to the first or last cell. Scrolling works but takes time. The quickest way is to press CTRL+↑ (that’s the up arrow) to go to the top of a column or CTRL+↓ (the down arrow) to jump to the bottom of a column.