List of keyboard shortcuts used in MS Excel

Computer

Introduction

In this article I have provided a list of Keyboard shortcuts used in MS Excel which will be very helpful for people who often work in MS Excel and also for students in their examination purpose

Sl. NoOperationKeyboard Shortcut
1To go to the last row of a worksheetPress Ctrl and Down arrow key
2To go to the first row of a worksheetPress Ctrl and Up arrow key
3To go to the last column of a worksheetPress Ctrl and Right arrow key
4To go to the first column of a worksheetPress Ctrl and Left arrow key
5To go the next sheet in a workbookPress Ctrl and Page Down key
6To go to the previous sheet in a workbookPress Ctrl and Page Up key
7To hide a selected row in a worksheetPress Ctrl and q key
8To hide a selected column in a worksheetPress Ctrl and O key
9To insert currency symbol in a cellPress Ctrl and Shift and $ key together
10To insert percentage symbol in a cellPress Ctrl and Shift and % key together
11To insert current timePress Ctrl and shift and Colon(:) key together
12To insert current datePress Ctrl and semicolon(;) key
13To paste the content of a cell located abovePress Ctrl and Shift and ” key together
14To sum up the values located abovePress Ctrl and Plus key(+) and press enter

Leave a Reply

Your email address will not be published. Required fields are marked *