I want to be able to limit the where the cursor will go next. Is there a way
to press enter and move the cursor, instead of one cell over or under but, to
another location within the sheet without having to actually click on that
cell? For Example cursor is in cell C3, then when I hit enter it moves to
cell F15.
Hi Cisnerax
Protect the sheet, and only allow selection of unprotected cells. If only
cells C3 and F15 is unprotected, hitting Enter will move the cursor between
these two cells. Obviously, if more cells are unprotected, the cursor will
move between those cells as well.
hth
quot;Cisneraxquot; wrote:
gt; I want to be able to limit the where the cursor will go next. Is there a way
gt; to press enter and move the cursor, instead of one cell over or under but, to
gt; another location within the sheet without having to actually click on that
gt; cell? For Example cursor is in cell C3, then when I hit enter it moves to
gt; cell F15.
Thank you sooooo much that made all the difference
quot;Kassiequot; wrote:
gt; Hi Cisnerax
gt;
gt; Protect the sheet, and only allow selection of unprotected cells. If only
gt; cells C3 and F15 is unprotected, hitting Enter will move the cursor between
gt; these two cells. Obviously, if more cells are unprotected, the cursor will
gt; move between those cells as well.
gt; hth
gt;
gt; quot;Cisneraxquot; wrote:
gt;
gt; gt; I want to be able to limit the where the cursor will go next. Is there a way
gt; gt; to press enter and move the cursor, instead of one cell over or under but, to
gt; gt; another location within the sheet without having to actually click on that
gt; gt; cell? For Example cursor is in cell C3, then when I hit enter it moves to
gt; gt; cell F15.
:-)
quot;Cisneraxquot; wrote:
gt; Thank you sooooo much that made all the difference
gt;
gt; quot;Kassiequot; wrote:
gt;
gt; gt; Hi Cisnerax
gt; gt;
gt; gt; Protect the sheet, and only allow selection of unprotected cells. If only
gt; gt; cells C3 and F15 is unprotected, hitting Enter will move the cursor between
gt; gt; these two cells. Obviously, if more cells are unprotected, the cursor will
gt; gt; move between those cells as well.
gt; gt; hth
gt; gt;
gt; gt; quot;Cisneraxquot; wrote:
gt; gt;
gt; gt; gt; I want to be able to limit the where the cursor will go next. Is there a way
gt; gt; gt; to press enter and move the cursor, instead of one cell over or under but, to
gt; gt; gt; another location within the sheet without having to actually click on that
gt; gt; gt; cell? For Example cursor is in cell C3, then when I hit enter it moves to
gt; gt; gt; cell F15.
- Sep 29 Fri 2006 20:09
Hitting Enter to Move Cursor to the Next Entry Cell
close
全站熱搜
留言列表
發表留言