• Highlight Selected Row Excel
• Excel Select Entire Column Shortcut Key
• Highlight Entire Column Shortcut

Here is my solution (only tested in Excel 2013): I tried clicking on the column descriptor to select the whole column and then CTRL-click those cells I don't want to include in my selection, but it didn't work as expected. After clicking on the column descriptor and highlighting the entire column, hold down Shift and then press Tab, ↓, ↓. The easiest way is to select the cell in row 6, then press Ctrl+Shift+Down which will select the entire column except the first five cells. It takes you to the bottom, but all the cells you want are selected, so then do your right-click on the selection and choose format cells. There's no need to go to the bottom first.

Working with a complete data set is a common task in Excel. You might want to move the data, apply a filter or common format, or convert the data to a table. There are many reasons for selecting a data range, but doing so might require jumping through a few selection hoops, especially if you're working with a large range that spans several screens. Fortunately, there's a quick and easy way to select an entire data range.To select a data range, use the Go To feature as follows:.

Click any cell in the data range. For instance, to select the data range A1:C9 (shown below) you could select any cell from A1 to C9. Press F5. In the Go To dialog, click the Special button in the bottom-left corner. In the resulting dialog, click the Current Region option.

Highlight Selected Row Excel

Excel Select Entire Column Shortcut Key

Click OK, and Excel will select the current data range (the current region). In this context, current region means contiguous data, but the block of contiguous data can contain blanks. For instance, using the above data range, if there's data in cell D10 and E7, this feature will include columns D and E and row 10 in the selection.

Highlight Entire Column Shortcut

Blank cells in the data range won't matter.This feature makes selecting a data range easy, but there's a keyboard shortcut that will do the same thing: Ctrl+Shift+8. If you do this often, it's worth committing that keyboard shortcut to memory.