viewergerma.blogg.se - Learn how to use microsoft excel for free

LEARN HOW TO USE MICROSOFT EXCEL FOR FREE PLUS

See How to Insert Rows, Columns, Cells, and Cell Line Breaks for detailed information on inserting these worksheet elements. Don't press the Delete key on the keyboard as it will only delete the column's data, not the actual column. And non-contiguous columns can be selected by pressing and holding the CTRL key. Contiguous columns can be deleted by highlighting them before clicking Delete. To delete a column, right-click on the column letter, and click Delete. Press the F4 key to continue inserting additional columns. Excel always inserts the column to the LEFT of the column that was clicked on. To insert a new column, right-click on a column letter and click Insert. Don't press the Delete key on the keyboard-it will only delete the row's data. And non-contiguous rows can be selected by pressing and holding the CTRL key before clicking Delete. Contiguous rows can be deleted by highlighting them before clicking Delete. 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.

LEARN HOW TO USE MICROSOFT EXCEL FOR FREE 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.

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.