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.
#Learn how to use microsoft excel 2010 plus
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.
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.
0 kommentar(er)
