• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
DEOWB_LOGO_192X192

DEO West Bengal

The DEO Education Channel

  • Home
  • New Updates
  • Tutorials
  • ORDER
  • PAYMENTS
  • ISGP
  • UTILITY
  • Videos
You are here: Home / Downloads / Microsoft Excel Keyboard Shortcuts

Microsoft Excel Keyboard Shortcuts

May 2, 2018 by Subhrapratim De

[featured_image]
Microsoft Excel Keyboard Shortcuts
Download is available until [expire_date]
  • Version
  • Download 30
  • File Size 393.61 KB
  • File Count 1
  • Create Date May 2, 2018
  • Last Updated May 2, 2018

Microsoft Excel Keyboard Shortcuts

Due to the huge amount of work spent in the Office background, working with Microsoft Excel keyboard shortcuts can significantly improve productivity. Have you ever observed experienced PC users? They are not mouse glued! They combine mouse actions with keyboard commands for higher access time and earlier results. Complex tasks require advanced interaction with the computer and that can be done by taking advantage of all the means available including the valuable keyboard shortcuts. Therefore, while Microsoft Office is the most notorious and used application in the field, I took the time to search and harvest some important keyboard shortcuts for the well known applications: Word, Excel and Powerpoint.

Important Word Shortcuts

All Caps - CTRL+SHIFT+A

Annotation - ALT+CTRL+M

Auto Format - ALT+CTRL+K

Auto Text - F3 or ALT+CTRL+V

Bold - CTRL+B or CTRL+SHIFT+B

Bookmark - CTRL+SHIFT+F5

Copy - CTRL+C or CTRL+INSERT

Copy Format - CTRL+SHIFT+C

Copy Text - SHIFT+F2

Create Auto Text - ALT+F3

Date Field - ALT+SHIFT+D

Delete Back Word - CTRL+BACKSPACE

Delete Word - CTRL+DELETE

Dictionary - ALT+SHIFT+F7

Do Field Click - ALT+SHIFT+F9

Doc Maximize - CTRL+F10

Doc Move - CTRL+F7

Doc Restore - CTRL+F5

Doc Size - CTRL+F8

Grow Font - CTRL+SHIFT+.

Grow Font One Point - CTRL+]

Hanging Indent - CTRL+T

Header Footer Link - ALT+SHIFT+R

Help - F1

Hidden - CTRL+SHIFT+H

Hyperlink - CTRL+K

Indent - CTRL+M

Italic - CTRL+I or CTRL+SHIFT+I

Justify Para - CTRL+J

Left Para - CTRL+L

Line Up Extend - SHIFT+UP

List Num Field - ALT+CTRL+L

Outline - ALT+CTRL+O

Outline Collapse - ALT+SHIFT+- or ALT+SHIFT+NUM -

Outline Demote - ALT+SHIFT+RIGHT

Outline Expand - ALT+SHIFT+=

Outline Expand - ALT+SHIFT+NUM +

Outline Move Down - ALT+SHIFT+DOWN

Outline Move Up - ALT+SHIFT+UP

Outline Promote - ALT+SHIFT+LEFT

Outline Show First Line - ALT+SHIFT+L

Lock Fields - CTRL+3 or CTRL+F11

Web Go Back - ALT+LEFT

Web Go Forward - ALT+RIGHT

Word Left - CTRL+LEFT

Word Left Extend - CTRL+SHIFT+LEFT

Word Right - CTRL+RIGHT

Excel Time saving Shortcuts

Move to next cell in row - Tab

Move to previous cell in row - Shift + Tab

Up one screen - Page Up

Down one screen - Page Down

Move to next worksheet - Ctrl + Page Down

Move to previous worksheet - Ctrl + Page Up

Go to first cell in data region - Ctrl + Home

Go to last cell in data region - Ctrl + End

Bold toggle for selection - Ctrl + B

Italic toggle for selection - Ctrl + I

Underline toggle for selection - Ctrl + U

Strikethrough for selection - Ctrl + 5

Change the font - Ctrl + Shift + F

Change the font size - Ctrl + Shift + P

Apply outline borders - Ctrl + Shift + 7

Remove all borders - Ctrl + Shift + Underline

Wrap text in same cell - Alt + Enter

Format cells - Ctrl + 1

Select font - Ctrl + Shift + F

Select point size - Ctrl + Shift + P

Format as currency - Ctrl + Shift + 4

Format as general - Ctrl + Shift + # (hash sign)

Format as percentage - Ctrl + Shift + 5

Format as number - Ctrl + Shift + 1

Autosum a range of cells - Alt + Equals Sign

Insert the date - Ctrl + ; (semi-colon)

Insert the time - Ctrl + Shift + ; (semi-colon)

Insert columns/rows - Ctrl + Shift + + (plus sign)

Insert a new worksheet - Shift + F11

Read Monitor Cell One - Alt + Shift + 1

Read Monitor Cell Two - Alt + Shift + 2

Read Monitor Cell Three - Alt + Shift + 3

Read Monitor Cell Four - Alt + Shift + 4

List Visible Cells With Data - Ctrl + Shift + D

Lists Data In Current Column - Ctrl + Shift + C

List Data In Current Row - Ctrl + Shift + R

Select Hyperlink - Ctrl + Shift + H

Move To Worksheet Listbox - Ctrl + Shift + S

Move To Monitor Cell - Ctrl + Shift + M

Select Worksheet Objects - Ctrl + Shift + O

List Cells At Page Breaks - Ctrl + Shift + B

Options Listbox - Insert + V

Easy move through Powerpoint

Apply subscript formatting - CTRL+EQUAL SIGN (=)

Apply superscript formatting - CTRL+PLUS SIGN (+)

Bold - CTRL+B

Capitalize - SHIFT+F3

Copy - CTRL+C

Delete a word - CTRL+BACKSPACE

Demote a paragraph - ALT+SHIFT+RIGHT ARROW

Find - CTRL+F

Insert a hyperlink - CTRL+K

Insert a new slide - CTRL+M

Italicize - CTRL+I

Make a duplicate of the current slide - CTRL+D

Open - CTRL+O

Open the Font dialog box - CTRL+T

Paste - CTRL+V

Print - CTRL+P

Promote a paragraph - ALT+SHIFT+LEFT ARROW

Repeat your last action - F4 or CTRL+Y

Save - CTRL+S

Select all - CTRL+A

Start a slide show - F5

Switch to the next pane (clockwise) - F6

Switch to the previous pane - SHIFT+F6

Undo - CTRL+Z

View guides - CTRL+G

Reader Interactions

Leave a Reply Cancel reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

https://youtu.be/-kGp0up7xqc

Footer

About Us

DEOWB (Data Entry Operators - West Bengal) was started in 2009 as deowestbengal.wordpress.com to help all the DEO/VLEs working under MGNREGA schemes. With times things have changed to this. If you are a DEO/VLE, you are at the right place. This is the ultimate DEO Education Channel..!!!

Social

  • Facebook
  • YouTube

© 2009–2023 DEO West Bengal