![]() ![]() Ken Puls, who is the king of Power Query, says, “You would think my favorite Excel tip would be Unpivot with Power Query, but my favorite all-time is Ctrl+Enter.” Say that you want to enter a formula into 400 cells. Thanks to to Copy Formula into Entire Selection But my muscle memory still prefers tip #2. It is really superior in every way to keyboard tip #2. If I could slow down enough to stop pressing Ctrl+Shift+Down Arrow followed by Ctrl+Shift+Right Arrow, I would realize that Ctrl+* is much shorter and does not get tripped up by blank cells. This one is easier if you have a number keypad so you don’t have to press Shift to get to an asterisk. Why 5? If you are making hash marks, the fifth hash mark crosses out the first four. This is great for crossing things off your to-do list. Thanks to Crystal Long, and Steve McCready. From the bottom-right corner, press Ctrl+. If the selection is rectangular, you move in a clockwise fashion. ![]() to move to the next corner of the selection. While you have a large range selected, press Ctrl+. Thanks to Captain Excel, José de Diego, Mike Girvin, Elchin Khalilov, Crystal Long, Paul Sasur, and to Jump to Next Corner If it seems awkward at first, try it for a few days until you get the hang of it. While still holding down Ctrl+Shift, press the Right Arrow Key to select A1:K545. Starting from A1 in the above figure, press Ctrl+Shift+Down Arrow to select A1:A545. Ctrl+Right Arrow will jump the gap of empty cells and land on N1.Īdd the Shift key in order to select from the active cell to the landing cell. In the following figure, Ctrl+Down Arrow will jump to K545. If you have a column with no blanks, press Ctrl+Down Arrow to jump to the end of the data set. Your cell pointer is sitting at the top of 50K rows of data, and you need to get to the bottom. Thanks to Mitja Bezenšek, Alexa Gardner, Andrej Lapajne, Schmuel Oluwa, Jon Peltier, and to Navigate or Select Whether it is a cell, SmartArt, a picture, a shape, or the March data point in a column chart, press Ctrl+1. After the first eight or so, they are then sorted by my subjective sequence.Ĭtrl+1 (the number one) works to format whatever is selected. If a lot of readers suggested a tip, it is at the top. As I started polling readers about their favorite Excel tips, a large number of them were keyboard shortcuts.įollowing keyboard shortcuts are presented in order of popularity. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |