Just learn the basics that we just covered, and you’re good to go. They can save you time in virtually any context. Hybrid shortcuts are a great tool for your shortcut arsenal. Once you grasp how these hybrid or mutant shortcuts work, you can apply the principles to any context menu.īecause you are so nice, I’ll now share three of my favorites:įormat Cells Dialog Box: RC-F (if you’re not selecting any kind of special object like a chart or a pivot table, for example) I call them lefties because only the left hand needs to be on the keyboard. Note: Since the Spacebar can be tapped with the left hand, all of the shortcuts above qualify as lazy bum shortcuts.
Just right-click and then type F.įormat Chart Element: RC-F (when no other menu option has F as its hot key) Why? Because Format is the only option with F as its hot key. The Format shortcut is straightforward in the two menus on the right-hand side. If there were three options using F for the hot key, you would just keep rotating through the three options until you finally hit Spacebar to select one of them. If you just keep typing F, and never hit Spacebar, you’ll just go back and forth between Font and Format. You have to type F twice, then Spacebar, to choose Format:įormat Chart Element: RC-F-F-Spacebar (when Font appears on the menu) If you just did RC-F-F you’d be stuck on the Format line - just like you get stuck on the Font line if you just do RC-F. So how do you move down to the Format option? Hitting the Spacebar is the equivalent of hitting Enter, or OK, or clicking on the option with your mouse. To choose the Font option, you must then hit the Spacebar. Here’s what it looks like if you just type RC-F and stop: You stop at Font (and not Format) because Font is the first option with F as its hot key. So if you right-click and then type F, nothing happens. In the five menus on the left (above), F is the hot key for both Font and Format… Select Chart Data: RC-E (works in all menus above) So if RC stands for right-click, then here is the shortcut: So no matter where you are, you can just right-click and type E to get the Select Data dialog box. I’ve explained this in the graphic below - but maybe more clearly with my prose below it.Ībove, no matter where you right-click on a chart, there is only one underlined E. No, sir.ĭepending whether you want the first or section option using that hot key, you either have to hit the Spacebar to complete the selection - or tap the hot key a second time, and then hit the Spacebar. When that happens you can’t just right-click and then type the letter. Here it is: sometimes the same hot key is underlined twice in the same menu. So here are four such lazy bum shortcuts - one for each of the man-beast mutants.īelow are some context menus you get when right-clicking on different parts of a chart. I Give You Four Lazy Excel Chart Shortcuts My left hand stays on the left side of the keyboard and my right hand stays on the mouse. My favorite hybrid shortcuts involve virtually no extra motion from my hands. If they were animals, they might be half-man, half-beast. I call these shortcuts “hybrid” shortcuts because they’re part keyboard shortcut, part mouse shortcut. They work by simply typing the underlined hot key for a menu option - rather than clicking on it. Context menus give you a sort of hidden shortcut option I call “hybrid” shortcuts. When you right click on a Chart (or in any other context), you typically get a “context menu” that looks something like the ones further down the screen.
#Excel keyboard shortcuts format how to
Hybrid Excel Chart Shortcuts: How To Format, Select Data and Modify Fonts
0 kommentar(er)
