ms excel 2007 quesition

[1HandInMyPocket]

I want to highlight a large number of cells for deletion, copying etc..... How do I do that? I mean if it was just a few cells, I would hold down on the left button and move the mouse to highlight the applicable cells. But there must be some sort of short cut for a large number of cells.

Thanks in advance
1Hand

 

[Moraff]

Hold down the shift and use page down and tab?

 

[1HandInMyPocket]

I've tried the pg up/down with and without the shift key but doesnt work for me

edit -> okay I highlight a small portion (and let go of the left mouse button), then I held down the shift key and used the pg up/down and arrow keys to adjust my highlighted area.

Thanks

ps but is there away where I can type in the area I want where even using the pg up/down button would be too tedious.

 

[OddSox]

To select sequential cells, click the first cell, hold down the Shift key, and click the last cell you want.

http://www.dummies.com/how-to/content/selecting-cells-in-excel-2007.html

 

[JohnLarue]

Better yet, click the first cell, hold down the shift key, select the end key and then select the down arrow. All sequential cells with data, formulas in the column will be will be highlighted

 

[1HandInMyPocket]

To select sequential cells, click the first cell, hold down the Shift key, and click the last cell you want.

thanks OddSox.

 

[Celticman]

I've tried the pg up/down with and without the shift key but doesnt work for me

Hold down shift button AND at same time arrow down....or page down for one page at a time.

If you know that you want to delete to the very end of the range, highlight first cell (for content of column) or row for entire row (all cells), then CTRL + SHIFT + END. I am a s/w developer, and can tell you that this works, so if not immediately apparent, reflect and try again.