Welcome to Excelshortcut

Master the Shortcuts. Get work done faster.
Learn More

Learn to use Excel faster and Maximize Productivity

Welcome to Excelshortcut, the place to get faster with Excel.

Microsoft Excel is a powerful tool for working with data. At Excel Shortcut, our goal is to help you use it as efficiently as possible.

Navigate this website to learn the Excel shortcuts and top formulas. The blog covers Excel and other topics, like how  to automate boring tasks and how to use software to maximize work performance.

Our goal is to help you work more efficiently with technology and create time for stuff that matters most.

Use the table below to navigate through the best shortcuts for Microsoft Excel.

HotkeyKey CombinationActionDescription
CtrlCtrl+ASelect AllSelect All Cells in a worksheet
CtrlCtrl+BBoldMake Cell Font Bold
CtrlCtrl+CCopyCopy Selection
CtrlCtrl+DFill DownCopy Selection
CtrlCtrl+FFindPulls data from cell above into selected cell
CtrlCtrl+GGotoSummons Goto Dialog Box
CtrlCtrl+HReplaceFind and Replace string with defined string
CtrlCtrl+IItalicItalicize Cell Font
CtrlCtrl+KInsert HyperlinkDefine Link and corresponding Address
CtrlCtrl+NNew WorkbookOpen New Workbook
CtrlCtrl+OOpenSummon Open Menu
CtrlCtrl+PPrintOpen Print Preview Screen
CtrlCtrl+RFill RightPulls cell contents from left cell into selected cell
CtrlCtrl+SSaveSave Document
CtrlCtrl+UUnderlineUnderline Cell Contents
CtrlCtrl+VPastePasted Copied Information Into Cell
CtrlCtrl WCloseClose Current Document
CtrlCtrl+XCutCopy Selection to Clipboard while removing contents of cell
CtrlCtrl+YRepeatRepeat the last action performed
CtrlCtrl+ZUndoUndo previous action
F KeysF1HelpOpen help dialog
F KeysF2EditEnter cell to make changes
F KeysF3Paste NameOpen list of named ranges to paste
F KeysF4Repeat last actionRepeat the last action performed
F KeysF4Absolute to RelativeSwitches between absolute and relative references during formula edit
F KeysF5GotoEnter and move to cell or range of cells
F KeysF6Next PaneIf worksheet is split, move to next pane
F KeysF7Spell checkOpen Spellcheck tool
F KeysF8Extend modePress, then use arrow keys to extend selection
F KeysF9Recalculate AllRecalculates entire workbook if set to manual calculation
F KeysF9Change to ValueDuring cell edit mode, replaces formula with calculated value
F KeysF10Activate MenubarAdds letters to menu bar that can be used as shortcuts
F KeysF11New ChartOpens Design tools and new chart
F KeysF12Save AsSave Document and Choose Name
CtrlCtrl+:Insert Current TimeEnter current timestamp
CtrlCtrl+;Insert Current DateEnter current datestamp
CtrlCtrl+"Copy Value from AbovePulls data from cell above into selected cell
CtrlCtrl+’Copy Formula from AbovePulls formula from cell above into selected cell
F KeysShift+F2Edit cell commentOpen/Add Cell Comment box for editing
F KeysShift+F3Paste function into formulaOpen Insert Function Dialog Box
F KeysShift+F4Find NextMove to Next Similar Value
F KeysShift+F5FindOpen Find/Replace Dialog
F KeysShift+F6Previous PaneMove back to Pane previously occupied if Split is used
F KeysShift+F8Activate add to selection modeAllows selecting multiple selections without CTRL key
F KeysShift+F9Calculate active worksheetPerform all calculations for active worksheet
F KeysShift+F10Display Cell shortcut menuRight Click on a cell
F KeysShift+F11New worksheetOpen New Blank Workshee
F KeysShift+F12SaveQuicksave Document
F KeysCtrl+F3Define nameEdit Name Properties of open worksheets
F KeysCtrl+F4CloseClose Current Workbook
F KeysCtrl+F5XL, Restore window sizeExpand Worksheet size to fill application window
F KeysCtrl+F9Minimize workbookSend Workbook to Task bar
F KeysCtrl+F10Maximize or restore windowExpand Workbook to Maxium Screen size
F KeysCtrl+F11Inset 4.0 Macro sheetOpen New Macro Tab in Worksheet
F KeysCtrl+F12File OpenOpen File Browser
F KeysAlt+F1Insert ChartQuick Paste Chart From highlighted Cells
F KeysAlt+F2Save AsSave Document and Choose Name
F KeysAlt+F4ExitClose current workbook
F KeysAlt+F8Macro dialog boxOpen Macro Dialog Box
F KeysAlt+F11Visual Basic EditorOpen Visual Basic Editor Menus
F KeysCtrl+Shift+F3Create Names DialogAutomatically names ranges based on row and column headings
F KeysCtrl+Shift+F6Previous WindowSwitches to other window in excel
F KeysCtrl+Shift+F12PrintOpen Print Preview
F KeysAlt+Shift+F1New worksheetAdd and Open New Blank Worksheet
F KeysAlt+Shift+F2SaveSave Current Workbook
AltAlt+=AutoSumInsert Sum Function
AltAlt+Down arrowDisplay AutoCompleteShow all options for Autocomplete
AltAlt+’Format Style dialog boxOpen cell Formatting options
CtrlCtrl+Shift+~General formatconvert number to general format
CtrlCtrl+Shift+!Comma formatconvert number to comma format
CtrlCtrl+Shift+@Time formatconvert number to time format
CtrlCtrl+Shift+#Date formatconvert number to date format
CtrlCtrl+Shift+$Currency formatconvert number to currency format
CtrlCtrl+Shift+%Percent formatconvert number to percent format
CtrlCtrl+Shift+^Exponential formatconvert number to exponential format
CtrlCtrl+Shift+&OutlineCreate Outline around cell
CtrlCtrl+Shift+_Remove outline borderRemove outline around cell
CtrlCtrl+Shift+*Select current regionHighlight region current to selected select
CtrlCtrl+Shift++InsertOpen Insert Function Dialog Box
CtrlCtrl+-DeleteOpen Delete Function Dialog Box
CtrlCtrl+1Format cells dialog boxOpen Format Cells Dialog Box
CtrlCtrl+2BoldActivate Bold Font
CtrlCtrl+3ItalicActivate Italic Font
CtrlCtrl+4UnderlineActivate Underline Font
CtrlCtrl+5StrikethroughActivate Strikethrough Font
CtrlCtrl+8Toggle Outline symbolsDisplay outline symbols if activated in workbook
CtrlCtrl+9Hide rowsHide selected row
CtrlCtrl+0Hide columnsHide selected column
CtrlCtrl+Shift+(Unhide rowsunhide hidden rows
CtrlCtrl+Shift+)Unhide columnsunhide hidden columns
AltAlt or F10Activate the menuDisplay shortcut symbols in main menu
ShiftShift+Ctrl+FFont Drop Down ListOpen Format Menu with Font tab selected
ShiftShift+Ctrl+PPoint size Drop Down ListOpen Format Menu with Font tab and size selected
keepersecurity.com

