how to consolidate data in excel 2010 by color code

Press Ctrl + 1 for the Format Cells dialog Using Numeric Formatting with Thousands Separators The remaining nine categories each offer a collection of controls to customize the numeric format.Ī. The Custom category allows you to use formatting codes to build any number format. The General and Text categories each have a single setting.

The Number tab is the active tab when you display the dialog by clicking the dialog launder icon in the lower-right corner of the Number group in the Home tab. The Format Cells dialog offers far more number formats than the Home tab Changing Numeric Formats by Using Built-In Formats in the Format Cells Dialog The percentage icon is better to use on the ribbon rather than the Format Cell dialog box.įraction-the drop down rounds the integer to one digit divisorsī. Percentage-uses two decimal places when selected from the drop-down. The positive numbers are aligned in the right side of the cell for aligning up the negative numbers. The symbols are left aligned with the edge of the cell. A negative number is shown with the hyphenĪccounting-negative numbers are shown in parentheses. Number-does not use a thousands separator, forces the decimal places, even though the numbers may not have themĬurrency-the symbol is shown before the number, which has the decimal places. General Format-Is a number format, decimal places, no thousands separator is used, a negative number is shown with a minus sign before the number The drop-down menu has a dozen popular number styles Home tab, Numeric group: currency, percentage, comma style, Increase and Decrease Decimal icon Changing Numeric Formats by Using the Home Tab Protection-used to lock or unlock certain cellsĪ. Number-You can also use the Custom category formattingĪlignment-Offers setting for horizontal alignment, vertical alignment, rotation, wrap, merge, and shrinking to fit.įont-Controls font, size, style, underline, color, strikethrough, superscript, and subscript.īorder-Controls line style and color for each of the four borders and the diagonals on each cell.įill-Offers 16 million fill colors and patterns. Icons for wrapping text, vertical alignment, and text rotation on the Formatting toolbar Select Format Cells from the Format dropdown on the Home tabįont, Alignment, and Number groups on the Home tab.Right click any cell and select Format Cells.

Each icon opens the dialog, with the focus on a different tab

Click the dialog launcher icons in the lower-right corner of the Font, Alignment, or Number groups.

Ctrl + Shift + F to display the Font tab on the same dialog.

On the Home tab, Formatting icon, Format Cells dialog box:.Headings for each product line are rotated, merged and centered. Numeric formatting has removed the extra decimal places and added thousands separatorsĪ short row adds a visual break between the product lines The title is prominent in a larger font, and a headline typeface is used The reader can instantly focus on the totals for each lineĪccent colors highlight the subtotals and totals Use formatting commands-On the Home tab, Format Cells dialog box Use cell styles-You can use cell styles to identify titles, headings, and accent cells Use tables styles - with banded rows, accents for totals, please refer to ch.

How to consolidate data in excel 2010 by color code