Excel – Use ‘Auto Sum’ in a Worksheet (Excel 2007 & Excel 2010)
You can sum a group of numbers in Excel 2007 & Excel 2010 with one click of a button!
This post is only available to members.
Excel – Use Merge & Center for Text (Excel 2007 & Excel 2010)
Merge & Center allows you to group cells (e.g. a header over multiple columns) and center the text within that group of cells.
This post is only available to members.
Excel – Wrap Text in a Cell (Excel 2003, Excel 2007 & Excel 2010)
If you are typing text into a cell and it is longer then the cell allows for, you can ‘Wrap Text’ to allow all text to appear in one cell. This will work in Excel 2007 & Excel 2010.
This post is only available to members.
Excel- Using ‘Auto Fill’ Options (Excel 2010/2007/2003)
By default Excel will fill in numbers and dates when you use the ‘Auto Fill’ handle. Did you know that it will also fill in days of the weeks and months? This will work in Excel 2007 & Excel 2010.
This post is only available to members.
Spellcheck Words in UPPERCASE (Office 2007)
By default Office 2007 does not spellcheck any words typed in uppercase letters. In order to make sure there are no spelling errors in your documents, no matter what case they are typed in, you will want to change a setting in each program. This example is shown using Microsoft Excel but is applicable to all Microsoft Office 2007 programs.
This post is only available to members.