Transposing Cells in Excel 2007

Transpose is the function that we can use to convert the horizontal range into vertical range and vertical range into horizontal range in Microsoft Ex...

Preventing Duplicates While Entering Data in Excel

In Microsoft Excel we can use data validation to prevent duplicity as & when we enter data. This article will help you stop duplicates appearing i...

Quickly Entering Text into Cells from a List of Previous Entries or a Validation List in Excel 2007

To select from a list of previous text entries or from a Validation list: 1. Select a cell in a list or a blank cell under the last filled cell. 2...

To Fill Values Right or Down in a List in Excel

In this article, we will learn how to fill values in right of cell or down of cell. In Microsoft Excel, to fill the same content of cell in the rig...

Filling a Range with a Series of Dates in Excel 2007

In this article, we will learn how to fill a range with a series of dates in Microsoft Excel by using the Auto fill option. We can fill the range with...

Validating Date Entries in Excel 2007

To validate date entries: 1. Select a range of cells containing dates to validate. 2. Select Data -> Data Validation (in Data Tools Group) ->...

Validating Text Entries in Excel 2007

To validate text entries: 1. Select a range of cells. 2. Select Data -> Data Validation (in Data Tools Group). 3. Select Settings -> Allow ...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube