To insert a background image in Excel 2007 follow these steps:
1. Click on the Page Layout tab.
2. In the Page Setup group click Background. The Sheet Background window will open.
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 [...]
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 [...]
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 [...]
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 [...]
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.
3. The Excel Options window will open.
4. On the left pane of the Excel Options window click Customize.
5. Click on the [...]
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.
2. Click Excel Options, The options window will open.
3. Click Popular.
4. Select the Show Developer tab in the Ribbon check box.
Developer Tab
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
The Code group gives you access to the visual basic editor. You can access your [...]
To change page orientation in Excel 2007 :
1. Switch to the Page Layout tab.
2. In the Page Setup group click Orientation.
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.
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.
3. The Page Setup window will open with the Sheet tab selected.
4. In the Sheet tab click the text box titled: Rows to repeat at top
5. Now go to your worksheet and [...]
