Tutorial: Excel, its best shortcuts and most used - CYDIAPLUS.com

Breaking

Monday, 21 August 2017

Tutorial: Excel, its best shortcuts and most used



Excel is one of the most used programs in the office suite Microsoft Office . In fact they will ask you to have a minimum knowledge of it. It is used for multiple tasks because it saves us a lot of time and work. What we bring you today is an Excel tutorial with Excel shortcuts . Do not miss it and remember to return here whenever you need to look at it again.

Excel shortcuts

What we are going to do is to put them into different groups. Because depending on the moment you are going to need some things or others. Remember that in your browser you can use the "search" option to go to a specific word. With that little trick you'll save a lot of time.

Main actions and shortcuts of Excel

  • Ctrl + T : Used to select all the cells in a table.
  • Ctrl + A : With this shortcut you can select all the cells of a document.
  • Alt + F1 : Use this formula to create a chart with a selected data group.
  • Ctrl + Shift + L : This shortcut allows you to enable or disable the auto filter.
  • Ctrl + "+" key : To activate or deactivate the selected cell formulas.
  • F9 : This key allows you to calculate all operations on all worksheets.
  • F9 + part selection of a formula : You can calculate that selected operation.
  • Shift + F9 : Calculates all operations for the current worksheet.
  • ALT + = : To make a sum of the selected cells.
  • Ctrl + delete : To return to the last active cell.

Change format in Excel


  • Press Ctrl + 1 : opens the basic formatting box for the content.
  • Pressing Ctrl + Shift + ~ : applies the "general" format.
  • Giving Ctrl + Shift + $: puts the data in "currency" format.
  • We give Ctrl + Shift +%: puts the data in "percentage" format.
  • Let's give Ctrl + Shift + ^: put the data in "scientific"
  • Press Ctrl + Shift + # : puts the data in "date" format.
  • Ctrl + Shift + @ : puts the data in "hour" format.
  • Ctrl + Shift +! : Puts the data in "standard" format.
  • Ctrl + Shift + & : Add a border around the selection.
  • We give ALT + R : put a border to the right of the selection.
  • ALT + L : Places a border to the left of the selection.
  • ALT + B : Places a border at the bottom of the selection.

Search the spreadsheet


  • F2 : If you click on a selected cell, we edit it. It's like double clicking.
  • Crtl + direction keys: It leads you to the limit of each direction in the spreadsheet.
  • Shift + F2 : Adds a comment to a cell.
  • Ctrl + Home : return to cell A1 of the document.
  • Ctrl + Page Up / Page Down : Switch between worksheets.
  • Shift + F11 : Adds a new worksheet to the document.
  • ESC : On a selected cell, it erases everything and exits the cell.
Do you have any doubts ?, do you want to suggest that we do some tutorial ?, do not cut yourself !, we love to know what you think. Get in touch with us. Finally, I want to thank you for your visit and encourage you to use the comment box. Either in this article or in the social network Google+ . I'll say goodbye and wish you a happy day.

No comments:

Post a Comment

Follow by Email