How To Use Excel Shortcut Keys

Well microsoft excel is still used for many projects that needs data to be filled in or even for calculations through excel formulas.

How to use excel shortcut keys. You can just perform various functions in excel quickly using the microsoft excel shortcut keys you need to be used to these ms excel shortcut keys to enjoy a. Shift arrow key extends the selection of cells by one cell. Shortcut keys help to provide an easier and usually quicker method of directing and finishing commands in microsoft excel. In excel for the web access keys all start with alt windows logo key then add a letter for the ribbon tab. But if you know the ms excel shortcut keys it makes it quite simple and faster.

Performs calculate function on active sheet. The f4 key has a lot of different uses in excel. So make sure to share them with your friends co workers as well. To that end we ve compiled this handy list of all the excel shortcuts you should know for both mac and pc. Ctrl arrow key moves to the edge of the current data region in a worksheet.

But often it can be hard to remember these hotkeys especially if you regularly switch between the mac and pc versions of excel. Excel shortcut keys can greatly improve your speed when conducting analysis. List of excel shortcuts keys pdf for windows mac. In excel keyboard shortcuts are commonly accessed by using alt ctrl shift function key and windows key. Move to previous pane.

The excel workbook that i use in the video can be downloaded here. Some of the most well known and commonly used keyboard shortcuts fall within this group. Select all contents of a worksheet. For example to go to the review tab press alt windows logo key r. Ctrl shift arrow key extends the selection of cells to the last nonblank cell in the same column or row as the active cell or if the next cell is blank extends the selection to the next nonblank cell.

Opens the excel formula window. Brings up a search box. Mostly we prefer to use the shortcuts as it s kind of amazing how much time we can save by not using the mouse clicks. Ctrl c to copy. Ctrl b to apply or remove bold formatting.