To install and load the Analysis Toolpak in Excel 2007 follow these steps:
Click the Office button.
Click Excel Options, the Excel Options window will open.
In the left pane of Excel Options click Add-Ins, The right pane will show a list of Active and Inactive Add-ins.
At the bottom of the right pane there is a combo [...]
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.
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.
2. From the drop down list select Freeze Top Row.
3. A dark line will [...]
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 [...]
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 [...]
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 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.
This is how your tabs will look like:
