Excel Digest

  Excel help for the rest of us

Archive for April, 2008

28 Apr

How to protect a workbook with a password

To allow only authorized users to view or modify your Excel workbook, you can secure your entire workbook file with a password. Follow the steps below to achieve this goal:

On the File menu, click Save As.
Click Tools.
On the Tools menu, click General Options.

If you want [...]

24 Apr

Autofill, formulas and cells references

In a previous post I explained How to use Autofill with formulas.Today I will cover the same subject but from a different perspective.
Suppose you have a list of values in a certain currency and you want to convert those values to another currency based on a given currency rate. If we follow the same [...]

20 Apr

How to use Autofill with formulas

The Autofill feature of Excel can be applied on formulas as well as predefined lists. Let us take a simple example:
Suppose you have two columns of Quantity and Price and you want to derive a third column of Value by multiplying the quantity by the Price, then you:

Enter the formula [...]

18 Apr

How to apply a cell format to other cells

1. Select the cell which you have already formatted.
2. Click Format Painter in the standard toolbar.
3. Click the cell on which you want to apply the format. The format of the first cell will be applied to the new [...]

16 Apr

How to Repeat Heading Row(s) on Every Page

If you have one or more heading rows in your worksheet and you want to print that worksheet then the heading row(s) will be printed on the first page only (default).
To print the heading row(s) on every page do the following:

Click File then click Page Setup .The Page Setup [...]

13 Apr

Function to decide whether a year is a leap year or not

The following Visual Basic code is for a function to determine whether a certain year is leap year or not. It will receive the year as an argument and return TRUE for a leap year and FALSE for others.Copy this code and paste it in a new visual basic module.

Function IsLeap(iYear)
If (iYear Mod 400) = [...]

12 Apr

How to create a user-defined function

If you know Visual Basic programming then you can create your own user-defined functions in Excel. Follow the steps below:
1. On the Tools menu select Macro.
2. On the Macro submenu select Visual Basic Editor.

3. You will be switched to Visual [...]

12 Apr

How to create a custom toolbar

Click Tools then click Customize .The Customize window will open.
Click the Toolbars tab.

Click New. The New Toolbar window will open.

Enter a name for your toolbar then press OK. This will [...]

10 Apr

How to print part of a worksheet

If you have a worksheet and you only want to print part of that worksheet then follow the steps below:
Method 1

Click File then click Page Setup .The Page Setup window will open.
Click the Sheet tab.

In [...]

10 Apr

How to format a cell based on its value (conditional formatting)

Select the cells for which you want to add conditional formatting.
On the Format menu, click Conditional Formatting.
The Conditional Formatting dialogue will open.

In the first combo box Click Cell Value Is.
In the combo box next to it select the comparison phrase e.g. less than.
Next enter a constant value (0 in this example).
Click the format button, the [...]

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

GPS Reviews and news from GPS Gazettewordpress logo