View original (French)

Select a column without header

albert40 Posted messages 56 Status Member -  
albert40 Posted messages 56 Status Member -
Hello,

I am using Excel 2007 and I would like to know how to "unset" the selection of certain items within a selection of cells that I have already made.
For example: I have selected column C, and I want to remove C1 (the header) from this selection.
Thank you and have a nice day

Configuration: Windows XP / Safari 535.7

3 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello everyone,

    If you don't have a gap in your column, you can select C2, then press Shift+Ctrl+End simultaneously.
    This will select all the filled cells starting from C2.

    eric
    1