View original (French)

Select a column without header

albert40 Posted messages 56 Status Membre -  
albert40 Posted messages 56 Status Membre -
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 réponses

Réponse 1 / 3
eriiic Posted messages 24581 Registration date   Status Contributeur 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