To delete a row, right-click on the row number, and click Delete. Press F4 to continue inserting additional rows. Excel always inserts the row ABOVE the row that was clicked on. To insert a new row in a spreadsheet, right-click on a row number, and click Insert. To remove the animated border around the original cell, press the ESC key, or start typing in a new cell. Then highlight the same size cell range in the new location and Paste.Īlternately, depending on the worksheet design, after copying you may be able to click in a cell and select "Insert Copied Cells" from the right-click menu. To copy the contents of a cell range, click in one corner of the range, hold down the left mouse button, and drag to the opposite corner. Similarly, to copy cell contents, right-click in the selected cell and select Copy, and paste in the new cell. To move cell contents, right-click in the selected cell and click Cut then right-click in the new location and click Paste.
#MS EXCEL 2007 TUTORIAL FOR BEGINNERS HOW TO#
Click in a cell with data to be copied, hover the cursor over the cell's lower right corner until the cursor changes to a thin plus sign (+) or a dark square, and drag in any direction.Įxcel's Fill Handle is powerful! See How to Autofill Anything for quick points, or visit our Autofill Information Center for a list of autofill tutorials. To propagate in any direction, use the Fill Handle to autofill. To fill adjacent cells with the contents of the cell to the left, select the cell with the data and cells to be filled and press Ctrl + R (the Ctrl key and the R key) to fill to the right.To fill adjacent cells with the contents of the cell above, select the cell with the data and the cells to be filled and press Ctrl + D (the Ctrl key and the D key) to fill down.Let's begin with two popular keyboard shortcuts that allow us to fill down, or fill to the right: There are multiple ways to propagate or fill data from one cell to adjacent cells. When you are ready to write math formulas, see Excel Math Basics. But the power of Excel is its ability to perform mathematical calculations and other functions. Microsoft Excel is a program that allows the user to enter data in rows and columns, similar to a Microsoft Word table. How to Lock Cells and Protect a Spreadsheet.We encourage you to open the Excel program on your computer and follow along with the steps below in your own worksheet. We'll tell you everything you need to know to get started using Microsoft Excel. We'll learn how to enter data into cells, move and copy data, propagate cell contents, and more. Read our disclosure policy to learn more.
○ This tutorial contains affiliate links.
0 kommentar(er)
