can i restrict data entry from certain columns

DNA

Posts: n/a

Select the cells you do not want to have data entered, lock those cells and
unlock all others. Protect the worksheet but make sure
uncheck "Select locked cells" under the option "Allow users of this
worksheet to"

HTH

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using Excel's XML mapping/export with data organized in columns	DaveWhatmuff	Excel Worksheet Functions	0	June 16th 05 06:53 PM
How to take matching data from 2 columns and put in the same row?	JustinM	New Users to Excel	1	May 27th 05 12:32 AM
How do you create a selection box for data entry within excel	Ligia Magnus	Excel Discussion (Misc queries)	1	May 25th 05 08:10 PM
Comparing data in two columns and highlighting the data	David Kinsley	Excel Worksheet Functions	6	January 4th 05 06:01 PM
Filtering Text Data from Multiple columns	Brad	Excel Worksheet Functions	6	January 1st 05 03:32 PM

All times are GMT +1. The time now is 02:17 AM.

Menu

About Us