You are here: Home / Archives for Customization

How to insert background image in Excel 2007

May 30, 2009 By

To insert a background image in Excel 2007 follow these steps:

1. Click on the Page Layout tab.

xl7background

2. In the Page Setup group click Background. The Sheet Background window will open.

xl7background2

3. Switch to the folder where you have the image, select the image and then click Insert.

4. The selected image will show as a background in your sheet.

Note:

When you insert a background image the Background button in the Page Setup group will turn into Delete Background. You can then click on that button to remove the background.

Filed Under: Customization, Excel 2007, Formatting Tagged With: , , ,

How to create a custom cell style in Excel 2007

May 19, 2009 By

Excel 2007 cell styles are helpful in giving your worksheet formatting a consistent look and feel. Excel comes with a number of built in styles. If you are not satisfied with those you can still create and modify your own styles. Here is how you can do it:

1. In the Home Tab, Styles group click Cell Styles.

xl7styles1

2. A list of the built-in styles will be shown in a grid-like format.

xl7styles2

3. Click on New Cell Style at the bottom of the window. The Style window will open.

xl7styles3

4. In the Style name textbox give a name for your style.

5. Click Format in the Style window and specify the formats you want. This include Alignment, Font, Border … etc.

6. Click OK in the Format window, Then OK in the Style window.

7. Your style will be added to the custom styles at the top of the built-in styles. From here own you can apply it to any cell you want.

Filed Under: Customization, Excel 2007, Formatting Tagged With: , , ,

How to show help button in Excel 2007

May 15, 2009 By

To show the help button or icon in Excel 2007 you need to customize the Quick Access Toolbar and add the help button there.

Follow these steps to customize:

1. Right click on the Quick Access Toolbar.
2. Click Customize Quick Access Toolbar.

xlqaccess1

3. The Excel Options window will open.

xl7options

4. On the left pane of the Excel Options window click Customize.
5. Click on the combo box labeled “Choose commands from” and select Commands NOT in the Ribbon or select All Commands.
6. Locate the Help command xl7help and double click on it. It will be moved to the quick access tool bar list to the right.

Tip

You can get Excel 2007 help by simply hitting PF1.

Filed Under: Customization, Excel 2007 Tagged With: , ,

How to show the developer tab in excel 2007

May 10, 2009 By

Excel 2007 user interface does not show the developer tab in the default display. To activate or display the developer tab follow these steps:

1. Click the Microsoft Office Button.

xl7office

2. Click Excel Options, The options window will open.

xl7options

3. Click Popular.

4. Select the Show Developer tab in the Ribbon check box.

Filed Under: Customization, Excel 2007 Tagged With: , ,

Excel 2007 User interface – Developer Tab

May 10, 2009 By

Developer Tab

xl7developer

Excel 2007 user interface does not show the developer tab in the default display. If it is not shown in the ribbon then see How to show the developer tab in Excel 2007.

The developer tab consists of 4 groups:

Code

xl7code

The Code group gives you access to the visual basic editor. You can access your existing macros and write or record new ones. You can also setup macro security level (enable macros to run or disable them).

Control

xl7control

The Control group allows you to insert user controls, switch between design mode and normal mode, access control properties, view code within controls or run a dialogue (user form).

XML

xl7xml

The XML group allows you to add, import or export XML maps into you workbook.

Modify

xl7modify In the Modify group you can specify custom document information panel template (contains author, title, subject ..etc.)

Posts on Excel 2007 user interface:

  1. Introduction
  2. The Home tab
  3. The Insert tab
  4. The Page Layout tab
  5. The Formulas tab
  6. The Data Tab
  7. The Review Tab
  8. The View Tab
  9. The Developer Tab

Filed Under: Customization, Excel 2007 Tagged With: , ,

How to change tab color in Excel 2007

April 22, 2009 By

To change worksheet tab color in Excel 2007 :

1. Select the tab whose color is to be changed.
2. In the Home tab, Cells group, click on Format.
3. Under Organize Sheets, point to Tab Color and select the color you want.

xl7tabcolor1

This is how your tabs will look like:

