Flash Fill Excel Plus Sign At

This opens the New Formatting Rule window, which is where you define the rule.

Two closely-related features can spruce up your spreadsheets with a minimum of work.

Themes Themes let you change the overall appearance of your worksheet with only a couple of mouse clicks.

To change your worksheets theme, first make sure youve saved any changes (so you can easily revert to the saved version, if you wish).

Next make sure the Ribbon is visible (View - Ribbon), click the Home button in the Ribbon, then click on the Themes button to display the available themes.

Note, too, that you can save your own theme by using the Save Theme option at the bottom of the theme chooser.

This is ideal for those in corporate environments who may have required settings for fonts and colors in their worksheets.

Create a custom theme using those fonts and colors, and youre ready to go.

Themes allow you to easily change the overall appearance of your worksheet Cell Styles Cell Styles are closely related to Themes, but work at the cell level instead of at the worksheet level.

As with Themes, youll find Cell Styles on the Home tab of the Ribbon.

Highlight a cell, or range of cells, and click Styles to see a drop-down panel containing a number of pre-defined styles.

For instance, if youve got a range of data that youre unsure of and want to check later, select the Check Cell style to turn those cells into double-outlined white-on-gray; use the Note style to give the selection the appearance of a yellow sticky note.

As with Themes, you can define and save your own Cell Styles, too, making it simple to apply a personal style to any cell.

For instance, use the Check Cell style to mark questionable data.

Sparklines help you track trends Excel 2011s Sparklines make it easy to see trends in your data by looking at a single cell.

With only a few products and salespeople, youre looking at a huge array of numbers, making it difficult to see who are your strongest salespeople.

Sparklines solve that problem by placing a graph of a data range into one cell, giving you a visual representation of that data.

With a glance, it becomes obvious which of your salespeople are doing well, and which are not.

To create a Sparkline, select the cell where youd like the graph to appear (typically close to the data being graphed), then select Insert - Sparklines.

Sparklines show you trends in your data that you might otherwise miss.

Conditional Formatting reveals key values The greatly-improved Conditional Formatting feature in Excel 2011 is another good tool for revealing trends and key values in your data.

In the past, Conditional Formatting could do this, but you really had to work hard to get the most out of the feature.

Excel 2011 offers a lot of pre-defined conditional formats that can be used with a few mouse clicks.

To get started, select the data range youre interested in analyzing, then choose Format - Conditional Formatting.

Flash Fill Excel Plus Sign At

The Manage Rules window will appear; click the plus sign at the bottom to add a new rule for your selected range.

Flash Fill Excel For Mac