Move active cell down in selection

In this video, we’ll cover shortcuts for working with the active cell. As I mentioned earlier, every worksheet has an “active cell”, which you can see displayed in the name box. When the active cell is off-screen, you can scroll it into view, without actually changing the active cell, using Control …

In this video, we’ll look at some examples of formatting axis labels. Here we have a simple set of generic shipping data. We have a date, quantity, and a field to indicate batch number. Let me insert a standard column chart, and let’s run through some options in adjusting the labels that appear in …

In this video I’ll show you a way to quickly add missing data to a worksheet. It’s a simple technique using a very basic formula, and it’s a beautiful example of the power of relative cell references. Sometimes you get a set of data that isn’t complete because it’s been organized like an outline, …

In this video, we’ll look at options for customizing a value axis in an Excel chart. Here we have historical data showing average 30 year mortgage rates over a 5 year period. When I create a line chart, the vertical axis is a value axis showing the mortgage rate, and the horizontal axis is a …