Enter data in worksheet cells
You can enter numbers (with or without fixed decimal points), text, dates, or times in one cell, in several cells at once, or on more than one worksheet.
NOTE This topic is about entering data manually. For automatically entering data or data in a series, see Fill data in worksheet cells.
IMPORTANT A worksheet may have been protected by you or someone else to prevent data from being changed accidentally. On a protected worksheet, you may be able to select cells to view the data, but you won't be able to type information in cells that are locked. In most cases, a protected worksheet should not be unprotected unless you have permission to do so from the ...view middle of the document...
* A cell may display ##### when it contains data that has a number format that is wider than the column width. To increase the width of the column, point to Column on the Format menu, and then click AutoFit Selection.
* To display multiple lines of text inside a cell, click Cells on the Format menu, click the Alignment tab, and then select the Wrap text check box. If the text is a single long word, the characters won't wrap; you can widen the column or decrease the font size to see all the text. If not all text is visible after you wrap the text, you may need to adjust the height of the row. Point to Row on the Format menu, and then click AutoFit.
* In Microsoft Excel, the appearance of a number in a cell is separate from the number that is stored in the cell. When a number that you enter is rounded, in most circumstances, only the display of the number is rounded. Calculations use the actual number stored in the cell, not the number as it is displayed. You can change the display of numbers on the Number tab of the Format Cells dialog box (Format menu, Cells command).
* To enter numbers as text, first apply the Text format to empty cells on the Number tab of the Format Cellsdialog box (Format menu, Cells command), and then type the numbers in the formatted cells. Numbers that you typed before you applied the Text format to the cells need to be reentered as text. To quickly reenter numbers as text, select each cell, press F2, and then press ENTER.
Enter numbers with a fixed decimal point
1. On the Tools menu, click Options, and then click the Edit tab.
2. Select the Fixed decimal check box.
3. In the Places box, enter a positive number for digits to the right of the decimal point or a negative number for digits to the left of the decimal point.
For example, if you enter 3 in the Places box and then type 2834 in a cell, the value will be 2.834. If you enter -3in the Places box and then type 283, the value will be 283000.
4. On the worksheet, click a cell, and then enter the number that you want.
NOTE Data that you entered before selecting the Fixed decimal option is not affected.
Tip To temporarily override the Fixed decimal option, type a decimal point when you enter the number.
Enter dates or times
1. On the worksheet, click a cell.
2. Type a date or time as follows:
* For a date, use a slash mark or a hyphen to separate the parts of a date; for example, type 9/5/2002 or 5-Sep-2002.
Tip To enter the current date, press CTRL+; (semicolon).
* For a time that is based on the 12-hour clock, type a space, and then type a or p after the time; for example, 9:00 p. Otherwise, Excel enters the time as AM.
Tip To enter the current time, press CTRL+SHIFT+; (semicolon).
* To enter a date or time that stays current when you reopen a worksheet, you can use the TODAY and NOWfunctions.
* When a date or time is typed in a cell, it appears either in a default date or...