#Best excel shortcut keys how to#
#Best excel shortcut keys Pc#
#Best excel shortcut keys series#
#Best excel shortcut keys windows#

Page Up or Down : Move one screen up or down in a worksheet.

Ctrl + Home : Move to the beginning of a worksheet.

Home : Go to the leftmost cell in the current row (or go to the beginning of the cell if editing a cell).

F5 : Go to any cell by pressing F5 and typing the cell coordinate or cell name.

Ctrl + End : Go to the most bottom right used cell.

Ctrl + Up or Down arrow : Move to the top or bottom cell in the column.

Up or Down arrow : Move one cell up or down.

Ctrl + Left or Right arrow : Move to the farthest cell left or right in the row.

Left or Right arrow : Move one cell to the left or right.

With these shortcuts, you can almost completely eliminate the use of a mouse, never breaking your flow. Going a step further is the keyboard shortcuts specifically used within Excel worksheets and cells. Shortcuts for moving around in a worksheet or cell

F11 : Create a bar chart based on selected data (on a separate sheet).

F9 : Calculate all worksheets in all open workbooks.

F4 : Repeat the last command or action.

Alt + Q : Go to the “ Tell me what you want to do ” box.

Alt + F11 : Open the Microsoft Visual Basic For Applications Editor.

Alt + F8 : Create, run, edit, or delete a macro.

Alt + F1 : Create an embedded bar chart based on select data (same sheet).

Shift + F9 : Calculate active worksheets.

Ctrl + Tab : Switch between open workbooks.

Ctrl + Shift + U : Expand or collapse the formula bar.

Ctrl + F9 : Minimize the workbook window.

They’re not particularly advanced, but they help you get around Excel just a bit easier. These keyboard shortcuts are used for manipulating workbooks, getting help, and other interface-related actions.

Delete : Remove the contents of a cell, selected data, or selected cell range.

Ctrl + V or Shift + Insert : Paste contents of a cell, selected data, or selected cell range.

Ctrl + C or Ctrl + Insert : Copy contents of a cell, selected data, or selected cell range.

Ctrl + S : Save the currently open workbook.

Ctrl + O : Open a workbook saved on your computer or an online source.

Ctrl + F : Search in a spreadsheet, or use Find and Replace.

Let’s start with the basics and see how you can use basic shortcuts to speed up your Excel flow: These shortcuts aren’t specific to Excel only - they work in most other applications and on websites as well! Chances are, you might have even heard of them before. The shortcuts below are very basic, yet very powerful.

Note: These shortcuts were carefully selected from Top 51 Excel Templates to Boost Your Productivity that you can check out to boost your Excel Productivity. So, we made a list of the most useful Excel shortcuts you should always have on-hand, or in your memory. Memorizing each and every one of them is pretty much impossible. However, since Excel is a very complex application, it has hundreds of shortcuts for you to use.

In Excel, these shortcuts are used to expedite common operations by reducing input sequences to a few keystrokes. In computers, a keyboard shortcut is a means for performing one or more commands using the keyboard, that would otherwise be accessible through some sort of user interface. Cut down unnecessary seconds spent browsing through menus and use shortcuts instead. Using shortcuts is one of the most effective ways of speeding up your workflow.

#Best excel shortcut keys Pc#

Thanks for reading CFI’s guide to Excel shortcuts for your PC and Mac keyboard! By taking the time to learn and master these keys, you’ll significantly speed up your financial analysis.Keyboard shortcuts have been around for as long as Microsoft Excel itself.

#Best excel shortcut keys how to#

If you want to learn these keyboard shortcuts with your own personal online instructor, check out CFI’s Free Excel Crash Course! You’ll receive step by step instructions and demonstrations on how to avoid the mouse and only use your keyboard. Excel is quite robust, meaning there are a lot of different tools that can be utilized within it, and therefore there are many skills one can practice and hone. You may also want to check out our section on Excel formulas or the Excel formulas cheat sheet.

#Best excel shortcut keys windows#

If you follow our tips and tricks below you’ll be able to master these shortcuts on Windows or Mac operating systems. Your mouse will be taken away and you’ll be expected to learn financial modeling with only keyboard shortcuts.

#Best excel shortcut keys series#

The first thing you’ll do if you’re hired as an investment banking analyst is take a series of intense Excel training courses. These are critical for careers in investment banking, equity research, FP&A, finance, accounting, and more. To be more productive, faster, and more efficient when building financial models or performing financial analysis, it’s important to know the main keyboard shortcuts in Excel.