Why? Because I’m a big fan of keeping my right hand on the mouse when I’m in Excel (vs. I’ve highlighted only those hot keys that you can type with your left hand. įiled Under: Alt Shortcuts, Delete, Excel Shortcuts, Hybrid shortcuts, Keyboard Shortcuts, Mouse Shortcuts, Right Click Tagged With: Alt Shortcuts, Excel Keyboard Shortcuts, Excel Mouse Shortcuts, Excel Shortcuts Excel Pivot Table Shortcutsīelow I’ve highlighted some hot keys that pop up when you right click on an Excel pivot table. This is the fastest (typing ‘D’ is faster than clicking on ‘Delete’). I call this a “ hybrid” shortcut since it combines mouse and keyboard into one shortcut. The ‘D’ is underlined in Delete, which means you can just type ‘D’ instead of clicking on Delete. This does the same thing as RC-, except you’re using the hot key instead of clicking. (2) Hybrid shortcut: RC-D (Right-Click, followed by typing ‘D’). You’ll see the following when right-clicking over the tab - just click on Delete: (1) Right-clicking: RC- while hovering over the tab. The second one is the fastest, and hence my favorite. For example, to do Paste Special in this situation, I’ll do a MK-N (menu-key-N).įiled Under: Excel Shortcuts, Paste Special, Paste Values, Right Click Tagged With: Hybrid Shortcuts, Paste Special, Paste Values 4 Shortcuts To Delete Excel Worksheetsīelow are four different shortcuts to delete Excel worksheets. If my right hand DOES happen to be on the keyboard already, then I’ll do a BB (everything with the keyboard). That would make me an AA in that situation (doing everything with the mouse) in this case. I call this a “ hybrid shortcut” since it uses both the mouse and the keyboard.īut I won’t do a RC-N for Paste Links - I find it faster to just click on the Paste Link icon. For example, I’ll do a RC-V (right-click-V) to Paste Values. I find it faster to click on an option than move my right hand off the mouse, onto the keyboard to type it, and then back to the mouse. Why? I prefer keeping my right hand on the mouse as much as possible. I strive to be an AB (I right click to bring up the menu, then click on the hot key to choose the option).īut that’s only when the hot key is on the left side of the keyboard. (B) With the keyboard (by typing the hot key) (2) How do you select your Excel Paste Special option?
(B) With the keyboard (with the menu key)? (1) How do you bring up the Excel Paste Special menu(s)? How often do you need to use Format Painter? What program do you most often use it in? Is it Word, PowerPoint, or maybe Excel? Tell us more in the comments section below.How do you Paste Special in Excel? Leave a comment!Īre you an AA, AB, BA or BA? See the questions below. And the shortcuts are as simple as they can be – Ctrl + Shift + C and Ctrl + Shift + V. Paint the Final Paragraph Formatįormat Painter tool is a real lifesaver, especially when you need to edit large documents to achieve uniformity. Plus, a double click on Format Painter also works as a lock, like in Excel or Word. And again, you can just keep pasting to all the target objects without repeating the second step. Step 3Īll you need to do now is select the target object or piece of text and hit Ctrl + Shift + V. This applies to all the programs that feature the tool. Note: The cursor changes to paintbrush when you hit the shortcut or click Format Painter. Of course, you can also click on the Format Painter tool in the Home tab. Once your source object or text is highlighted, press Ctrl + Shift + C to copy the entire formatting. The tool and shortcut work for any object and text in PowerPoint documents. Select the object or piece of text you want to copy. Here is the quick rundown of the steps: Step 1 In other words, you can copy/paste the format in PowerPoint by using Ctrl + Shift + C and Ctrl + Shift + V. The best thing about it is that the same basic principles and shortcuts apply for most programs, with the exception of Excel. PowerPointĪs indicated, the Format Painter tool is available across the entire Microsoft Office suite. It best performs for native objects from AutoShapes, but you can also paste an image format – for example, the borders that come with an image.
Of course, this only applies unless you copy something else within a Word document.įormat Painter and the shortcut work for Word graphics as well. After pressing Ctrl + Shift + C, you just need to select the desired destinations and press Ctrl + Shift + V as many times as you want. In a way, you can save the preferred formatting. Remember, it copies all the formatting (should you select a whole paragraph), as well as other actions. The Format Painter shortcut in Word is more powerful than the tool itself.
0 kommentar(er)
