Skip to content
  • Instagram
  • Home
  • Contact us
  • About us
  • Privacy Policy
Techusers

Techusers

Learn To be a Dev

  • Home
  • Guide
  • Security & Privacy
  • Tech News
  • Computer
  • Top List
  • What is
  • Engineering
  • How To
  • Tech Terms
  • Toggle search form

MS Office Excel 2016 and 2019 Full Shortcuts

Posted on 26/09/202126/09/2021 By Techuser

As a Techusers, we use ms office excel frequently for office related works. But most of the time shortcuts helps you simply work. Below is the list of shortcut keys used in ms word. Beware most of keys doesn’t work in all version.

Also Read: MS Word Shortcuts

KEY COMBINATIONACTION
Worksheet navigation
PgUp / PgDnMove one screen up / down
Alt-PgUp / Alt-PgDnMove one screen to the left / right
Ctrl-PgUp / Ctrl-PgDnMove one worksheet tab to the left / right
Up / Down arrow keyMove one cell up / down
TabMove to the next cell to the right
Shift-TabMove to the cell to the left
HomeMove to the beginning of a row
Ctrl-HomeMove to the beginning of a worksheet
Ctrl-EndMove to the last cell that has content in it
Ctrl-Left arrowMove to the word to the left while in a cell
Ctrl-Right arrowMove to the word to the right while in a cell
Ctrl-G or F5Display the Go To dialog box
F6Switch between the worksheet, the Ribbon, the task pane and Zoom controls
Ctrl-F6If more than one worksheet is open, switch to the next one
Ribbon navigation
AltDisplay Ribbon shortcuts
Alt-FGo to the File tab
Alt-HGo to the Home tab
Alt-NGo to the Insert tab
Alt-PGo to the Page Layout tab
Alt-MGo to the Formulas tab
Alt-AGo to the Data tab
Alt-RGo to the Review tab
Alt-WGo to the View tab
Alt-QPut cursor in the Tell Me box
Alt-JCGo to the Chart Tools / Design tab when cursor is on a chart
Alt-JAGo to the Chart Tools / Format tab when cursor is on a chart
Alt-JTGo to the Table Tools / Design tab when cursor is on a table
Alt-JPGo to the Picture Tools / Format tab when cursor is on an image
Alt-JIGo to the Draw tab (if available)
Alt-BGo to the Power Pivot tab (if available)
Working with data
Shift-SpacebarSelect a row
Ctrl-SpacebarSelect a column
Ctrl-A or Ctrl-Shift-SpacebarSelect an entire worksheet
Shift-Arrow keyExtend selection by a single cell
Shift-PgDn / Shift-PgUpExtend selection down one screen / up one screen
Shift-HomeExtend selection to the beginning of a row
Ctrl-Shift-HomeExtend selection to the beginning of the worksheet
Ctrl-CCopy cell’s contents to the clipboard
Ctrl-XCopy and delete cell’s contents
Ctrl-VPaste from the clipboard into a cell
Ctrl-Alt-VDisplay the Paste Special dialog box
EnterFinish entering data in a cell and move to the next cell down
Shift-EnterFinish entering data in a cell and move to the next cell up
EscCancel your entry in a cell
Ctrl-;Insert the current date
Ctrl-Shift-;Insert the current time
Ctrl-T or Ctrl-LDisplay the Create Table dialog box
Ctrl-EndWhen in the formula bar, move the cursor to the end of the text
Ctrl-Shift-EndIn the formula bar, select all text from the cursor to the end.
Alt-F8Create, run, edit or delete a macro
Formatting cells and data
Ctrl-1Display the Format Cells dialog box
Alt-‘Display the Style dialog box
Ctrl-Shift-&Apply a border to a cell or selection
Ctrl-Shift-_Remove a border from a cell or selection
Ctrl-Shift-$Apply the Currency format with two decimal places
Ctrl-Shift-~Apply the Number format
Ctrl-Shift-%Apply the Percentage format with no decimal places
Ctrl-Shift-#Apply the Date format using day, month and year
Ctrl-Shift-@Apply the Time format using the 12-hour clock
Ctrl-KInsert a hyperlink
Ctrl-QDisplay Quick Analysis options for selected cells that contain data
Working with formulas
=Begin a formula
Alt-=Insert an AutoSum function
Shift-F3Insert a function
Ctrl-`Toggle between displaying formulas and cell values
Ctrl-‘Copy and paste the formula from the cell above into the current one
F9Calculate all worksheets in all workbooks that are open
Shift-F9Calculate the current worksheet
Ctrl-Shift-UExpand or collapse the formula bar
Other useful shortcuts
Ctrl-NCreate a new workbook
Ctrl-OOpen a workbook
Ctrl-SSave a workbook
Ctrl-WClose a workbook
Ctrl-PPrint a workbook
Ctrl-FDisplay the Find and Replace dialog box
Ctrl-ZUndo the last action
Ctrl-YRedo the last action
Shift-F2Insert or edit a cell comment
Ctrl-Shift-OSelect all cells that contain comments
Ctrl-9Hide selected rows
Ctrl-Shift-(Unhide hidden rows in a selection
Ctrl-0Hide selected columns
Ctrl-Shift-)Unhide hidden columns in a selection
F7Spell check the active worksheet or selected range

Related

Guide

Post navigation

Previous Post: What is DevOps in IT?
Next Post: What is css? Types of css? and its basics

Recent Posts

  • How to Remove User Accounts in Windows 11
  • Jio 5G beta trial expands to Chennai; 5G-powered Wi-Fi services launched
  • What is a .NFA file? How to open it
  • What is a .M3U8 file? How to open it
  • What is a .AAX file? How to open it

Copyright © 2023 Techusers.

Powered by PressBook WordPress theme