This is an incredibly easy and simple tip and an Excel navigation shortcut that I quite honestly had no idea existed until just recently. I’ve always used Ctrl + left/right/down/up arrow to quickly get to the top/bottom of my current columns or start/end of my current row. That being said this tip is great if you are a heavy mouse user and just love to click things- so here it is. When you are on any cell, you can double click the top/left/bottom/right of your cell to get literally to the beginning or end of that row or column. You need to make sure that you have the 4 point cursor available when hovering over either of the sides of your cell. Here is a quick gif image to show you how this works. Note that the image below is only showing you how to navigate from top to bottom (and from bottom to top) of a column but you can you with the left or right hand sides of the cell to go to the beginning of the row or to the end of the row.
I hope you enjoy this tip as much as I did and I already forget where I came across this but it could be a life changer for some of you and I hope it is.
I know, I know. I am starting to get lazy and I haven’t really done any full length posts but these image posts will at least give you some quick pointers. That being said this is just another visual lesson on how you can use Excel Sparklines with the merging tool to make large charts that represent your data. (more…)
Alright so the Alt key may not allow you to access everything that Excel has to offer but pretty darn close. You’ll see below that you can use the Alt Excel Shortcut key to quickly access any of the functionality that is available in the ribbon. (more…)
Happy Monday everyone! This is another very quick post about how you can use some of Excel’s awesome functionality. In this post I want to show how to use Excel custom number formatting to format a range of numbers into thousands (k). Simply follow the steps below and you’ll be right on your way. If you have any questions, feel free to leave a comment. (more…)
I decided to do another short post to save you some time. This image/post takes a look at how to setup the camera tool and then how you can use it on a separate worksheet to begin the setup of a new dashboard. The Excel Camera Tool allows you to take an image of a range of cells and create a picture/object out of it. Once that picture is created, it will automatically continue to refer to the cells that the image was taken of and will update as the cells change. Feel free to leave any questions in the comments. (more…)
This is just another quick and simple shortcut that you can use to make your life a little bit easier. Use Alt + = to automatically add/sum a range of cells.
