How to change Excel 2007 default font

To change Excel 2007 default font, follow these steps:

  1. Click the  Microsoft Office Button.XL7OffButton
  2. Click Excel Options (at the bottom right of the menu).
  3. XL7Font2

  4. Excel Options window will open.
  5. XL7Font1

  6. In Excel Options window (left side) click Popular.
  7. Under When creating new workbooks (see the red rectangle in the image above) , specify the required font face and font size.

How to install and load the Analysis Toolpak in Excel 2007

To install and load the Analysis Toolpak in Excel 2007 follow these steps:

  1. Click the Office button. XL7OffButton
  2. Click Excel Options, the Excel Options window will open.
  3. XL7Addin1

  4. In the left pane of Excel Options click Add-Ins, The right pane will show a list of Active and Inactive  Add-ins.
  5. At the bottom of the right pane there is a combo box (drop-down) labeled Manage. Select Excel Add-Ins from the drop-down then click GO. The Add-Ins window will open.
  6. XL7Addin2

  7. In the Add-Ins window select the check box that says: Analysis ToolPak, then click OK.

How to change Excel 2007 default file location

To change Excel 2007 default file location, follow these steps:

1. Click the  Microsoft Office Button.

2. Click Excel Options.

3. In Excel Options window (left side) click Save.

4. In the text box labeled Default File Location , specify the path for the required location.

XL7Save

How to freeze the top row in Excel 2007

If you have a worksheet with a heading row at the top, then you may want to freeze the heading row while scrolling throw the data rows below it. To achieve that follow these simple steps.

1. In the View tab, Window group click Freeze Panes.

xl7panes1

2. From the drop down list select Freeze Top Row.

xl7panes2

3. A dark line will show below the header row indicating where the freeze is established. The row above the line is frozen, and the rows below the line are scrollable.

xl7panes3

How to freeze panes in Excel 2007

If you have a large worksheet, then you may want to freeze the worksheet at one point while scrolling throw the rest of the rows below it. To achieve that follow these steps.

1. Select the top row of the area which you want to be scrollable (or just a cell in that row). I.e. all rows including and below the selected row will be scrollable, all rows above the selected row will be frozen.

2. In the View tab, Window group click Freeze Panes.

xl7panes1

3. From the drop down list select Freeze panes.

xl7panes4

4. A dark line will show above the selected row indicating where the freeze is established. The rows above the line are frozen, and the rows below the line are scrollable.

xl7panes5

How to insert background image in Excel 2007

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.

How to create a custom cell style in Excel 2007

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.

How to show help button in Excel 2007

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.

How to show the developer tab in excel 2007

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.

Excel 2007 User interface – Developer Tab

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