Skip to content

How To Create A Shortcut In Excel 2013

Key Takeaway:

  • Using shortcuts in Excel 2013 can save time and improve productivity: By using keyboard shortcuts and creating custom ones, users can streamline their work and avoid repetitive tasks. Understanding the importance of shortcuts and their types is crucial for maximizing their benefits.
  • Creating a shortcut in Excel 2013 involves selecting the correct cell or cell range, accessing the “Shortcut” toolbar or ribbon, and assigning a key combination: The shortcut can then be named and saved, with its successful execution verified in a new worksheet. Troubleshooting any issues involves analyzing key conflicts or verifying the connection with the correct cell or range.
  • Learning and using essential keyboard shortcuts in Excel 2013 can significantly boost efficiency: Some examples include CTRL+C for copying, CTRL+X for cutting, and CTRL+V for pasting. Memorizing and utilizing these shortcuts can prove to be a valuable asset in any working environment.

Do you struggle to access Excel 2013’s features quickly? This blog post will show you how to create a shortcut in Excel 2013 and make your work easier. With just a few clicks, you can access your favorite tools in no time!

Understanding Shortcuts

Keyboard shortcuts in Excel 2013 are super-efficient! They save time and improve accuracy. Let’s explore why shortcuts are so important and how to decide which type is right for you. Plus, we’ll look at the essential shortcuts to help you be more productive. Ready to become a pro? Read on!

Understanding Shortcuts-How to create a shortcut in Excel 2013,

Image credits: by Harry Woodhock

Determining the shortcut type appropriate for your needs

It’s key to identify the task you need to do quickly. Search for a command ribbon that has that task. Check if there is an existing keyboard shortcut. Or, if not, is there an alt key sequence? Perhaps create a custom shortcut if no existing one fits your needs.

Customizing software to your preferences makes navigation easier and streamlines processes. My pal Rachel works in finance and spends hours manipulating data on Excel every day. She uses shortcuts and is able to finish her workload faster. This gives her more free time outside of work.

Mastering Excel 2013 requires learning essential keyboard shortcuts. Let’s get started!

Learning the essential keyboard shortcuts for Excel 2013

Take 3 steps to start learning essential Excel keyboard shortcuts:

  1. Figure out which ones you use most often.
  2. Look up the corresponding shortcuts. Many resources online can help. Print or bookmark a guide.
  3. Practice using them while working in Excel. Repetition helps master any skill.

Keyboard shortcuts can reduce fatigue and strain on hands. Plus, they make you more accurate. Studies show that those who use them have fewer mistakes.

Realizing the importance of shortcuts in Excel is key for anyone wanting to excel. They make work easier, improve efficiency and accuracy, and contribute to good ergonomics. So save time and energy when dealing with data sets or multiple worksheets.

Understanding the importance of using shortcuts in Microsoft Excel

Gaining an understanding of Microsoft Excel shortcuts is key: they offer faster data entry, better navigation and easy formatting. This makes your workflow smoother and leaves more time for data analysis.

There are hundreds of shortcuts available for different features. These can be for common commands like copy/paste or selecting cells, as well as more complex functions like formulas and charting. Knowing these keyboard combinations boosts your user experience and productivity. This is because it eliminates the need to switch from typing to clicking, and back again – increasing accuracy and efficiency.

Take Jill for example. She was given an urgent task requiring use of Excel’s formatting. After learning the right shortcuts she completed it quickly, without having to experiment with different menus.

In conclusion, Microsoft Excel shortcuts provide quick access to commonly-used tools and commands – making life easier.

Creating a Shortcut

Struggling to use Microsoft Excel 2013? Making a shortcut will save time and make it easier to find certain cells or cell ranges. This guide breaks the steps for making a shortcut into three sections.

  1. Launch Excel 2013.
  2. Select the cells or cell ranges for your shortcut.
  3. Finally, access the “Shortcut” toolbar or ribbon. This will make your shortcut always accessible.

