Note: The same trick works for percentages! Just hit Ctrl - Shift - % to include the percent sign with each digit. With that simple trick, your entire column will be displayed with the dollar sign, any necessary commas, and two points after the decimal point. Simply select the column that contains the digits you want to re-format, and then use the below keyboard shortcut to automatically format that entire column to dollars: There’s no need to do this one at a time. Right now, there isn’t a dollar sign displayed in front of each number, and you’d like to insert one there. Let’s say that you have an entire column that contains digits that represent the same thing-like dollar amounts, for example. Note: The same hack can be used to adjust the height of rows! 4. With that symbol, double click on that line that separates the columns, and the column will automatically be resized to fit the widest piece of text within that column. Place your mouse on the line between two column markers (C and D, for example) until you see a symbol that looks like two opposite-facing arrows. And, needing to click and drag to resize the column to the perfect width over and over again can be a pain.įortunately, you can do this instantly. There’s nothing worse than having your text run outside of the width of the column. Click it once, and every single cell in the spreadsheet will be selected. Or, you can use this simple trick to select all cells with one single click.Īll it takes is clicking on that light gray triangle that appears in the top left corner of your spreadsheet. You can give yourself a finger cramp from tons of endless clicking and scrolling. Have hundreds (or even thousands) of rows of data-and need to select them all? This works with one or multiple cells selected. Save yourself some clicks when formatting by instantly adding a cell border. Select a cell with an active formula and see which cells are directly referenced by that formula. Speed up your number crunching by quickly summing numbers in a contiguous range. For example, if you were rounding the number 328.25 and input “-1” here, it would round you number to 330.Here are a few of our favorites: Autosum all selected cells
You can use type a straight up number in this field to round it, but more often you’ll want to call a number from an existing cell in your sheet. Use the “Number” field for the number you want to round. This pops up the Function Arguments window with the fields you’ll use for setting the ROUND function.
On the “Math & Trig” drop-down menu, click the “ROUND” function. Navigate to the “Formulas” menu on the main ribbon.Ĭlick the “Math & Trig” formulas drop-down menu. Select the cell where you want your rounded results to go. We’re creating a second column named “Results” that we’re going to use to round down the numbers in the “Values” column to three digits. For this example, we’ve got a column of numbers named “Values” that contains our raw numbers.