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. Here are a few of our favorites: Autosum all selected cells
0 kommentar(er)
