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. |