totn Excel

MS Excel: Cells

In Microsoft Excel, a cell is a rectangular box that occurs at the intersection of a vertical column and a horizontal row in a worksheet. Vertical columns are numbered with alphabetic values such as A, B, C. Horizontal rows are numbered with numeric values such as 1, 2, 3.

Microsoft Excel

Each cell has its own set of coordinates or position in the worksheet such as A1, A2, or M16. In the example above, we are positioned on cell A1 which is the intersection of column A and row 1.

A cell can only store 1 piece of data at a time. You can store data in a cell such as a formula, text value, numeric value, or date value.

There are many things that you can do with cells in Excel such as changing the font format, number format, background, alignment, and conditional formatting. Here is a list of topics that explain how to use cells in Excel.

Font Format

Number Format

Fill/Background Format

Alignment Format

Border/Line Format

Protection

Conditional Formatting

  • Change the font color based on the value in the cell in Excel 2011 | 2010 | 2007 | 2003
  • Automatically alternate row colors (one shaded, one white) in Excel 2010 | 2007 | 2003
  • Automatically alternate row colors (two shaded, two white) in Excel 2010 | 2007 | 2003
  • Automatically alternate row colors (three shaded, three white) in Excel 2010 | 2007 | 2003
  • Automatically highlight highest and lowest values in a range of cells in Excel 2011 | 2010 | 2007 | 2003
  • Automatically highlight expired dates and dates that are 30 days from expiration in Excel 2010 | 2007 | 2003
  • Highlight 1st, 2nd, 3rd highest scores in Excel 2003
  • Change the font color in one cell based on the value in another cell in Excel 2003

Data Validation

Comments

AutoCorrect

Miscellaneous