Previously, we posted several shortcuts for selecting cells and navigating in Excel using mouse techniques. In continuation, here are some additional ways to select cells using keyboard shortcuts, along with very common keyboard shortcuts for formatting numerical data.

Vertical and Horizontal Cell Selection:

Bonus: How to Format Numerical Data Using Shortcuts:

** NOTE: It is important to observe that there should not be any blank rows or columns in a data table. Data should also be consolidated under single column headings. This method of structuring data tables is key for other tools & features to work properly in Excel, such as sorting, filtering and creating pivot tables.