Highlight large range

[Orangeanorak]

I have large ranges which I need to cut and paste. It takes ages highlighting the cells in the range using the mouse.

Grateful if you can advise me of a short cut that will highlight a large range - say for example A1:Z1000 so that I can cut and paste it.

Thank you

 

[Orangeanorak]

Found it --- Control+Shift+8

 

[grd]

Name the range Using Formulas > Name Manager. Then, to select, click anywhere within the range and click on the name box top left of the working area and select the given name.

 

[grd]

Assuming your range has data in every cell, you might mean Ctrl+Shift+up or down arrow when starting from the bottom or top cells respectively.

 

[mas123]

I think CTRL+A select all cells in current area
and for 2nd time select all cells in the sheet

 

[grd]

I think CTRL+A select all cells in current area
and for 2nd time select all cells in the sheet

That's a good one. I've only ever used Ctrl+A for selecting everything. Didn't realise it has two stages if you are within a data range.

 

[barry houdini]

.....Grateful if you can advise me of a short cut that will highlight a large range - say for example A1:Z1000

One way is to simply type the range in to the box above cell A1, e.g. just type A1:Z1000

Now press ENTER and that range is selected