auto shift down a cell

  • Thread starter Thread starter peekster
  • Start date Start date
P

peekster

Is it possible to automatically shift down a cell with no key stroke after
entering 4 digits into a cell. And if so can all the cells be formatted to do
this. Thanks
 
No.

What you can do is set data validation to allow only 4 characters in a cell

Data|Validation then set it to Number of max value 9999 or text length 4
characters.

To move down after enter try

Tools|Options|Edit check move selection after enter and select 'down' from
the dropdown.

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

auto shift down a cell after entering data 1
Excel Staff Grade and Shift 0
Multiple arguments 1
Learning arrays. 13
? enter a static time (Excel) in a cell using the IF function 2
How can I move to the first cell in the selection in Excel 07? 7
using the =page! feature to transpose a row to column 0
Shift lists 1

Back
Top