![]() Click Formula > Define Name, see screenshot:Ģ. If the list contains blank cells, with the shortcut cannot solve the selecting, now you can define a name for the column that you can select it except the first row in Excel.ġ. Note: If there are blank cells in your list, it will select the list until the first blank cell appears with this method. Select the header or the first row of your list and press Shift + Ctrl + ↓(the drop down button), then the list has been selected except the first row. If your list does not contain any blank cells, you can use the shortcut to select entire column but the first row. ![]() Select entire column (including or excluding blank cells) except header with Kutools for Excel Select entire column (including blank cells) except header with VBA Select entire column (including blank cells) except header with define name Select entire column (excluding blank cells) except header with shortcut Here I have some tricks for you to quickly select the entire column except header or the first row in Excel. If you have a long list with a header in your worksheet, and you want to select the entire column but the header, you can select them by dragging mouse, but this method is too troublesome when the list is very long. How to select entire column except header/first row in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |