Very Helpful Excel Commands for Excel

an = inside the cell starts a formula

* / + - are numeric operators

& is a text operator and requires double quotes around text (but not around cell addresses)

Below 2007:

Menu Option	Sub-option	General Info	Some Details
Format	Cells	Anything that effects the way the cell looks, without effecting the actual contents	Date, Currency, etc Font & color Wrap Merge Border Backgrounds
File	Page Setup	Anything effecting print only. Nothing in this effects the on screen look.	Rows to Repeat at top Header/Footer Fit to 1 * 99 Landscape/Portrait Print Area
Window	Freeze / Unfreeze	Stick headings on screen only	Must be in view / normal first
Data	Sort	Sort rows	Highlight all rows first
Insert	Function	Formulas Excel provides	If, Sum, etc.

Excel 2007:

Tab	Command	General Info	Some Details
Home	Format (Format cells choice)	Anything that effects the way the cell looks, without effecting the actual contents	Date, Currency, etc Font & color Wrap Merge Border Backgrounds
Page Layout	Page Setup dialog box	Anything effecting print only. Nothing in this effects the on screen look.	Rows to Repeat at top Header/Footer Fit to 1 * 99 Landscape/Portrait Print Area
View	Draft and then Freeze / Unfreeze	Stick headings on screen only	Must be in view draft first
Data	Sort	Sort rows	Highlight all rows first
Formula	insert function	Formulas Excel provides	If, Sum, etc.