- Excel - Context Help
- Excel - Open Workbook
- Excel - Close Workbook
- Excel - Delete Worksheet
- Excel - Hiding Worksheet
- Excel - Copy Worksheet
- Excel - Create Worksheet
- Excel - Save Workbook
- Excel - Move Around
- Excel - Entering Values
- Excel - Backstage
- Excel - Explore Window
- Excel - Getting Started
- Excel - Home
Editing Worksheet
- Excel - Undo Changes
- Excel - Add Text Box
- Excel - Insert Comments
- Excel - Special Symbols
- Excel - Zoom In-Out
- Excel - Spell Check
- Excel - Find & Replace
- Excel - Copy & Paste
- Excel - Rows & Columns
- Excel - Move Data
- Excel - Delete Data
- Excel - Select Data
- Excel - Insert Data
Formatting Cells
- Excel - Apply Formatting
- Excel - Borders and Shades
- Excel - Merge & Wrap
- Excel - Text Alignments
- Excel - Setting Colors
- Excel - Rotate Cells
- Excel - Text Decoration
- Excel - Setting Fonts
- Excel - Setting Cell Type
Formatting Worksheets
- Excel - Conditional Format
- Excel - Freeze Panes
- Excel - Set Background
- Excel - Insert Page Breaks
- Excel - Header and Footer
- Excel - Page Orientation
- Excel - Adjust Margins
- Excel - Sheet Options
Working with Formula
- Excel - Builtin Functions
- Excel - Using Functions
- Excel - Formula Reference
- Excel - Copying Formulas
- Excel - Creating Formulas
Advanced Operations
- Excel - Keyboard Shortcuts
- Excel - Pivot Charts
- Excel - Simple Charts
- Excel - Pivot Tables
- Excel - Data Tables
- Excel - Workbook Security
- Excel- Translate Worksheet
- Excel - Email Workbooks
- Excel - Printing Worksheets
- Excel - Cross Referencing
- Excel - Adding Graphics
- Excel - Using Macros
- Excel - Using Templates
- Excel - Using Themes
- Excel - Using Styles
- Excel - Data Validation
- Excel - Using Ranges
- Excel - Data Sorting
- Excel - Data Filtering
MS Excel Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Using Themes in Excel 2010
Using Themes in MS Excel
To help users create more professional-looking documents, MS Excel has incorporated a concept known as document themes. By using themes, it is easy to specify the colors, fonts, and a variety of graphic effects in a document. And best of all, changing the entire look of your document is a breeze. A few mouse cpcks is all it takes to apply a different theme and change the look of your workbook.
Applying Themes
Choose Page layout Tab » Themes Dropdown. Note that this display is a pve preview, that is, as you move your mouse over the Theme, it temporarily displays the theme effect. When you see a style you pke, cpck it to apply the style to the selection.
Creating Custom Theme in MS Excel
We can create new custom Theme in Excel 2010. To create a new style, follow these steps −
Cpck on the save current theme option under Theme in Page Layout Tab.
This will save the current theme to office folder.
You can browse the theme later to load the theme.