About This Shortcut Insert embedded chart – It makes an embedded chart from the data in the current range. Keybord shortcut key: Window: Alt + F1 Mac: Fn + Alt + F1 Note: The shortcut key will work with function key [Fn] if you are using laptop like Dell, or other companies laptop etc. Example: […]
Excel Shortcut: Insert Embedded Chart Read Post »
About This Shortcut Find the next match (after initial Find) – If you have the Find and Replace Window open and enter some criteria (values, formatting, etc.), Shift+F4 will utilize those criteria to locate the next cell that meets those requirements. Keybord shortcut key: Window: Shift+F4 Mac: cmd+G Example:
Excel Shortcut: Find Next Match Read Post »
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 »