Let’s test the auto-fill function on numerical values. Grab the bottom right corner of the cell with «January» value and drag it along the row. The program recognizes the date format and adds other months automatically.
Merge several cells: highlight them and click «Merge & Center».Įxcel has an auto-fill function. To make it look better, move a little the border of column E and align the text to the center against the vertical and horizontal directions. To preserve the column width but increase the row height click «Wrap Text» on the button ribbon. To fit the value in the cell, the column can be expanded automatically by double clicking on the right border. To change the size of rows or columns, move cell borders (in this case the cursor looks like a cross, whose horizontal line has arrows at the ends). To highlight a column, click its name (Latin letter). Press Shift, and keeping it pressed highlight the whole range with the help of arrow keys.Place the cursor in the top leftmost cell.To move several cells you need to highlight them: In the similar way you can move several cells simultaneously to the same sheet, to another sheet or to another workbook. Put the cursor in another work area place and click on «Paste» or press CTRL+V combination. The highlighted text will remain in the clipboard. A dashed line will appear around the cell. To move the cell with a value, highlight it, select the scissors icon («Cut»). To delete the cell value, use the Delete key. Highlight the cell, place the cursor in the formula bar, edit the text (number), and press Enter. The value can also be edited through the formula bar.Change the value: delete part of the text, add what you need. For the previous value to remain but to be changed, double click the cell.The word is deleted and the number remains. Left-click the cell with a word and type a number.To set up the numeric format for a cell quickly press the hot keys combination CTRL+SHIFT+1.įor «Date» and «Time» formats Excel offers several variants of value representation. Alternatively, press the hot keys combination CTRL+1.įor number formats you can assign quantity of decimal places. To set up / change the format right-click the cell and select «Format cell». Values can be numeric, text, currency or percentage-related, etc. To add a value to the cell, left-click on it.
0 kommentar(er)
