Selecting a Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

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

Average problem 1
Macro Range Selection 3
SUMIF of specified cells in a range 7
Return portion of Formula? 2
Filtering without filtering 4
selecting a range 2
Excel Vertical to horizontal repeat after 16 rows 3
Interesting Median observation 8

Back
Top