A few clicks is all it takes to make Excel simpler and save time.

Creating a Shortcut-How to create a shortcut in Excel 2013,

Image credits: by James Jones

Launching Microsoft Excel 2013

Here’s a guide to launch Microsoft Excel 2013:

  1. Click Start button on your computer’s desktop or taskbar.
  2. Select Microsoft Office from the list of programs.
  3. Click Microsoft Excel 2013 from the drop-down menu.

Create a shortcut by selecting a cell or range of cells and using “Ctrl” + “Shift” + “F” keyboard shortcut.

You may need some knowledge to navigate and use the program. No worries – there are tutorials and resources to help you learn.

Don’t miss out on creating shortcuts in Excel 2013. They save time and increase productivity.

Now, let’s look into selecting the cell or cell range for the shortcut. This can be an effective way of navigating data.

Selecting the cell or cell range for the shortcut

Open the Excel worksheet where you want to create a shortcut. Click on the cell or range of cells you want to assign a shortcut key to. While pressing the ‘Control’ (Ctrl) key on your keyboard, press the chosen letter or number key.

This way, you can quickly get to frequently used data without needing to search through long worksheets. Make sure you select cells that you often access and need quick navigation for. This will save valuable time.

Finally, access the “Shortcut” toolbar or ribbon.

Accessing the “Shortcut” toolbar or ribbon

Open an Excel workbook on your computer. Look for the “Quick Access Toolbar” above the Excel ribbon. Click on the down arrow icon at the end of the QAT. Choose “More Commands” from the drop-down list.

A new window will open, titled “Excel Options“. Here, you can adjust settings related to your Excel software, including setting up shortcuts. Click “Customize Ribbon” on the left-hand side of this window. You can add or remove shortcuts from the toolbar.

Customize the QAT for quicker access to your favorite tools and features. This will help you observe only necessary tools when starting Excel, without opening any files and no unnecessary clicks.

Now, let’s learn about assigning shortcut keys. This is useful for Microsoft Office Programs such as Excel 2013.

Assigning Shortcut Keys

Excel users often have tasks that they repeat. Creating keyboard shortcuts can help save time and effort. In this section, I’ll show how to assign keys in Excel 2013. We’ll explore three sections:

  1. Choosing the key combination
  2. Naming and saving the shortcut
  3. Verifying it worked

After this, you’ll be able to make your own custom shortcuts and boost your Excel productivity!

Assigning Shortcut Keys-How to create a shortcut in Excel 2013,

Image credits: by Yuval Jones

Choosing the key combination for the shortcut

Open Excel and select the command or function you want to assign a shortcut key to.

Go to File tab on top left corner of screen, then click Options.

From Options window, select Customize Ribbon on left side. Click ‘Customize’ button next to Keyboard Shortcuts.

Pick ‘For all documents (default)‘ from “Save changes in box” and choose Home Tab in “Categories”. Now pick your command from “Commands”.

Type preferred keyboard combination into ‘Press new shortcut key‘ field. Check whether it’s already assigned to another function.

Be aware some keyboard shortcuts are pre-set by default – don’t overwrite them.

Choose your combination carefully – make it memorable, easy to use and remember, without being too similar to other commands. This can help save time and streamline your workflow when using Excel.

Name and save your custom-made shortcuts – and you’re all set!

Naming and saving the created shortcut

Creating a shortcut key in Excel 2013 is simple. It takes just a few steps.

  1. Select the macro and click ‘Options’ at the bottom.
  2. Type your desired combination of keys in the ‘Shortcut Key’ box. Check it doesn’t conflict with any of the built-in Excel shortcuts.
  3. Click ‘OK’ to save the new shortcut key combination.
  4. To name it, go to ‘File’ > ‘Save As’. Enter a descriptive name in the ‘File Name’ field. Click ‘Save’ to save the named shortcut.

