software

Starting in cell A2 I have selected a range that continues to cell A16.
Then, I have realized I meant to include cell A1 as well. Since I started in
A2 if I attempt to extend the range I will go to A17. Without deselecting
the already selected range of A2:A16 how do I change the position of the
cursor to include A1. Thank you.

Hold down the CTRL key and click in A1. This also allows you to select
non-adjacent cells - a handy thing if you want to format a bunch of cells
all at once.quot;SJTquot; gt; wrote in message
news
gt; Starting in cell A2 I have selected a range that continues to cell A16.
gt; Then, I have realized I meant to include cell A1 as well. Since I started
gt; in
gt; A2 if I attempt to extend the range I will go to A17. Without deselecting
gt; the already selected range of A2:A16 how do I change the position of the
gt; cursor to include A1. Thank you.
From my experience, you don't. You just need to re-select.
If you are doing this to record a Macro, just complete it and go back and
edit the selection once you finish. If that's not an option, Good luck. Never
been in a sitation where a selection couldn't be re-done.

quot;SJTquot; wrote:

gt; Starting in cell A2 I have selected a range that continues to cell A16.
gt; Then, I have realized I meant to include cell A1 as well. Since I started in
gt; A2 if I attempt to extend the range I will go to A17. Without deselecting
gt; the already selected range of A2:A16 how do I change the position of the
gt; cursor to include A1. Thank you.