Select Contiguous Cells

K

keyt

I know there is a keyboard shorcut to select contiguous
cells, but darned if I can remember it.

Anyone?
 
G

George King

Example:
Selecting all the cells from a5 through a1000, assuming
there is something in every cell:
Start with the cell pointer in a5,
Hold down Shift, press End and DownArrow.
 

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

Copy .Areas.Item(1,2,3,4,5, etc.) to a column or a row 5
selecting non-contiguous cells 1
Copying puzzle 2
COUNTIF Non Contiguous Cells Q 3
using slope function with non contiguous cells 1
If formula producing #VALUE Error 2
Looping through Non contiguous cells in a row 11
Function to concatenate cells in a range 2

Top