Borders are generally a good idea to use if you want to organize your worksheet and make it appear more professional. Instead of navigating through endless menus, use this Excel shortcut to quickly add borders to the cells you have selected. CTRL + Shift + &: Applies border to cells This shortcut expands or collapses the formula bar, a useful tool when you're moving about a variety of workspaces and inspecting cells. Ctrl + Shift + U: Expand or collapse the formula bar Source: Isriya Paeireepairit/Flickr It will apply to multiple cells as well, if you have them selected. If you quickly want to change a cell to the currency format, you can select it and hit this shortcut. CTRL + Shift + $: Applies the currency format to the selected cells Then press these keystrokes and the insert hyperlink box appears, making the process that much easier. CTRL + K: Insert a hyperlinkįirst, you need to select where you want a hyperlink to appear. This shortcut quickly gives you access to the default date format. CTRL + Shift + #: Change date format with the day, month, and year To recap, here are all of the shortcuts we just covered.This shortcut really is a lifesaver. 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.
CHANGE EXCEL KEYBOARD SHORTCUTS HOW TO
Hybrid Excel Chart Shortcuts: How To Format, Select Data and Modify Fonts
0 kommentar(er)
