DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Ctrl+F
|
|
|
Ctrl+G
|
|
|
Ctrl+H
|
|
|
Ctrl+R
|
Detailed explanation-1: -Use the shortcut Ctrl+H or navigate to Home > Editing > Replace to reach the Find and Replace dialog box.
Detailed explanation-2: -When using the CTRL+H keyboard shortcut or the Replace button on the ribbon, the Find and Replace dialog box displays the Find tab instead of the Replace tab.
Detailed explanation-3: -Ctrl + F-This shortcut will open the Find and Replace dialog box. You can use this shortcut to find specific data in your worksheet or to replace data with something else. 2. Ctrl + H-This shortcut will also open the Find and Replace dialog box.
Detailed explanation-4: -To replace text or numbers, press Ctrl+H, or go to Home > Editing > Find & Select > Replace.
Detailed explanation-5: -Need to find or replace a specific piece of data? Press Ctrl + F to display the Find and Replace dialog box with Find selected; press Ctrl + H to display it with Replace selected.