highlight the whole table - some columns which has empty rows

[lezawang]

Hi
I have big sheet. every 40-50 rows there are 1 or 2 empty rows. I want to highlight the whole sheet (not the whole sheet, i mean my table area only, and i do not want to include some columns that is why I do not want to highlight the whole sheet) So I used CTRL+SHIFT + down arrow. It will highlight the 50 rows but then stop because of the empty row. Then I have to continue doing Ctrl+shift+ down arrow. Is there a better way? Thank you

 

[sheetspread]

From A1 (or the top left corner of the range you want) ctrl-shift-end. You can then hold down the shift key and unselect columns with the left arrow.

 

[lezawang]

Thank you so much but accidentally the first column is the one I do not want!

 

[sheetspread]

So start with the column you do want, or are you trying to skip ones in between?