fhgfghfghfh

Excel Formulas - Cheatsheet

Sum of Rows/Columns

=SUM(E8:BC8)

creating borders for table

 

Go to next line in cell - Alt+Enter

• To go to next line in cell, hit "alt+enter". i.e. excel has you go to next cell by just clicking enter

Fundamentals: Fitting Text into Spreadsheet Columns

• Code: Cells.EntireColumn.AutoFit
• AutoFix: Double clicking on edge of cell's divided line; not the most reliable solution

Print Preview - Print Titles > Page Layout > Sheets > Gridlines

Click Print Titles under page layout. Under Sheets, check box "Gridlines".

*if you want see gridlines while working, check box "Gridlines' under Page Layout

Creating border for each column

to create gridlines, create borders which, can be found at the top left hand corner of toolbar. Icon is a pencil overlapping a grid