026. How to Select all Data In EXCEL Shortcut - FORGET Control + Shift + Dow (2/2)

Описание: Most of you use CONTROL Shift Down as a shortcut to select all data in Excel but this can be pretty annoying when you have blank cells in your range as you have to keep pressing on the "⯆" key.

In this second lesson, I will teach a different way to select your dataset. This is different than the traditional way of "Control" + "Shift" + Arrow down and also different from what we saw in the previous lesson. In this scenario, you will convert your data into an Excel Table and then it will be very easy to select all of it!

Link to previous lesson:    • 025. How to Select all Data In EXCEL Short...  

Content: shortcut to select data column including blanks, excel keyboard shortcuts to select column with blank cells, excel select column with blank, control shift down, excel last cell, excel control end, excel select all data in column shortcut, excel keyboard shortcut select all data in column, how to select all data in excel shortcut, excel shortcut to highlight all data in a column, shortcut to select data when you have blank cells, how to select data when you have blanks in between

#Excel #MsExcel #Shortcuts