Excel Digest

  Excel help for the rest of us

Archive for the 'Customization' Category

21 Oct

How to install and load the Analysis Toolpak

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 [...]

18 Oct

How to change Excel default file location

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 [...]

14 Oct

How to change Excel default font

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 [...]

28 Sep

How to view multiple worksheets at the same time

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 [...]

20 Aug

How to change worksheet tab color

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 [...]

17 Aug

How to set a background for a worksheet

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 [...]

21 Jul

How to hide rows based on a cell value

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. [...]

08 Jun

Change the number of the default worksheets

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 [...]

02 Jun

Change the number of the recently used workbooks

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 [...]

01 Jun

How to create, display and delete custom views

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 [...]

© 2008 Excel Digest | Entries (RSS) and Comments (RSS)

GPS Reviews and news from GPS Gazettewordpress logo