#1   Report Post  
The Twister 61
 
Posts: n/a
Default Cell entry

How do I restrict entry to only certain cells and have the cursor move only
to those cells?
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

You can protect the rest of the cells, if you select the cells in question
(hold down ctrl and click them), then do formatcellsprotection, uncheck
locked, then protect the sheet

--

Regards,

Peo Sjoblom


"The Twister 61" <The Twister wrote in message
...
How do I restrict entry to only certain cells and have the cursor move

only
to those cells?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
stop cell entry being copied to other cell Terrible Tom Excel Worksheet Functions 1 March 2nd 05 09:26 PM
resolving a numeric cell entry for its meaning vtcrob Excel Worksheet Functions 0 February 4th 05 02:23 AM
Move the last entry in a column to a different cell, when the loc. MicroSoft Excell (?) Excel Worksheet Functions 2 January 7th 05 09:29 PM
how do i set up a single cell continual entry in excel to total f. mike@swallow Excel Discussion (Misc queries) 1 December 7th 04 12:29 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 05:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"