About This Shortcut Find the previous match (after initial Find) – Ctrl+Shift+F4 reverses the Find to get the preceding cell. This way, you don’t have to repeatedly return to the Find Window to get to each matched cell. Keybord shortcut key: Window: Ctrl+Shift+F4 Mac: cmd+Shift+G Example:
Excel Shortcut: Find Previous Match Read Post »
About This Shortcut Display find and replace with Replace tab selected – Ctrl + H brings up the search and replace Window, where you can look for specific text and change it to something else. Keybord shortcut key: Window: Ctrl + H Mac: Ctrl+H Example:
Excel Shortcut: Find and Replace with Replace Selected Read Post »
About This Shortcut Display find and replace with Find tab selected – Ctrl + F is a keyboard shortcut that is useful to open a find box and look for a specific character, word, or phrase in a document or web page. Keybord shortcut key: Window: Ctrl + F Mac: cmd+F Example:
Excel Shortcut: Find and Replace Read Post »
About This Shortcut Display the Paste Special dialogue box – In Microsoft Office, pressing Ctrl + Alt + V activates the Paste Special dialogue box. A dialogue box appears from which you can select the method by which the clipboard’s contents will be pasted. Formats that are available for selection include plain text as well
Excel Shortcut: Paste Special Read Post »
About This Shortcut Paste content from the clipboard – Ctrl + V is a keyboard shortcut that is useful for pasting text or other items from the clipboard. Keybord shortcut key: Window: Ctrl + V Mac: Ctrl + V also work for Mac Example:
Excel Shortcut: Paste Content Read Post »
About This Shortcut Cut selection – The standard keyboard shortcut for cutting a selected piece of text, image, or another item is Ctrl + X. Keybord shortcut key: Window: Ctrl + X Mac: Ctrl + X also work for Mac Example: Ctrl X selects the cell to be cut in the following image.
Excel Shortcut: Cut Selection Read Post »
About This Shortcut Repeat last action – Excel has a built-in keyboard shortcut, F4, that allows you to perform the most recently used operation or command again. Changes can be made to the layout, rows, and shapes. Keybord shortcut key: Window: F4 Mac: cmd+Y Note: The shortcut key will work with function key [Fn] if you
Excel Shortcut: Repeat Last Action Read Post »
About This Shortcut Copy selection – In a graphical user interface, Ctrl + C is a keyboard shortcut used to copy text or other objects that have been highlighted to the clipboard. Keybord shortcut key: Window: Ctrl + C Mac: Ctrl + C also work for Mac Example:
Excel Shortcut: Copy Selection Read Post »
About This Shortcut Redo – the last action- Ctrl +Y is useful for redoing an undone action. Keybord shortcut key: Window: Ctrl + Y Mac: cmd + Y Example: If you use the undo command (Ctrl + Z) and discover that you didn’t make a mistake, you can use the redo command (Ctrl + Y).
Excel Shortcut: Redo Read Post »
About This Shortcut Undo – Ctrl + Z undoes the previous activity. A multi-step process can be undone. Keybord shortcut key: Window: Ctrl + Z Mac: cmd + Z Example: Suppose you have made any mistake in Excel; you can undo the action by tapping Ctrl + Z. Lets’ say the last record you entered
Excel Shortcut: Undo Read Post »
