answersLogoWhite

0

If you want to validate cells in a column, such that they only let in certain value, you select all the cells and go to the Data tab and pick Data Validation. From there you can do a range of validation settings, such as limiting a value to a highest and/or lowest value. You can also set messages to tell the user what they can enter and give errors if they do not follow the set validation rules.

User Avatar

Wiki User

8y ago

What else can I help you with?

Related Questions

What is short key to hide a row or column in MS Excel?

The short key to hide a row in MS Excel is Ctrl key and the number nine. The short key to hide a column is Ctrl key and the number zero. You first need to click on a cell in the column or row that you want to hide.


Is there a way to highlight a column if you have swim lanes?

The author of this question categorised it in Microsoft Excel. I am not aware of anything called "swim lanes" related to MS Excel. However, you can highlight a column by clicking on the column heading (the letter of the column at the top of the screen).


What is the meaning of S24 in MS Excel?

S24 could refer to the cell in column S, row 24.


MS Excel and MS Office?

MS excel is a part of MS Office suite. You can create spreadsheet with the help of MS excel.


Why is MS Excel is called Excel?

MS-Excel is a powerful worksheet & you calculate , syncronize many hard calculation, so MS-Excel is called Excel.


How many coulms are there in Microsoft Excel?

the column in Ms excel are 16,384 and 1048,576 rows and 17,179,869 cell in one spread sheet. The spread sheet ends with the letter XFD.


What is the meaning of ms Excel 2010?

ms excel 2010


Where is MS Excel?

MS Excel is under Microsoft Office


How many cells in ms-Excel?

16,777,216 in versions up to MS Excel 2003. From MS Excel 2007 onwards is 17,179,869,184.


Why MS-Excel is used?

ms excel is used to create spreadsheets.


Where is the Excel located on the computer?

Program - MS Office - MS Excel


How do you form a primary key column in Microsoft Excel?

Just type your data into the column. Excel is not really a database program, but you can create a flat database file and some elementary relations between worksheets. A better tool for a database would be MS Access.