Page 11 of 22PREVNEXT

Audio course: Get to know Excel: Create your first workbook

Text aligned on the left in a cell and dates aligned on the right in a cell

Excel aligns text on the left side of cells, but it aligns dates on the right side of cells.

To enter a date in column B, the Date column, you should use a slash or a hyphen to separate the parts: 7/16/2005 or 16-July-2005. Excel will recognize this as a date.

If you need to enter a time, you would type the numbers, a space, and then "a" or "p" — for example, 9:00 p. If you put in just the number, Excel recognizes a time and enters it as AM.

Tip     To enter today's date, press CTRL and the semicolon together. To enter the current time, press CTRL and SHIFT and the semicolon all at once.

Page 11 of 22PREVNEXT