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