xl7tabcolor2

Filed Under: Customization, Excel 2007, Formatting Tagged With: , ,

How to customize the quick access toolbar in Excel 2007

April 19, 2009 By

The Quick Access Toolbar, which is part of excel 2007 interface is a customizable toolbar.It comes handy for commands that you use more often.

You can customize the Quick Access Toolbar according to your needs and style by adding the commands you need from the available lists.

Follow these steps to customize:

1. Right click on the Quick Access Toolbar.
2. Click Customize Quick Access Toolbar.

xlqaccess1

3. The Excel Options window will open.

xl7options

4. On the left pane of the Excel Options window click Customize.
5. Click on the combo box labeled “Choose commands from” and select the appropriate tab or group that have the command or button you want.
6. Locate the command you want in the list below the combo box and double click on it. It will be moved to the quick access tool bar list to the right.
7. Repeat the process as long as you want. When you are done click OK.

Tip

You can rearrange the Quick Access commands by using the two buttons with arrows to the far right. Select the command first then click the appropriate button to move up or down in the list.

xlqaccess2

Filed Under: Customization, Excel 2007 Tagged With: ,

Excel 2007 User interface – View Tab

April 14, 2009 By

View Tab

viewtab

The view tab in Excel 2007 ribbon consists of 5 groups:

Workbook Views

viewworkbook

Switch between Normal, printer page layout or page break views. You can also create and show your custom views or switch to full screen view.

Show/Hide

viewshow

You can show or hide gridlines, formula bar or columns and row headings.

Zoom

viewzoom

Zoom in or out with different options.

Window

viewwindow

Create new windows, arrange windows and switch between them, freeze panes or save a workspace.

Macros
viewmacros

This group handles VBA macros. You can record, edit or run macros.

Posts on Excel 2007 user interface:

  1. Introduction
  2. The Home tab
  3. The Insert tab
  4. The Page Layout tab
  5. The Formulas tab
  6. The Data Tab
  7. The Review Tab
  8. The View Tab
  9. The Developer Tab

Applies to : Excel 2007

Filed Under: Customization, Excel 2007, General Tagged With: , ,

Excel 2007 User interface – Review Tab

April 14, 2009 By

Review Tab

reviewtab

The review tab in Excel 2007 ribbon consists of 3 groups:

Proofing

reviewproofing

The proofing group gives you options to check spelling, translate or check synonyms in the thesaurus.

Comments

reviewcomments

Handles comments: add, edit, delete, show or hide.

Changes

reviewchanges

For workbook and worksheet protection, workbook sharing or tracking of changes.

Posts on Excel 2007 user interface:

  1. Introduction
  2. The Home tab
  3. The Insert tab
  4. The Page Layout tab
  5. The Formulas tab
  6. The Data Tab
  7. The Review Tab
  8. The View Tab
  9. The Developer Tab

Applies to : Excel 2007

Filed Under: Customization, Excel 2007, General Tagged With: , ,

Excel 2007 User interface – DataTab

April 12, 2009 By

Data Tab

datatab

The Data tab in Excel 2007 ribbon consists of 6 groups:

Get External Data

dataexternal

Here you can import data into Excel from various external sources like Microsoft Access, Microsoft SQL Server, text files or the web.

Connections

dataconnect

Create and edit connections to external data sources that are stored in a workbook or in a connection file.

Sort and filter

datasort

Sort or filter data based on a specified criteria.

Data Tools

datatools

Here you have various data tools like removing duplicates, validation or data analysis.

Outline

dataoutline

Here you can group data based on a selection or you can create a subtotal in a given column based on values (keys) of another column.

Analysis

dataanalysis

Provides various data analysis tools like random number generation, histogram or moving average.

Posts on Excel 2007 user interface:

  1. Introduction
  2. The Home tab
  3. The Insert tab
  4. The Page Layout tab
  5. The Formulas tab
  6. The Data Tab
  7. The Review Tab
  8. The View Tab
  9. The Developer Tab

Applies to : Excel 2007

Filed Under: Customization, Excel 2007, General Tagged With: , ,
« Older Posts
Newer Posts »