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

Validating Number Entries in Excel 2007

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

Merging and Centering with a Toggle Button in Excel 2002 and Excel 2003

In Excel 2002 and Excel 2003: the Merge and Center icon works as a toggle button which means it turns this functionality on and off by clicking th...

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 Google PlusVisit Us On Youtube