Recent Post

Learn about SQL joins using Excel

Why do we join tables in SQL? Tables that logically represent information are the foundation of relational databases. The ancient rules of database normalization remind us to arrange database tables to reduce redundancy and increase flexibility. An adequately...

Super Bowl Squares Template

elink.io | See Original The Superbowl is almost here. If you are tasked with creating blocks for a pool, there's still time to pull out your ruler, draw up a grid, and wrangle a bunch of friends into writing their names in the squares. Or, spare yourself some time...

How to Return Multiple Matches in one Cell Using a lookup?

VLOOKUP is great for looking up a value and returning another corresponding value. But what happens when the first match just isn't enough. I've been tasked with finding a way to put return not just the first but the second, and third match. At first, I tried to...

How to Delete every other Row in Excel

Have you ever needed to delete every other row in Excel? You are not alone.   There are a few ways to accomplish it. It's a pretty good candidate for a VBA solution, but I'm going to show you how to quickly delete every other row without using VBA or a plugin. I...

Data Defender: Play this Excel Game and Learn Excel Shortcuts Fast

Microsoft Excel has roughly 750 million users all over the world. It is an essential, all-purpose business tool. This spreadsheet software can fill a wide range of business needs. Every business professional needs to get familiar with Excel. Your proficiency level...

