Basic formatting in Excel XP can customize the look and feel of your Excel XP spreadsheet. Learn about formatting cells in Excel XP here.
You can enter three types of data in a cell: text, numbers, and formulas. Text is any entry that is not a number or formula. Numbers are values used when making calculations. Formulas are mathematical calculations.
Excel's AutoComplete feature keeps track of previously entered text. If the first few characters you type in a cell match an existing entry in that column, Microsoft Excel fills in the remaining characters for you.
Information in a spreadsheet is likely to change over time. Information can be changed in two ways.
If the original entry is long and requires only a minor adjustment (in spelling, for example), you can directly edit the information in the cell.
Method 1: Direct cell editing
Method 2: Formula bar editing
Sometimes you might do something to a spreadsheet that you didn't mean to, like type the wrong number in a cell. Excel XP allows you to undo an operation. Use the Undo button on the Standard toolbar to recover an error. The last single action is recoverable.
An Undo operation can be canceled by applying a Redo. This is useful when an Undo operation was mistakenly applied. Remember, a redo is possible only if you have not changed an Excel spreadsheet since the last Undo operation was completed:
The currently selected cell in Excel XP is called the active cell. You can also select a group of adjacent cells, or a cell range. Many operations can be done against a cell range, including moving, copying, deleting, and formatting. A cell range can be defined in different ways: select a specific range of cells, select multiple columns or rows, or select the entire worksheet.
If the cells and columns you want to select are not directly next to one another, select one of the ranges you want to select, then hold down the Control key while selecting other ranges.