![]() ![]() 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. |