Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto shift down a cell
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto shift down a cell
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 "peekster" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto shift down a cell
It can't be done if the user hasn't hit enter, however naturally when a user hits enter the cursor usually moves down one row, if you only want to allow a 4 digit number then use DATAVALIDATIONTEXT LENGTHEQUAL TO4 -- The Code Cage Team Regards, The Code Cage Team 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=37890 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I shift curser within specific cell? | Excel Discussion (Misc queries) | |||
insert cell content and shift cells down | Excel Worksheet Functions | |||
Auto Shift | Excel Discussion (Misc queries) | |||
Shift cursor to the cell on the right | Excel Worksheet Functions | |||
Cell Shift | Excel Worksheet Functions |