Hello there.
I'm Michael. Welcome, everyone. You know that in Excel having the shortcut to access the "FIND and REPLACE" function.
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:
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
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:
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?
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 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
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
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:
Awesome article…..truly appreciated. We have an amazing tool, You can try this out Find and Replace in Excel tool which help you to find and replace multiple words in multiples excel files . Thanks
ReplyDeleteGlad to hear that. Thanks.
DeleteHow can we use CTRL H when there are locked cells in the file? Thanks
ReplyDelete