Excel Hack

Shortcut keys in Excel sheet

Using shortcut keys, you can create new sheets and delete sheets without using the mouse. You can also select an entire sheet or switch between sheets smoothly. You can also use the access key to change the color of the sheet tabs. We will also show you how to use the access key to display the Move or Copy dialog box and the Protect Sheet dialog box.

Shortcut keys for sheets

Select the current and previous/next sheet

Windows
Ctrl + Shift + PgUp or Ctrl + Shift + PgDn

Mac
shift + option + or shift + option +

Move and copy sheets

Windows
Access Key: Alt + E + M or Alt + H + O + M

Mac
None

Sheet tab color change

Windows
Access Key: Alt + H + O + T

Mac
None

Protect sheet

Windows
Access Key: Alt + R + P + S

Mac
None

Select the current sheet and the adjacent sheet

Here is a shortcut key to select the current sheet and adjacent sheets consecutively.

Total Time: 1 minute

Select the sheet

Select the sheet

Select the first sheet you want to select.

Continuous selection of sheets is complete

Continuous selection of sheets is complete

Press Ctrl + Shift + PgDn, you can select the next sheet in succession. If you want to select the current sheet and the previous sheet, press Ctrl + Shift + PgUp.

Use shortcut keys to move or copy sheets

This time, we will use the shortcut keys to display the Move or Copy dialog box and move the sheet to the end of the sheet.

Select a sheet

Select the sheet you want to move and press Alt + E + M.

Select move to end

The Move or Copy dialog box will open.

Use (Down Arrow key) to select the (move to end) and press Enter.

The sheet moves to the end

This completes the move operations for the sheet.

Change the tab color

Select a sheet

Select a sheet for which you want to change the tab color.

Select any color

Press Alt + H + O + T to display the Tab Color.

Use the arrow keys to select the desired color and press Enter.

The color of the sheet changes

The tab color has been changed.

Use shortcut keys to protect the sheet

Select a sheet

Select the sheet you want to protect and press Alt + R + P + S.

Set a password

The Protect Sheet dialog box will appear.

Enter the password you want to set for the sheet and press Enter.

Enter the password again

The Confirm Password dialog box will appear.

Enter the password you set again, and press Enter.

The sheet is protected

The sheet is now protected.

Articles related to Sheet & Shortcut

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments