To select noncontiguous ranges with the keyboard in Excel, hold down the Ctrl key while selecting the individual ranges you want to select. For example, if you wanted to select cells A1:A5, C1:C5, and E1:E5, you would hold down the Ctrl key and click on each of those ranges individually. Once all the ranges are selected, you can release the Ctrl key and all of the selected ranges will be highlighted.
If you want to select an entire column or row that is not next to each other, you can use the Shift key instead of the Ctrl key. For example, if you wanted to select columns A through D, you would hold down the Shift key and click on column A, then column D. All of the columns in between those two will be selected as well.
Note: