Then select the name you have defined in above step from the Name Box, you can see the entire column but the first row has been selected.Īlso, besides the Define Name function, you can use VBA to select entire column but first row.ġ. In the Define Name dialog, specify a name you like, and select Workbook in the Scope list and then type =$A$2:$A$1048576 (A is the column you want to select, in Excel 2003, you can change $A$1048576 to $A$65536) into the Refers to text box. 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
:max_bytes(150000):strip_icc()/ExcelSelectTable-5bdf319ec9e77c0051182080.jpg "how to highlight entire row in excel keyboard 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 HIGHLIGHT ENTIRE ROW IN EXCEL KEYBOARD SHORTCUT HOW TO#
How to select entire column except header/first row in Excel?
0 kommentar(er)
