Select entire row

In this video, we’ll look at how to work with rows and columns to structure data in an Excel Table. Tables offer special features for working with data. Once you have a table defined, it is much easier to select and rearrange data in rows and columns. There are several ways you can add and remove …

In this video, we’ll look at how to set up a running total in an Excel table. Setting up a running total in an Excel table is a little tricky because it’s not obvious how to use structured references. This is because structured references provide a notation for current row, but not for first row 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 some really useful shortcuts for selecting cells. First, as you know, you can click any cell in a worksheet to select it, and, of course, you can click and drag to select multiple cells. By adding the Control key in windows, or the Command key on a Mac, you can make more …