HomeApplicationOffice information

Assign shortcuts to icons in Excel 2013

You can assign keyboard shortcuts to icons in Excel 2013 by using the AutoCorrect feature.

In addition to assigning keyboard shortcuts to icons in Word 2013 , you can also assign shortcuts to the Excel 2013 icon, but not directly.

Here's how to use the AutoCorrect feature in Excel to create an easy-to-remember shortcut for an icon.

When you click ' Symbol' in the 'Symbols' section of the ' Insert' tab , you will see that there is no downward-pointing arrow that shows a drop-down menu as in Word.

Assign shortcuts to icons in Excel 2013 Picture 1

Also, there is no 'Shortcut Key' button in the 'Symbol' dialog box .

Assign shortcuts to icons in Excel 2013 Picture 2

Even when you right-click on a tab in the Ribbon and select 'Customize the Ribbon' , on the menu that appears .

Assign shortcuts to icons in Excel 2013 Picture 3

. there is no ' Customize' button under the list of commands on the left side of the ' Options' dialog box :

Assign shortcuts to icons in Excel 2013 Picture 4

To fix this limitation in Excel and assign a shortcut to an icon, place the cursor in a cell and use the 'Symbol' button in the 'Symbols' section of the Insert tab to select and insert an icon, for example. like pound icon.

Note: Inserting an icon in Excel is not the same as in Word.

Select the icon in the box and right-click, select 'copy'.

Assign shortcuts to icons in Excel 2013 Picture 5

Press the FILE tab .

Assign shortcuts to icons in Excel 2013 Picture 6

Click on 'Options' in the list on the left side of the 'Info' screen .

Assign shortcuts to icons in Excel 2013 Picture 7

On the "Excel Options " dialog box, click on ' Proofing' on the left.

Assign shortcuts to icons in Excel 2013 Picture 8

On the ' Proofing' screen , click the 'AutoCorrect Options' button .

Assign shortcuts to icons in Excel 2013 Picture 9

The 'AutoCorrect' tab of the 'AutoCorrect' dialog box is set up with a default list of misspellings and symbols that will be automatically edited or inserted when you type in misspelled words or sets of characters related to that symbol.

This list can be edited, so use it to enter easy-to-remember (but not meaningful) abbreviations that represent the symbols you often use.

For example, in this example, enter 'BP' into the edit box under ' Replace' and paste the pound table into the edit box under 'With' , click 'Add' to add this folder to the list. .

Assign shortcuts to icons in Excel 2013 Picture 10

Click 'OK' to close the 'AutoCorrect ' dialog box and click ' OK ' again to close the ' Excel Options' dialog box .

Now, whenever you want to insert a pound icon into a cell, type 'BP' and a space, the pound icon will automatically be inserted.

Assign shortcuts to icons in Excel 2013 Picture 11

Repeat the same steps to insert the abbreviation as a shortcut for other icons.

4.7 ★ | 3 Vote
Microsoft Excel 2013AutoCorrecthow to use iconshow to insert iconshow to insert shortcutshow to create shortcutstips for Excel 2013how to use Excel 2013

You should read it

May be interested

  • How to assign keyboard shortcuts to touch mouse gestures on Windows 10How to assign keyboard shortcuts to touch mouse gestures on Windows 10
    recent laptops have been equipped with a high-precision touchpad, so you can use gestures instead of shortcuts in windows 10 if you own a computer like that. among many options, you can customize gestures, connect keyboard shortcuts with swipe or touch gestures in windows 10.
  • List of common shortcuts for Google Sheets on Chrome OS (Part 3)List of common shortcuts for Google Sheets on Chrome OS (Part 3)
    google sheets consists of worksheets, each sheet consists of multiple cells created by rows and columns, the toolbar supports basic tools such as formatting sheets, cells, text, inserting charts, images, ... .
  • Summary of useful keyboard shortcuts in excelSummary of useful keyboard shortcuts in excel
    tips make would like to share with you the accounting, office summarizing the shortcuts in excel 2007, 2010 which are very useful as follows
  • 70+ Most Useful Excel Shortcuts You Should Know70+ Most Useful Excel Shortcuts You Should Know
    shortcuts play an extremely important role in optimizing your time. let's learn useful shortcuts in excel to work effectively with hoang ha pc.
  • How to use icons in Microsoft Word 2013How to use icons in Microsoft Word 2013
    microsoft word provides hundreds of icons that are not on the keyboard for you to insert into the document. for example, you can insert decimals (½), degree symbol (°), pi (π), or currency symbols, such as pounds (£). there are many symbols and characters for each font set.
  • Summary keyboard shortcuts in ExcelSummary keyboard shortcuts in Excel
    summary keyboard shortcuts in excel. summing is one of the many calculations available in excel and it will serve a great deal in statistical accounting. sometimes you need to work with a lot of calculations so using keyboard shortcuts will save a lot of working time.
  • 38 Excel keyboard shortcuts, Work with Excel faster38 Excel keyboard shortcuts, Work with Excel faster
    many users find that using an external keyboard with keyboard shortcuts for excel helps them work more efficiently.
  • Shortcuts in Word need to knowShortcuts in Word need to know
    shortcuts in word need to know. word always gives users more than one way to accomplish the purpose of editing, you can use the mouse to click select icons in the toolbar or more quickly use shortcuts.
  • Invaluable keyboard shortcuts in ExcelInvaluable keyboard shortcuts in Excel
    the use of shortcuts helps you accelerate your work many times. the following article introduces the most commonly used keyboard shortcuts in excel.
  • Coloring shortcuts in ExcelColoring shortcuts in Excel
    coloring shortcuts in excel. in this article, dexterity software will introduce readers to coloring shortcuts in excel.

Office information