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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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) = [...]
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 [...]
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 [...]
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 [...]
Select the cells for which you want to clear the conditional formatting.
On the Format menu, click Conditional Formatting.
The Conditional Formatting dialogue will open, and the applied conditions will be listed.
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 [...]
