Forum Discussion

Kassi Zaborowski's avatar
Kassi Zaborowski
Copper Contributor
Feb 22, 2018

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

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.

  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    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

Resources