Each Microsoft Excel worksheet is broken up into cells. Each cell is part of a column. Excel's myriad formatting tools let you add colors, formulas and borders almost anywhere in a worksheet.

Learn how to use Excel's Format Painter to apply formatting to entire rows and columns. Formatting allows viewers to distinguish values by type and even sections.

How to Give a Name to the Columns in Excel. The default method for including a column reference in an Excel formula is to use the column letter, a convention that may make it difficult to ...

When you want to fill a column in Excel with a given formula or value, you can do it the old fashioned way (select cells or the column header, CTRL+V . Skip to Main Content.

To multiply certain numbers or cell values in Excel, you’ll need to use the * (asterisk; also called "star") operator. To multiply two numbers in Excel, you can type the formula =number1*number2 in ...

This will apply this formula to the whole column and you won’t receive a #DIV/0! in any of the cells in a column. In a similar manner, you can also use the ISERROR function.