If you want to fill the cells with a series, you can instead select Fill Series. Once you let the mouse button go, the cells you have dragged over are automatically filled, by default, with the value in the first cell ( Copy Cells). You can then hold down the mouse button and drag this cross either down the required number of rows, or across the required number of columns. When you rest your mouse on the fill handle, your mouse pointer will change to a small black cross.
If you click in the bottom right-hand corner of the cell, you will see the fill handle. If you click on the fill handle and drag your mouse either down some rows or across some columns, when you let go of the mouse button (drop the cursor), the cells you have dragged over are automatically filled with relevant data. When you select a cell in Excel, the bottom right-hand corner of the cell contains a small square. It is an alternative to using cut and paste. This tutorial will demonstrate how to drag and drop cells in Excel and Google Sheets.ĭrag and drop is a way to copy or move data in Excel using the mouse.
0 kommentar(er)
