"Applying Excel 2010 Galleries to the Spreadsheet Objects"


The Excel 2010 galleries are a large collection of tools that look like the choice they represent.

In Excel's Ribbon, a gallery is a collection of preset options that you can apply to the selected object in the worksheet. The objects can be charts, tables and lists of data, or graphics that you add to the worksheets.

Excel 2010 is jammed full of style galleries that make it a snap to apply new sophisticated and colorful formatting to the object in the spreadsheet. To get the most out of galleries, you need to know how they work.

Although some galleries are available all the time, in most cases you must select an object before you work with a gallery.


Excel 2010 Galleries and Live Preview

Coupled with the Excel 2010 Live Preview feature, Excel's style galleries go a long way toward encouraging you to create better looking, more colorful, and interesting spreadsheets.

Although Excel 2010 galleries help to give you an idea of what your object will look like when an option is selected, Live Preview takes it to the next level.

Live Preview displays your object or data as it will look right on the worksheet when you hover over the gallery tool. By hovering mouse over the various tools in the gallery, you can see exactly what your object will look like before you commit to a format.


To work with a gallery list

  • If necessary, click the object (ex; a clip art, graphic, etc) with which you want to apply an option from the gallery. You will notice that a new Picture Tools Format tab exists.
  • Gallery and picture tools format tab
  • In the Picture Styles group, click the gallery's More arrow. You can also scroll through the gallery by clicking the Down and Up arrows. Move the mouse over a gallery option to see a preview of the effect.
  • Click the gallery option you want to use. Excel applies the gallery options to the selected object.


To work with more gallery effects

  • If necessary, click the object with which you want to apply an option from the gallery.
  • In the Picture Styles group, click the Picture Effects drop-down arrow button. Excel displays a list of the gallery's contents.
  • Excel 2010 picture effects galleries

  • If the gallery contains one or more sub-galleries, click the sub-gallery you want to use. Excel displays the sub-gallery's contents.
  • Move the mouse over a gallery option to see a preview of the effect. Excel displays a preview of the effect.
  • Click the gallery option you want to use. Excel applies the gallery option to the selected object.


Related Topics:

What are the Excel 2010 Three Different Views?

Discover the Excel 2010 Smart Tags Feature!



Can't find what you're looking for? Try Google Search!

Custom Search


Back to Top

You're viewing the Excel 2010 galleries info page, click here to go back to the Home Page

Add To Your Social Bookmarks: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Resources:

Click on the image to view the details of the training/book.
Excel 2010 formulas ebook
Microsoft Excel 2010 Formulas


Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007




XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.