Excel Shortcuts

·

Insert shortcuts

  • Insert dialog box > ctrl +
  • Insert current date > ctrl + ;
  • Insert current time > ctrl + Shift + ;

Delete shortcuts

  • Delete dialog box > ctrl + –

Formatting shortcuts

  • Format cells dialog box > ctrl + 1
  • Bold > ctrl + b
  • Italics > ctrl + i
  • Underline > ctrl + u
  • Indent (increase) > alt + h + 6
  • Indent (decrease) > alt + h + 5

Formula shortcuts

  • Sum > alt + =

Paste shortcuts

  • Paste as value > alt + e + s + v + enter

Other shortcuts

  • Copy text above active cell > ctrl + d
  • Select entire row > shift + spacebar
  • Select entire column > ctrl + spacebar
  • Navigate through worksheets > ctrl + page up / page down
  • Filter > ctrl + shift + l
  • Insert/convert data to table > ctrl + t

Comments

Leave a Reply

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