excel question

[her34]

how do you deselect a row or column?


edit: i meant if you select a range of rows 1-20, and then wanted to deselect row 8. is this possible?

 

[Night201]

Click another cell.

 

[lozina]

you mean if you did a copy or cut? CTRL + D

 

[her34]

i meant if you select a range of rows 1-20, and then wanted to deselect row 8. is this possible?

 

[KLin]

Here's a workaround. click row 1, while holding down ctrl button. move mouse to row 7, release mouse and ctrl button, hold down ctrl button again and click row 9 and drag down to 20.

 

[Rage187]

nm

 

[her34]

Originally posted by: KLin
Here's a workaround. click row 1, while holding down ctrl button. move mouse to row 7, release mouse and ctrl button, hold down ctrl button again and click row 9 and drag down to 20.

yeah, i do that now but sometimes i need to deselect a few rows out of 50 or 80, which gets annoying. so it'd be easier if there was some way to deselect whichever rows you want.

 

[WW]

http://www.asap-utilities.com/

has a deselect cells utility....probably not exactly what you're looking for...