The Analysis Toolpak is an Excel add-in program that is available when you install Microsoft Office or Excel. To use it in Excel, however, you need to load it first.
1. On the Tools menu, click Add-Ins.
2. In the Add-Ins available box, select the check box next to Analysis Toolpak, and then click OK.
Tip:
If Analysis Toolpak [...]
To change Excel default file location, follow these steps:
1. In the Tools menu click Options.
2. When you get the Options window, click the General tab.
3. Towards the bottom of the window there is a label called “Default file location“. To the write of this label is a text box. Enter here the full path of [...]
To change Excel default font name or size, follow these steps:
1. In the Tools menu click Options.
2. When you get the Options window, click the General tab.
3. Towards the bottom of the window there is a label called “Standard font“, and to the write of it are two combo boxes (drop down) for the font [...]
To view multiple worksheets at the same time follow these steps:
1. Open your workbook.
2. In the Window menu click New Window.
3. In the Window menu click Arrange and select an option (Tiled, horizontal .. etc). Now you will have two windows showing the same worksheet.
4. Click on any one of the two windows and select [...]
Do you really need to change the tab color of a worksheet?
Well, you may have a workbook with a considerable number of worksheets, and you may just want one or two of the worksheets to stand out from the crowd. Anyhow for any reason you may have here is how to do it:
1. Switch to [...]
To add a background to a worksheet follow these steps:
1. Switch to the worksheet where you want to add a background.
2. Click Format, point to sheet then click Background.
3. The Sheet Background window will open. Select your picture then click Insert.
4. The selected picture will be repeated as a background.
To remove the background:
1. Switch to [...]
The autofilter feature in Excel allows you to show a subset of your data based on a list of unique values derived by the auotfilter. You can also use this feature to hide rows of data based on certain conditions you specify. here is how you can do it.
1. Click Data –> Filter –> Autofilter.
2. [...]
When you open an Excel workbook, by default Excel provides three worksheets named sheet1, sheet2 and sheet3 respectively.
You can change this number to your needs as follows:
On the Tools menu click Options.
On the Options window click the General tab.
Next to [...]
When you click on Excel File menu you get a list of the most recently used workbooks.
By default Excel provides a list of four files in the recently used list of workbooks. However you can change this number to your needs as follows:
On the Tools menu click Options.
On the [...]
If you have a large Excel worksheet and find it difficult to navigate from one part of the worksheet to another, then you can use a feature in Excel called Custom Views to define parts of your worksheet as unique units.To create a custom view:
Select the worksheet area that you [...]
