Excel - Add Replace Shortcut How To Use AutoCorrect

To fill more than one cell, select the source cell and press CtrlShiftDown to select multiple cells.

Then press CtrlD to fill them with the contents of the original cell.

To fill more than one cell, select the source cell and press CtrlShiftRight to select multiple cells.

Then press CtrlR to fill them with the contents of the original cell.

For example, if you changed the color of text in another cell, pressing F4 changes the text in cell to the same color.

Hereafter, whenever you type 143 and press space, Word will automatically convert it into I Love You.

For example AltHW use to wrap the text in the cell column of Excel on PC, AltHBA will put a border on all sides of the cell.

In the same way I can use all commands of Excel without even touching my mouse.

AutoCorrect is one such feature we use every day without making much use of it.

Excel - Add Replace Shortcut How To Use AutoCorrect

In this article, let us explain how to use AutoCorrect and Math AutoCorrect and create custom AutoCorrect shortcut.

What is AutoCorrect As the name indicates, AutoCorrect helps to automatically correct the typed text into different text based on the settings.

Office has huge list of pre-defined words to automatically replace with the other words.

AutoFormat and Math AutoCorrect AutoFormat and Math AutoCorrect are similar to AutoCorrect functions used for different purposes.

You can type a hyphen (minus) sign and press enter to see, it is converted into a bulleted list.

You will see a lightning arrow when Office applications use AutoFormat option.

Click on that to revert to the original text or simply Control Z to undo.

When you are creating equations with Equation Editor, type degc to convert it into Degree Celsius symbol like.

Though Math AutoCorrect works inside the Equation Editor, you can also enable it to work on the normal text area similar to AutoCorrect options.

For both AutoCorrect and Math AutoCorrect, Office will show you small bar.

Checking AutoCorrect Shortcuts in Office Windows All Office applications like Word, Excel, Outlook and PowerPoint has AutoCorrect feature.

For Outlook, go to File Options Mail Editor Options Proofing AutoCorrect Options.

This will open AutoCorrect settings dialog box and check under AutoCorrect tab.

Here you can see the complete list of pre-defined shortcuts under Replace text as you type section.

Enable this option, if it is not enabled on your application.

Remember, you should enable AutoCorrect in each application like Word, Excel, Outlook and PowerPoint separately.

Related: How to use AutoRecover in Office Word Creating Custom AutoCorrect Shortcut Besides the existing shortcuts, you can create custom keyboard shortcuts if you use some terms frequently.

Let us take an example that you want to replace the text 143 with I Love You in Word.

In this case, enter 143 in the Replace text box and type I Love You in with text box.

Click Add button and press OK to close all open dialog boxes.

Excel For Mac- Add Replace Shortcut