After you enter or paste text and numbers into Excel, the cells don’t expand to fit their contents. The fast way to autofit columns and rows is to hover your mouse over the header border between the column and its neighbor to the right, or between two rows at the far left of the worksheet. When the resize icon appears, double-click.

Paste formatting with one keystroke

If you’d like to see several disconnected cells to share a format such as bold text and background color, it can be a hassle to select each cell one at a time, open its cell-format dialog box, and make the changes you want. Instead, reformat one of the cells, and then select off of the others by pressing Ctrl, and clicking them one by one. Once they they’re all highlighted, press F4 to apply the formatting to all of them at once.

Auto sum shortcut

When you’d like to do a simple sum on a column or row of figures you can simply put your cursor in the cell where you’d like to see the summed value. Once in this cell hold down the “Alt” and “+/=” keys at the same time and this will auto sum your desired figures.