Bonus tip: With basic formulas, the AutoSum button is the top choice. It’s faster to click AutoSum>SUM (notice that Excel highlights the range for you) and press Enter. Another bonus tip: The ...

Word 2007 Cheat Sheet; Excel 2007 Cheat Sheet; ... set page breaks, specify which rows and columns will print on each page and so on. Formulas: If you’re a spreadsheet jockey, ...

If you need a refresher, see our Excel 2010 cheat sheet. As in Excel 2013, the Ribbon in Excel 2016 and 2019 has a flattened look that’s cleaner and less cluttered than in Excel 2010 and 2007.