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 |