How to select column in Excel, but exclude the first cell (which is my header)

[Kassi Zaborowski]

I need to be able to copy and paste columns, but I don't want to include the very first cell because it is my header. I want to be able to highlight the entire column by hovering at the top.

[#2]

Hi Kassi

I'm not sure you can do what you are asking (the other experts here might have a better idea).

The way I'd do it is to click onto the cell under the header, press Shift and PgDn to select the cells you want in the column. Then copy and paste wherever you want it to go.

Let us know how you go?

Cheers
Damien