Microsoft Excel

Help for Microsoft Excel. Mostly 2007-2013 but many of these solutions will apply to 2003.

Where is the Chart Wizard?
Excel 2010 no longer provides the Chart Wizard as you know it. Instead you use the Insert Tab and choose the chart style under the Chart subgroup.  Once the...
Tue, Nov 25, 2014 at 3:06 PM
When copying and pasting data from one column to another and then add more data, I get a data validation error even though the data is the same type pasted into the column
When you copy data from one cell to another, Microsoft Excel copies the entire cell, including formulas, values, comments, and most importantly, cell format...
Tue, Nov 25, 2014 at 3:06 PM
Where do I find Options in Excel?
 Click File then Options.  The Options are grouped into categories along the left.
Tue, Nov 25, 2014 at 3:07 PM
Why is the cell displaying "####" instead of my number/data?
 Pound signs (####) will display when the column isn't wide enough to display the numeric data.  To correct this: Select the column you need to w...
Tue, Nov 25, 2014 at 3:07 PM
How do I sort text in my Excel worksheet?
 To sort text: Select a column with alphanumeric data to be sorted in a range of cells, or make sure that the active cell is in a table column contain...
Tue, Nov 25, 2014 at 3:08 PM
How do I sort numbers in my Excel worksheet?
 To sort text: Select a column with alphanumeric data to be sorted in a range of cells, or make sure that the active cell is in a table column contain...
Tue, Nov 25, 2014 at 3:08 PM
How do I sort dates in my Excel worksheet?
 To sort dates: Select a column of dates or times to be sorted in a range of cells, or make sure that the active cell is in a table column containi...
Tue, Nov 25, 2014 at 3:09 PM
Can I automatically add the current date in a cell?
Yes.  Select the cell where you would like to insert the current date and press CTRL + ; (semi-colon).  
Tue, Nov 25, 2014 at 3:09 PM
How can I adjust my worksheet to print on one page?
To adjust the worksheet size by percentage: Click anywhere in the desired worksheet Click the Page Layout tab then click the small button in the r...
Tue, Nov 25, 2014 at 3:10 PM
How do I hide or unhide rows or columns?
 To hide one or more rows or columns: Select the rows or columns you want to hide Click the Home tab, then Format (in the Cells subgroup) Do one...
Tue, Nov 25, 2014 at 3:10 PM