Cut selected cells

In this video, we’ll look at shortcuts for the operations Cut, Copy, and Paste, and related Drag and Drop commands. To copy cells to the clipboard, use the shortcut Control + C on Windows, and Command C on the Mac. To paste, use Control + V on Windows and Command + V on the Mac. Note that when …

In this lesson, we’ll look at how to move data from one place to another in Excel. The most common way to move information is to use cut and paste. We’ll cover three options: using buttons on the ribbon, using keyboard shortcuts, and using the right-click menu. Let’s take a look. The most basic way …

Hey, Dave here from Exceljet. So, in these last couple of videos, I’ve given you a short introduction to the power of pivot tables. In the first video, I talked about how fast they are. And how you can, using pivot tables, build reports way faster than even an advanced user building the same reports …

When you copy and paste formulas, Excel will change all relative references to reflect the new location of the formula. Usually, this is exactly what you want. However, there are times when you’ll want to copy a formula exactly so that cell references don’t change. Let’s take a look at a few ways to …

In this video we look at a few reasons why VLOOKUP is a better option than nested IF statements. In our last video, we used nested IF statements to calculate a commission rate based on a sales number. As a quick recap: The first formula is created with nested IF statements normally. The second …