Suppose you have a dataset having Empty Cells.
#Excel shortcut keys select all data how to#
Here I will show you how to Select Edge Cells with Empty Cells. Select Edge Cell Using Keyboard Having Empty Cells Read More: Data clean-up techniques in Excel: Filling blank cells To move left Edge of the dataset: Press CTRL + Left Arrow.For selecting Up Edge of the dataset: Press CTRL + Up Arrow.To move Right Edge of the dataset: Press CTRL + Right Arrow.To move Down Edge of the dataset: Press CTRL + Down Arrow.I will show you to navigate the Edges in a cyclic manner. Following Shortcuts will help you to do so. Suppose you are at Cell B5 initially & you want to navigate Edges of your dataset having No Empty Cells. In this method, we will discuss how to Select Edge Cells without Empty Cells. Using Keyboard Shortcuts to Select Edge Cells Having No Empty Cell Read More: How to Select Multiple Cells in Excel without Mouse (9 Easy Methods) Following the above Shortcut will take you to one Cell Left.To move one Cell Left Press Left Arrow or press SHIFT + TAB. Suppose you are at Cell C7 & now you want to Select Cell B7.Here, I will try to move the selection one Cell Left by using the keyboard shortcut. Following the above Shortcut will take you to one Cell Right.To move one Cell Right Press Right Arrow or press TAB. Suppose you are at Cell C7 & now you want to Select Cell D7.In this section, I will demonstrate how to move the selection one Cell Down by using the keyboard shortcut. Following the above Shortcut will take you to one Cell Down.To move one Cell Down Press Down Arrow or press ENTER. Suppose you are at cell C5 you want to move one Cell down or in Cell C8.Now, I will try to move the selection one Cell Down by using keyboard shortcut. Following the above Shortcut will take you to one Cell Up.To move one Cell Up Press Up Arrow or press SHIFT + ENTER. Suppose you are at Cell C7 & now you want to Select Cell C6.Here, I will try to move the selection one Cell up by using keyboard shortcut. In this method I will show you How to Select Adjacent Cells Using Keyboard. 9 Ways to Select Cells in Excel Using Keyboard Method 1.