Therefore, it's probably best to get used to using Tab to get there since it works in all situations. Down Arrow opens that menu and selects each item. There is an additional drop-down menu to search by Year, Month, Date. However, if the column contains dates then you need to press Tab twice. Down Arrow will probably be easier since you just pressed Down Arrow to open the filter menu. You can use either the Down Arrow or Tab keys. So the full keyboard shortcut is: Alt+Down Arrow, E, Tab (or Down Arrow) If you want to jump down to the checkbox list below the Search box, you can just press Tab after Alt+Down Arrow, E. What a time saver! Bonus – Jump to the Checkbox List Now I can do the same thing in one step by pressing the letter “E”. This required me to press the down arrow key 7 times to get to the search box. Prior to learning this I was using the down arrow key to get to the search box. I just learned this shortcut and it is my new favorite because it makes it so fast to type and filter exactly what you are looking for in the list. This places the cursor in the search box and you can begin typing your search.Īlt+Down+Arrow+E is the shortcut to open the filter drop down menu and jump directly to the search box. Note this trick actually deletes blank rows below the data as well, so be sure you don't have important information below the data.When the filter drop down menu is open, you can press the letter “E” on the keyboard to jump to the search box. Now if I move to the bottom of the data, you can see that we just have about 33000 rows remaining. When I click OK, all blank rows are completely removed. Now use Control minus to delete, and choose Entire row. Then Special, then select Blanks.Īt this point, every blank cell in column A is selected. Then select the column, and use Ctrl + G for Go To. In this case, Column A should always have a name. First, pick a column that should always contain data. To quickly remove these blank rows, I can use Go To Special. If I move to the last cell, you can see that there's over 36,000 rows of data, and, looking at the count, just over 33,000 rows actually contain data, which means over 3000 rows are blank. In this first example, we have a big set of data that contains a lot of blank rows. In this video, we'll look at a shortcut recipe that lets you easily remove hundreds or thousands of blank rows in a worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |