/en/excel2007/creating-simple-formulas/content/
It is important to know how to move information from one cell to another in Excel. Learning the various ways will save you time and make working with Excel easier. Certain methods are more appropriate, depending on how much information you need to move and where it will reside on the spreadsheet. In this lesson, you will learn how to cut, copy, and paste, as well as how to drag and drop information.
Download the example to work along with the video.
To select more than one adjoining cell, left-click one of the cells, drag the cursor until all of the cells are selected, and release the mouse button.
The copied cell will stay selected until you perform your next task, or you can double-click the cell to deselect it.
The keyboard shortcut for Paste is the Control Key and the V key.
The fill handle doesn't always copy information from one cell directly into another cell. Depending on the data entered in the cell, it may fill the data in other ways. For example, if you have the formula =A1+B1 in cell C1 and use the fill handle to fill the formula into cell C2, the formula doesn't appear the same in C2 as it does in C1. Instead of =A1+B1, you will see =A2+B2.
You can use the fill handle to fill cells horizontally or vertically.
Use the Budget workbook or any Excel workbook you choose to complete this challenge.
/en/excel2007/printing-workbooks/content/
About cookies on this site
Sharing your cookies helps us improve the site, optimize your experience, and understand the extent of our impact. By closing this banner, you agree to the use of cookies on this website (This option applies to users outside the United States and Europe). Learn more about how we use cookies by clicking on Cookie Settings.