![]() ![]() 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. Hybrid Excel Chart Shortcuts: How To Format, Select Data and Modify Fonts ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |