• E-mail info@agility-biz.com
  • Phone 908-577-2782

What are the best tips for use of excel documents?

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.

Display formulas

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.

User Dashboard Client Zone