Microsoft Excel shortcuts to make you a little more expert

Microsoft Excel Shortcuts

Excel is one of the most widely used tools in the world, but not only for work topics but also in many cases, in different types of studies of different courses. That is why it is important to know some tricks that can save us time while using Microsoft software.

There are several tricks that we should all know so that we can handle, in a more fluid way, a program such as Microsoft Excel .

If you have been using this tool for a long time, it is very possible that many of them already know them, but it is also true that some of them may have been forgotten or you did not knew it in the first place.

Let’s see which are the most used tricks and also a series of shortcuts that are very interesting to save time when working with this software from the company based in Redmond.

blank

Shortcuts in Excel, thanks to the keyboard

To work with Excel we can use a series of shortcuts thanks to the keyboard that will make us perform certain tasks in a much faster way. The other way is to have to go to a menu to do them, in which case it is more time consuming.

In addition, with these shortcuts we will also gain comfort when we are working with a spreadsheet, since everything is done instantly and without having to search for anything. Let’s see what these shortcuts are:

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-YESGo 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
[email protected]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

Some of the main basic formulas that we have in Excel are the following:

  • SUM: add the values ​​of the cells we want.
  • SUBTRACT: subtract the value of the cells we select.
  • MULTIPLICATION: for which functions we must write the = symbol and then indicate the cells separated from the * symbol.
  • DIVISION: we will write = after the dividend, the symbol / and the cell that will act as a divisor.
  • EVEN: to check if a number is even.
  • ODD: Same as above, but for odd numbers.
  • GREATER THAN: the formula is = A> B. It will tell us if true or false, that is, if it is greater than.
  • GREATER or EQUAL: the same as the previous one, but with the equal sign incorporated.
  • LESS THAN: the same as the previous ones, but with a minus sign.
  • LESS OR EQUAL: same as the previous one, but with the equal sign.
  • EQUAL TO: let’s check if two values ​​are equal = A1 = B1
  • DIFFERENT FROM: To check if two values ​​are different use A1 <> B2.
  • MAJOR: the name of the function is MAX.
  • MINOR: MIN function.
  • IF: The IF function performs a true or false type check to be able to set a value based on the result.

Source link

Rabins Sharma Lamichhane

Rabins Sharma Lamichhane is senior ICT professional who talks about #it, #cloud, #servers, #software, and #innovation. Rabins is also the first initiator of Digital Nepal. Facebook: rabinsxp Instagram: rabinsxp

Leave a Reply

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