You are here: Home / Archives for May 2009

How to insert background image in Excel 2007

May 30, 2009 By admin Leave a Comment

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: Customization, Excel 2007, Excel help, Formatting

How to generate a random number within a given range

May 24, 2009 By admin Leave a Comment

To generate a random number within a given range use the RANDBETWEEN function.

Syntax

RANDBETWEEN(bottom,top)

Bottom: is the smallest integer RANDBETWEEN will return.

Top: is the largest integer RANDBETWEEN will return.

Examples:

RANDBETWEEN (1,100) will generate numbers from 1 to 100

RANDBETWEEN (-15,2000) will generate numbers from -15 1 to 2000

Notes:

1. A new random integer number is returned every time the worksheet is calculated.

2. In Excel 2007 you can use RANDBETWEEN function directly, however in Excel 2003 (and may be earlier versions also) the function is part of the Analysis ToolPak add-in. If it is not available in your list of functions then you have to install the Analysis ToolPak. Check the following link for more help:

install and load the Analysis ToolPak add-in in Excel 2003

Filed Under: Excel 2007, Functions Tagged With: Excel 2007, Excel Functions, Excel help

Conditional formatting with multiple rules in Excel 2007

May 22, 2009 By admin 2 Comments

I have two previous posts on Excel 2007 conditional formatting: One based on cell’s own value and the second based on value of another cell. This post will cover conditional formatting with multiple rules or conditions.

Suppose you have a cell formatted with this rule:

If cell value is less than zero format with Light Red Fill …. Etc.

xl7cfrule1

Now you want to add another rule:

If cell value is greater than 100 format with green Fill.

Follow these steps:

1. In the Home Tab, Styles group click Conditional Formatting, then Manage Rules.

xl7cfrule2

2. The window Conditional Formatting Rules Manager will open, and it will show the current rule.

xl7cfrule3

3. Click the New Rule button. The New Formatting Rule window will open (not shown here).

4. Add the new rule. If you need help refer to the other two posts I mentioned earlier.

5. After finishing, your list of rules will look like this:

xl7cfrule4

Note:

You can apply the same steps if you have conditional formatting based on the value of another cell.

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

How to create a custom cell style in Excel 2007

May 19, 2009 By admin Leave a Comment

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: Customization, Excel 2007, Excel help, Formatting

How to show help button in Excel 2007

May 15, 2009 By admin Leave a Comment

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: Customization, Excel 2007, Excel help

How to show the developer tab in excel 2007

May 10, 2009 By admin 2 Comments

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: Customization, Excel 2007, Excel help

Excel 2007 User interface – Developer Tab

May 10, 2009 By admin 3 Comments

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: Customization, Excel 2007, Excel help

How to change page orientation in Excel 2007

May 3, 2009 By admin Leave a Comment

To change page orientation in Excel 2007 :

1. Switch to the Page Layout tab.

2. In the Page Setup group click Orientation.

xl7orient

3. Select the required orientation (Portrait or Landscape) from the options shown.

4. You can click Office Button –> Print –> Print Preview to verify your selection.

Filed Under: Excel 2007, Printing Tagged With: Excel 2007, Excel help, Printing

Repeat column titles (heading rows) in every page in Excel 2007

May 3, 2009 By admin Leave a Comment

To repeat column titles (heading rows) in every page in Excel 2007 follow these steps:

1. Switch to the Page Layout tab.

2. In the Page Setup group click Print Titles.

xl7psetup1

3. The Page Setup window will open with the Sheet tab selected.

xl7psetup2

4. In the Sheet tab click the text box titled: Rows to repeat at top

5. Now go to your worksheet and select the row(s) which have the headings. The selected row(s) will be reflected in the text box in the Page Setup window.

You can also type the address(es) of the row(s) directly in the text box if you prefer.

6. Click the Office Button –> Print –> Print Preview to verify that the heading row(s) will be repeated on every page.

Filed Under: Excel 2007, Printing Tagged With: Excel 2007, Excel help, Printing