Ctrl+H Shortcut Excel Keyboard Key "FIND and REPLACE" | Exceltip2day

Hello there.

I'm Michael. Welcome, everyone. You know that in Excel having the shortcut to access the "FIND and REPLACE" function.

Tip Quiz

What is the shortcut to Redo Last Action (Multiple Levels) Excel?

My article consists of 2 parts. In the first part, I'll describe the "Step by step shortcut method". I'll show you the figure of how the "Find and Replace" work.

This function is very similar to the "FIND" function. They are both in the same order dialog menu box. But this "Ctrl+H" keyboard key Excel shortcut is for calling out the "Find and Replace" dialog menu box instantly.

Let's start with the 1st part;


Step by step shortcut method:

• Press "Ctrl" key and hold it on.

• Press "H" key button on your keyboard.

Then, the "Find and Replace" dialog box will appear instantly on your current worksheet.

• Then just type whatever you want to REPLACE into the "Replace" blank space and don't forget to fill out data which is being replaced into the "Find" blank space too.

• Press the "Replace" button to get the outcome which is the new data entered (text/numbers...) will replace the unwanted data one by one cell. In case if you want to replace them all, the whole worksheet, just click on the "Replace All"

Now, I move on to the 2nd part; the how the "Find and Replace" dialog menu box looks like.

Shortcut for: To find the unwanted data and replace with the other information in your "Excel" worksheet.

Windows shortcut

CtrlH

This figure brought out by press "Ctrl" & "H" in Excel

That brings me to the end of my posting.

I really hope my today's post I have shared with you all will help you to work on your Excel office more easier.

Thank you for your kind attention to my posting about shortcut key button to call out the "FIND and REPLACE" box.

Tip Answer

 a. It's the set of keys Ctrl+Y buttons.

 b. It's the set of keys Ctrl+C buttons.

 c. It's the set of keys Ctrl+A buttons.

 Answer: a. Wow! you made it. 

Source: To Redo Last Action (Multiple Levels) Excel Shortcut

Link recommended👉 : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'
Link recommended👉 : English Numbers In Words 1 to 1000000

Before I am about to say goodbye to you, I hope that what I have posted and shared with you today. They will be beneficial for you, your company, and any relevant.

If you love it, I will be happy. If you share this with your friends, I will be shiny.

I hope to receive any feedback from you guys. Because they will be such treasures--any error in this blog--for future improvement.

Thanks for reading.

Bye,

Posted by: Michael Leng



I've known, then I've grown.
See more articles:

• [Ctrl + F] "Find" Shortcut Excel and Keyboard Key Tip | Exceltip2day
• [Ctrl] + [F10] Shortcut Excel To Maximize/Restore The Selected Workbook Window
• [Ctrl] + [F9] Shortcut Excel To Minimize The Current Entire Workbook Window(s)