Reusing the shortcut is easy. Just press its assigned keyboard shortcut. You can modify or delete it later if needed.

Using keyboard shortcuts can increase productivity by up to 25 percent, according to Microsoft Corporation.

Let’s move onto verifying our newly assigned shortcut has been successfully assigned.

Verifying that the shortcut has been successfully assigned


Open the file with the shortcut you just assigned.
Choose the command you assigned a shortcut key to.
Press the keys for your shortcut.
If the command executes, success!
If not, check if you entered the correct key combination or if it conflicts with existing shortcuts.

Verifying your shortcut is important to avoid confusion and wasting time. Test it in various files or worksheets you intend to use it on.

Sometimes, even after assigning correctly, shortcuts may fail due to incorrect software installation or conflicting settings with other applications. In such cases, restarting computer or reinstalling Excel might be necessary.

Testing your new shortcut key will help ensure its effectiveness before using it. Pay attention to any errors or unexpected events that occur when using your shortcut. This information will help fix settings that could cause conflicts in executing commands.

Testing the Shortcut Key

Do you ever wish to get rid of the bother of repeating duties while working with Excel? Making a shortcut key could be the answer you have been searching for.

In this part, I’ll bring you through the process of testing the shortcut key, this is a very critical step in its formation.

To start off, I will demonstrate how to open a fresh worksheet in Excel 2013.

Later, we’ll observe how to try out the shortcut key combination to carry out a special action.

Lastly, I’ll direct you on how to confirm that your newly made shortcut key is trouble-free and does the wanted function effectively.

Testing the Shortcut Key-How to create a shortcut in Excel 2013,

Image credits: by Harry Arnold

Opening a new worksheet in Excel 2013

Need to open a new worksheet in Excel 2013, but don’t know how? Don’t worry! Here’s what to do:

  1. Step 1: Click the File tab in the top-left corner.
  2. Step 2: Select New from the list on the left.
  3. Step 3: Choose Blank Workbook and click Create. A new workbook will appear!

Did you know that 1 billion people use Microsoft Office Suite programs like Excel? That’s right – Microsoft’s software is everywhere!

Want to try out a shortcut key combination to create a new worksheet? Go for it!

Trying out the shortcut key combination

First steps to mastering Excel 2013? Select the cell or range of cells you wish to format using a keyboard shortcut. To do this, press and hold down the keys “Alt” and “Ctrl” on your keyboard. Then, press the letter or number that corresponds to the command you want to carry out. Finally, release all the keys used.

This is quick, efficient and lets you execute commands much faster than with the menus or ribbon interface. Shortcuts also help reduce repetitive strain injury (RSI) caused by mouse and keyboard overuse. Especially important for those who spend long hours working on spreadsheets.

Practice makes perfect! After some practice, you’ll be able to carry out tasks in no time. I found that learning these shortcuts saved me a lot of time when working on complex spreadsheets with multiple formulas and functions. Switching between operations without having to use menus or toolbars was a breeze.

Don’t forget to confirm that the shortcut executes the desired function. This is an essential part of using shortcuts efficiently in Excel 2013.

Confirming that the shortcut executes the desired function

Open your Excel spreadsheet. Find the cell or range you want to apply the shortcut to. Highlight it. Press the keyboard shortcut you created, e.g. Ctrl + Shift + 1. If done correctly, you’ll see the formatting or action applied. If nothing happens or an error message appears, review and revise your shortcut settings.

Double-check the shortcut before using it regularly. This will save time and avoid mistakes. Ensure the shortcut works as intended for productivity and accuracy. By creating shortcuts, users can make common actions more efficient.

Tip: Microsoft offers free online courses on Excel features, including shortcuts.

Troubleshooting tips:

  • When custom keyboard shortcuts don’t work as planned.


