Drag and copy Ctrl+drag Drag and insert Shift+drag Drag and insert copy Ctrl+Shift+drag Drag to duplicate worksheet Ctrl+drag Drag to worksheet Alt+dragExcel Shortcut Keys for Navigation Go back to hyperlink Ctrl+G+Enter Move one cell down ↓ Move one cell left ← Move one cell right →...
Read More: How to Create a Table Without Data in Excel Method 3 – Shortcut Key to Create Pivot Table ➤ Select the entire data and press, ALT+N+V+T It will open the PivotTable from table or range window. ➤ Select Existing worksheet. You can select a New worksheet if you want...
How to Add a Line Break in Excel with Formula Combine Ampersand (&) Operator and CHAR Function to Add a New Line While Joining Cells Insert the following formula in cellE5>> press theEnterkey >> drag down theFill Handleicon >> double-click on the row bars to adjust row heights. =B5&...
So, in the new technique, we need to hold theCtrlkey and drag the worksheet to the right side. While dragging, we may see a small "PLUS" icon appear. The moment we place our cursor outside the sheet, release the "Ctrl" key and release mouse holding. It will create a new worksheet....
The rows can be selected in either of the following ways: Select cell A6. Hold the “Shift” key and press the down arrow to select the cells A6 to A10. Press “Shift+spacebar” to select rows 6, 7, 8, 9, and 10 in one go. Press and drag the left button of the mouse on ...
WINKEY + F1 Display the Microsoft Windows help. WINKEY + R Open the run window. WINKEY + Pause / Break key Open the system properties window. WINKEY + U Open Utility Manager. WINKEY + L Lock the computer (Windows XP and above only). EXCEL SHORTCUT KEYS ...
Ctrl + R Aligns the Line or Selected Text to the Right of the Screen. Ctrl a Ctrl M Ctrl+h in Ms Word Ctrl+q in Ms Word Ctrl+t in Excel Ctrl+t in Ms Word Ctrl+t Shortcut Key Download Computer Notes Edudelight Lesson Note for Primary 5 ...
Jump to slide in presentation mode: During the presentation, the user can jump to a specific slide without having to exit the presentation or use the up and down key by using the PowerPoint shortcut keys. This is useful if the slide is far from the current slide and if the user knows ...
If you have the function key enabled, you may have to hold the function key and then press the F4 key to change the cell reference. Alternate Ways to Absolute Reference in Excel: By default, whenever you’re writing a formula, and you select a cell using the cursor, it will pick up ...
If you’re an Excel user who prefers working with the keyboard to the mouse, this method is for you. Plus, it’s always cool to know the shortcut It involves pressing two keys: theAlt keyand theEqual sign(“Alt” + “=”).