Spreadsheet 123 Excel 2007, 2003, XP, 2000, 97 FAQs: Cells

Formatting:

Merge cells in Excel 2007 | Excel 2003/XP/2000/97

Wrap text in a cell in Excel 2007 | Excel 2003/XP/2000/97

Wrap text in merged cells in Excel 2007 | Excel 2003/XP/2000/97

Protect a cell in Excel 2007 | Excel 2003/XP/2000/97

Rotate text in a cell in Excel 2007 | Excel 2003/XP/2000/97

Create a superscript value in a cell in Excel 2007 | Excel 2003/XP/2000/97

Create a subscript value in a cell in Excel 2007 | Excel 2003/XP/2000/97

Draw a line through a value in a cell (strikethrough) in Excel 2007 | Excel 2003/XP/2000/97

Draw a border around a cell in Excel 2007 | Excel 2003/XP/2000/97

Change a font in a cell in Excel 2007 | Excel 2003/XP/2000/97

Change the font size in a cell in Excel 2007 | Excel 2003/XP/2000/97

Change the font color in a cell in Excel 2007 | Excel 2003/XP/2000/97

Change the background color of a cell in Excel 2007 | Excel 2003/XP/2000/97

Format display of text in a cell (ie: numbers, dates, etc) in Excel 2007 | Excel 2003/XP/2000/97

Stop "wrap text" when pasting in Excel 2007 | Excel 2003/XP/2000/97

Conditional Formatting:

Change the font color based on the value in the cell in Excel 2003/XP/2000/97

Automatically alternate row colors (one shaded, one white) in Excel 2003/XP/2000/97

Automatically alternate row colors (two shaded, two white) in Excel 2003/XP/2000/97

Automatically alternate row colors (three shaded, three white) in Excel 2003/XP/2000/97

Automatically highlight highest and lowest values in a range of cells in Excel 2003/XP/2000/97

Automatically highlight expired dates and dates that are 30 days from expiration in Excel 2003/XP/2000/97

Highlight 1st, 2nd, 3rd highest scores in Excel 2003/XP/2000/97

Alignment:

Centre text across multiple cells in Excel 2007 | Excel 2003/XP/2000/97

Align text to the top of the cell in Excel 2007 | Excel 2003/XP/2000/97

Validation:

Set up cell to only allow a certain number of characters in Excel 2007 | Excel 2003/XP/2000/97

Set up a cell to only allow numbers in Excel 2007 | Excel 2003/XP/2000/97

Comments:

Display comment indicator in Excel 2007 | Excel 2003/XP/2000/97

Miscellaneous:

Hide formulas from appearing in the edit bar in Excel 2007 | Excel 2003/XP/2000/97

Copy and paste only nonblank cells (condensing paste range) in Excel 2007 | Excel 2003/XP/2000/97

Suggested Reading

Home | About Us | Our Services | Software | Excel Templates | Excel Tutorials | Useful Links | Site Map | Contact Us

| Terms of Conditions |

---

Unless otherwise stated, all images and text
Spreadsheet123

---