Basic formatting in Excel can customize the look and feel of your Excel spreadsheet. Learn about formatting cells in Excel 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 that are 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, Excel fills in the remaining characters for you.
Information in a spreadsheet is likely to change over time. Information can be changed in the following ways.
If the original entry is long and requires only a minor adjustment (in spelling, for example), then 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 do, like type the wrong number in a cell. Excel 2003 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 cancelled 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 is called the active cell. You can also select a group of adjacent cells, or a cell range. Many operations can be performed 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 and hold down the Control key while selecting other ranges.