How to Program an Entire Column in Excelby Angela M. Wheeland
Programming, or formatting, an entire column in Excel allows you to change a column's appearance or functions according to the information you enter in the cells. Microsoft Excel has many features to format a column, including color, font, bordering and alignment. In addition, you can format a column to display specific number formats, including dates, zip codes, percentages and currency. Programming a column's number or word properties instructs Excel to format cells automatically.
Click the column header that you want to program. Excel highlights all of the cells in the column.
Right-click the column header, and click "Format Cells."
Click the "Number" tab to change the column's value. By default, a column's value is "General," which does not format the cell. Change the column to represent the information in the cells. For instance, if the column contains dates, click "Date." If the cell includes zip codes or Social Security numbers, click "Special." Create your own formatting code by clicking "Custom."
Click the "Alignment" tab to adjust the alignment of each cell in the column. Adjust the control of the text by clicking "Wrap Text" or "Shrink to Fit." Change the orientation of the text by adjusting the slider in the "Orientation" section.
Click the "Font" tab to change the column's font, style, size, color and effects.
Click the "Border" tab to add borders to each cell in the column. Chose a line style, and then click an option in the "Presets" section. If you want to draw your own borders, click the cell under the "Border" section and draw the lines.
Click the "Fill" tab to choose a background color for the column. Click the "Pattern Style" drop-down to change the background pattern. Click the "Pattern Color" drop-down to choose a color for the pattern.
Click "OK" to apply the settings.
- check If cells in the column display "#####" after you apply the formatting, the column is not wide enough. Double-click the line between the column heading and the following column heading to resize the column to fit automatically.
Click here to provide feedback on this article