close

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.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()