Excel Worksheet Shortcut keys
The worksheet is a collection of cells, where you can store and manipulate data. By default, every workbook contains at least one worksheet in it. It is easier to organize and locate information in your workbook by using multiple worksheets when working with huge data. Excel Shortcuts will help you to work with large data in less amount of time. For exiting the worksheet, Renaming the worksheet, and many more.
Below are some shortcuts for worksheet:
Shortcuts |
Description |
---|---|
Shift + F11 |
Insert a new worksheet |
Ctrl +PgDn |
Go to the next Worksheet |
Ctrl + PgUp |
Go to the previous worksheet |
Alt +O, H, R |
Rename current worksheet |
Alt + E, L |
Delete current worksheet |
Alt + E, M |
Move Current Worksheet |
F6 or Shift + F6 |
Move between the worksheet, Ribbon, Task pane, and zoom controls in a worksheet that has been split |
Ctrl + Shift + PgUp/PgDn |
Select adjacent worksheet |
Ctrl + Click |
Select non-adjacent worksheets |
Scrlk |
Toggle Scroll Lock |
Ctrl +Shift + F1 |
Toggle fullscreen |
Ctrl + P |
|
Ctrl + F2 |
Open print preview window |
Alt + P, R, S |
Set Print area |
Alt + P + R,C |
Clear Print area |
Ctrl + Mouse Wheel up |
Zoom in |
Ctrl + Mouse Wheel Down |
Zoom in |
Alt + R, P, S |
Zoom in |
Top 100+ Excel Shortcut Keys List (A to Z)
Did you know that using keyboard shortcuts can increase productivity and save you time? Although the term “shortcut” may seem intimidating, it’s important to consider the benefits if you use computers every day!
Here, we provide a list of all essential list of excel shortcut keys, Starting with Basic Excel Shortcuts to advanced Excel shortcut keys.
We have also compiled all the essential computer shortcut keys, which include shortcuts for popular software like Microsoft Word, Excel, PowerPoint, and Gmail, as well as special characters and shortcuts relevant to competitive exams.
Contact Us