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 [...]
If you want to copy data from Excel to Microsoft word then follow these steps:
In Excel
Select the worksheet data (range) that you want to copy to a Word document.
On the Home tab, Clipboard group, click
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.
To save an Excel 2007 workbook to Excel 97-2003 format follow these simple steps:
1. In Excel 2007, open the workbook that you want to save in Excel 97-2003 format.
2. Click the Microsoft Office Button and point to the arrow next to Save As.
3. Under Save a copy of the document, click Excel 97-2003 Workbook.
The file will be [...]
To find cells that meet a specific criteria, for example cells with conditional formatting or cells which have data validation, proceed as follows:
In the Home tab Editing group click Find and Select.
Click on:
Formulas : to find cells that contain formulas.
Comments : to find cells that contain comments.
Conditional Formatting : to find cells that have [...]
All commands (icons) that deal with comments are found in the Review tab, Comments group.
To insert a new comment:
1. Select the cell where you want to insert the comment.
2. Click New Comment.
3. A new comment will be created. Type the required text then click outside the comment box.
4. The comment box will disappear but a small indicator will show [...]
To print comments in Excel 2007:
1. Show all comments or just the comments you want to print. How?
2. In the Page Layout tab, Page Setup group, click the dialog box launcher (see the mouse pointer in the image below).
3. The Page Setup window will open.
4. Click on the Sheet tab.
5. In the Comments box, select As displayed on sheet or [...]
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 [...]
You can now convert Excel 2007 files directly to PDF format without the need for a third party software. However to be able to do that you need to download and install Microsoft Office “Save as PDF” Add-in (SaveAsPDF.exe) from Microsoft web site.
Check SaveAsPDF.EXE download page Here.
After the add-in is installed:
1. Click the Office [...]
