Category: Excel Shortcuts

The shortcut Ctrl+N is to create a new workbook. It is very helpful when you need to open a new workbook especially when you have many open windows. You …

The shortcut Ctrl+H will display "Find and Replace" dialog box, and you can replace the information from here. The default window is the "Replace" window. To open the dialog …

The shortcut Ctrl+G is to display the "Go to" dialog box. Step 1: Click any cell in the worksheet; Step 2: Press and hold the Ctrl key, then press …

The shortcut Ctrl+F3 is to display the "Name Manager" dialog box to define name. Step 1: Click any cell in the worksheet; Step 2: Press and hold the Ctrl …

The shortcut Ctrl+F12 is to display the File Open dialog box. Step 1: Click any cell in the worksheet; Step 2: Press and hold the Ctrl key, then press …

The shortcut Ctrl+F11 is to inset a new Macro sheet in the current working workbook. Step 1: Click any cell in the worksheet; Step 2: Press and hold the …