Select the Email Service Provider that is right for you.

  Excelshortcut.com commits to continuous improvement. I've wondered if our Communication distribution process is lacking. Is there a more effective tool to help us share valuable content? Mailchimp has been ExcelShortcut.com's tool for email creation and...

Insert Multiple Rows into SQL table Using Excel as a Template

I hope you followed the previous tutorial where we checked Created some brand new database tables using Excel as a template. Let's populate these tables with meaningful data. Okay, it might not be the most meaningful dataset since I just made this data up using...

SQL Statement Samples for Tutorials

  Use the Excel Templates below to follow along with the Excel2SQL Tutorials. Feel free to download and modify these smooth templates to Create your own SQL Scripts. [embeddoc...

How Do You Learn Computer Programming Quickly?

If you don’t have a job as a programmer and want to learn fast, focus on active learning with lots of practice. Here is the path I recommend you take to fast-track the process: 1) Start with targeted, interactive lessons — short sessions of introductory and passive learning. 2) Passion projects — spend the bulk of your emphasis on longer sessions of challenging, passion-driven side projects.
3) Aim for things that you like to do or that will make your daily obligations easier. 4) Bring along a mentor or pay a freelancer to guide you. They will provide feedback and help you throw out lousy coding habits. Supplement with other sources to fill in the gaps. 5) Keep repeating steps 1 through 4 while applying for entry-level programming jobs.
6) Enroll in a short, targeted, software development path.

Create Tables

We will create some brand new tables in SQL Management Studio using Excel as a template in this tutorial. The sample data is a fictitious list of Experts and their areas of specialty. Below is a quick Description of our tables and a short sampling of each. This...

Updating Table Data, Excel VS SQL

Change is part of life and our data is extremely susceptible to these changes. Can Microsoft Excel Keep up with all of the changes to your data? Maybe it's time to use SQL to update your data. Let’s discuss updating data in an effective way. Up until now, many of the...

Getting Started with SQL Databases (an Excel User’s Perspective)

Most of my readers are heavy Excel users. Today we will transition our strong Excel foundation into learning another complementary tool, SQL Databases. Here are a few components that are fundamental to Databases and SQL. Tables - Other concepts could come first,...

Excel Pros should learn SQL to pull their own data.

Let's discuss why Excel Users should learn SQL to pull their own data. First, we will answer the basic question, What is SQL? SQL stands for Structured Query language. It is used to manage structured information in database tables. Structured data is formatted for...

If you want to get faster with Excel and optimize your workflow Sign up for the Shortcut Newsletter today.

Most Popular Blog Posts

How Do You Learn Computer Programming Quickly?

How Do You Learn Computer Programming Quickly?

If you don’t have a job as a programmer and want to learn fast, focus on active learning with lots of practice. Here is the path I recommend you take to fast-track the process: 1) Start with targeted, interactive lessons — short sessions of introductory and passive learning. 2) Passion projects — spend the bulk of your emphasis on longer sessions of challenging, passion-driven side projects.
3) Aim for things that you like to do or that will make your daily obligations easier. 4) Bring along a mentor or pay a freelancer to guide you. They will provide feedback and help you throw out lousy coding habits. Supplement with other sources to fill in the gaps. 5) Keep repeating steps 1 through 4 while applying for entry-level programming jobs.
6) Enroll in a short, targeted, software development path.

read more