Ctrl+Shift+Space
If you don’t want to select an entire row or column but instead the complete dataset, then you can simply highlight any cell within the data range and press Ctrl, Shift and Spacebar at the same time. This will highlight the entire data range, but it requires the data to be in good shape without any empty cells, rows, or columns in between.
Shift+Arrow Keys or F8
Selecting data might be harder when using a mouse or trackpad. But When you press Shift and the desired Arrow key, you can select data in the direction. This selection mode can also be toggled by pressing F8 for once and pressing the required arrow keys to select the range.
Ctrl+Shift+Arrow Keys
As mentioned above in navigation, you can select up to the last range in a data set using the Ctrl+Shift+Arrow keys. For example, highlight the first cell in the data range and press Ctrl+Shift+Right arrow to select up to the last data to the right side of the table or data range.
Data Entry and manipulation
F2
Pressing F2 after highlighting the cell will allow you to Edit cell content without deleting existing content. This will come to handy when editing formulas. Keep in mind when in editing mode, you cannot use arrow keys to highlight ranges for your formulas. Press F2 again to use arrow keys to select ranges while entering formulas.
Alt+Enter
When you’re typing heading and text, you might have wanted to have a new line. But when you press enter, it would go to the next cell. Instead, press Alt and Enter this will add a new line to the text within the cell.
Ctrl+R
When your performing data entry, this Microsoft Excel shortcut will simply speed up the process in many cases. Highlight a cell and select the adjacent cells to the right of the cell you wish to fill the same data and press Ctrl and R. This will fill the same data to the right of the cell. This works more like the fill handle, and hence it can fill out formulas also.
Ctrl+D
This is also a similar shortcut as above. But this targets at filling downwards instead of filling up the right side of the cell. Just make sure the cell on which the data is present should be top of the current selection.
Ctrl+K
This shortcut simply adds hyperlinks to the selected cell that helps to direct the reader or user to an external location or range.
Ctrl+T
Select a specific range within the spreadsheet and press Ctrl and T to quickly convert it into a dynamic excel table. I use this function a lot.
Apart from these Microsoft Excel keyboard-shortcuts, the alt key and then right-click(option) key will help you to do some stuff really quickly. This is not a combo shortcut. Instead, you have to press each key individually in the exact order to achieve this. This may seem to be hard. But actually, it’s pretty easy because it will be right on your screen.
- First Press Alt key on your keyboard, now under each option in the ribbon, you’ll find a letter. For instance, F under the Files tab and H under Home Tab.
- For this example, lets press H to access items within the Home tab. Now items within the Home tab, we will have keys under them.
- And again, for our case, let’s say we want to merge the selected cells. So we have to price M that will highlight the merge option. But Merge itself has three options, so now we have to press C for Merge and center operation.
- So to sum up, Press Alt, H, M, C to merge and center the selected cells.
You can similarly manipulate this trick to run almost anything in the ribbon. For example, pressing Alt H B A will put all borders for your selected range. Similarly, press the right-click button and press the underlined text to carry out that task.
For example, right-click on a cell and press D to delete the cell. The same could be used by selecting an entire row or column and pressing the appropriate key.
Conclusion
So to conclude my point, these were the most used shortcuts in Microsoft Excel. Most of them will work with other spreadsheet programs, but it’s not guaranteed. Anyways you can use these shortcuts and tricks to accelerate your spreadsheet work, finish the job quickly, and be very productive and relaxed.
