Extend selection by one cell down

In this video, we’re going to build on the technique we covered in an earlier video, where we added in missing data using formulas. Here again we have a music collection with some missing data. The twist, in this case, is that the Artist isn’t in the right column. Instead of column B, it appears in …

Excel has many useful shortcuts for selecting cells. This includes shortcuts for selecting rows, columns, groups of cells, and even the entire worksheet. Let’s take a look. When you’re selecting individual cells, you can use the arrow keys to move the selection around. If you hold down the shift key …

In this video, we’ll cover shortcuts for extending selections to include more cells. The most basic way to extend a selection is to use the shift key + any arrow key. From a single cell, this lets you add additional cells in any direction. If you begin with a larger selection, shift will let you …