![learn how to use microsoft excel 2010 learn how to use microsoft excel 2010](https://i0.wp.com/tutorialsplanet.net/wp-content/uploads/2019/12/4745657752.jpg)
Highlight two cells, grab the auto-fill marker and drag it downwards. 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).
![learn how to use microsoft excel 2010 learn how to use microsoft excel 2010](https://www.techonthenet.com/excel/macros/images/visual_basic_editor2010_003.gif)
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.
![learn how to use microsoft excel 2010 learn how to use microsoft excel 2010](https://www.businessproductivity.com/wp-content/uploads/2014/01/how-to-use-a-simple-formula-in-microsoft-excel-2010-01.png)
To add a value to the cell, left-click on it.