Do you know the frustration of Excel shortcuts not working? I do! In this segment, I’m discussing Excel 2013 for troubleshooting shortcuts, especially when using macros. We’ll look at common problems users face when setting up keyboard shortcuts, plus three sub-topics to resolve conflicts:

  1. Analyzing if a key is already in use
  2. Verifying the connected cell or range
  3. Switching to a different shortcut key combination

Let’s solve some Excel 2013 shortcut mysteries!

Troubleshooting-How to create a shortcut in Excel 2013,

Image credits: by David Arnold

Analyzing if the shortcut key is already in use

Analyzing whether your chosen shortcut key is in use is important when assigning a global-level keyboard shortcut. For this, Forbes stated: “Keyboard shortcuts allow users to access frequently used features faster than using menus with a mouse.”

Follow these steps to analyze if the shortcut key is already in use:

  1. Open the Excel workbook where you want to create the new shortcut.
  2. Click ‘File‘ at the top left side of the screen.
  3. Click ‘Options‘.
  4. Select ‘Customize Ribbon‘ from the ‘Excel Options‘ dialog box.
  5. Click ‘Customize‘ next to ‘Keyboard Shortcuts‘.
  6. In the ‘Categories‘ list, select ‘All Commands‘.

Verifying that the shortcut is connected to the correct cell or range is the next step in creating an efficient workflow for yourself when using Excel.

Verifying that the shortcut is connected to the correct cell or range

Ensure your shortcuts are connected to the right cell or range by following these four steps:

  1. Go to the cell or range you want to connect the shortcut to. You can do this by clicking on it, or by dragging your mouse over a range of cells.
  2. Right-click and select ‘Hyperlink’ from the context menu. This will open a dialog box where you enter your shortcut’s address.
  3. Check the ‘Insert hyperlink’ dialog box matches the cell or range you want your shortcut to link to. Make sure there are no errors.
  4. Click ‘OK’ to create the shortcut. Now when you click the link, you’ll be taken directly to the right cell or range.

It’s essential to check that your shortcuts are connected correctly. If they’re not, you could waste time looking in the wrong areas and make mistakes. For Excel 2013, Microsoft Support recommends giving your shortcuts descriptive names so they’re easy to find and use. Doing this will make your workbooks more efficient.

Switching to a different shortcut key combination to fix any issues.

To fix macro issues, press “Alt + F8” to open the Macro dialog box. Select the offending macro and click “Options“. Change the shortcut key combination in the Options dialog box. Click “OK” to save the changes.

These simple steps can make a big difference in your Excel experience. Check settings, restart your computer, and keep macros up-to-date. Don’t let issues with shortcut keys slow you down! Take these steps to ensure Excel works for all of your needs.

Five Facts About Creating Shortcuts in Excel 2013:

  • ✅ Shortcuts are a quick way to access frequently used commands or functions in Excel 2013 (Source: Microsoft)
  • ✅ To create a shortcut in Excel 2013, you can use the ‘Customize Quick Access Toolbar’ or ‘Keyboard Shortcut’ options in the ‘Options’ menu (Source: Excel Easy)
  • ✅ With the ‘Customize Quick Access Toolbar’ option, you can add any command to the toolbar and assign it a shortcut key (Source: BetterCloud)
  • ✅ Keyboard shortcuts can be created by pressing the ‘Alt’ key and then selecting the desired command with a letter or number key (Source: CNET)
  • ✅ Creating and using shortcuts in Excel 2013 can save time and increase productivity in your work (Source: Excel Campus)

FAQs about How To Create A Shortcut In Excel 2013

How to create a shortcut in Excel 2013?

To create a shortcut in Excel 2013, follow these steps:

  1. Right-click on the file or program for which you want to create a shortcut.
  2. Select “Create Shortcut” from the context menu.
  3. Drag the newly created shortcut to the desktop or the desired location.
  4. Right-click on the shortcut and select “Properties.”
  5. Enter a name for the shortcut, and click “OK.”