![how to insert current date in excel 2010 how to insert current date in excel 2010](https://img.techwallacdn.com/300x250/ppds/f9ec3e85-3464-4017-af1c-55ab281efcb0.jpg)
- #How to insert current date in excel 2010 how to#
- #How to insert current date in excel 2010 plus#
- #How to insert current date in excel 2010 download#
Step 3 – Select the DATE & TIME so that we will get the list of function as shown below.
#How to insert current date in excel 2010 how to#
In this example, we will see how to automatically insert the date using the TODAY built-in function by following the below steps.
#How to insert current date in excel 2010 download#
You can download this Insert Date Excel Template here – Insert Date Excel Template
![how to insert current date in excel 2010 how to insert current date in excel 2010](https://i.ytimg.com/vi/5pdcLTwkn5s/hqdefault.jpg)
Let’s understand How to Insert Date in Excel by different methods along with some examples. CTRL+ and then CTRL+SHIFT+ which will give us the current date and time.To insert the current date and time we can use the below shortcut key as follows. CTRL+ (Semicolon), which will insert the current date.We can use the alternative ways to insert the date in excel by using the keyboard shortcut key listed below. TODAY built-in function is categorized under the DATE/ TIME function in the Formula tab. We can also use the NOW () built-in function, which inserts the current date and time, and this function also will be kept on getting updated when we open the workbook for multiple times. In Excel, for inserting the date, we have a built-in function called TODAY () which will insert the exact today’s date, and this function will give you the updated date whenever we open the workbook. This is how you can easily insert excel spreadsheet.Excel functions, formula, charts, formatting creating excel dashboard & others Resize the spreadsheet so that it fits your requirements.
![how to insert current date in excel 2010 how to insert current date in excel 2010](https://helpdeskgeek.com/wp-content/pictures/2010/04/3-InsertboththeCurrentDateandTimeintoExcel_thumb.png)
To go inside the spreadsheet, double click on it. Once you are done with typing in the spreadsheet, click anywhere outside the border of the spreadsheet and it will be gone. Once done, the total price will be calculated with the help of the formula.
#How to insert current date in excel 2010 plus#
In order to do so, click on the formula and the cursor will turn into a cross or plus sign drag it downwards to the row below. When you want to apply the same function for the next row, you can do so by copying the formula. Press the ‘enter’ key and tt will automatically calculate the total price. In order to calculate the total price of an ice cream in this tutorial, we entered ‘=A2*C2’. Since we want to calculate the total price, we will do so by inserting a simple formula. To add a little more space in the second column, bring the cursor in between the two columns B and C after which the double arrow will appear drag it towards right to create more space. In the rows, we are going to enter QTY, Item, Price and Total. The next step is to type data in spreadsheet. Now start typing in the data in separate columns and rows of the spreadsheet.
![how to insert current date in excel 2010 how to insert current date in excel 2010](https://www.teachexcel.com/images/uploads/e74201cb85d2a0fb07d5dfd302e7c33d.jpg)
Once done, you will have the spreadsheet will be added to your Word document. Over there, click on the option titled ‘Excel Spreadsheet’. In order to insert spreadsheet in Word, go to the “insert” tab and click on the Table dropdown arrow. In this tutorial, you will learn how to insert an Excel spreadsheet in word. You can do calculations with your data by inserting different formulas and arrange the data in a spreadsheet table. Insert spreadsheet in Word so that you can perform all the actions that you’d otherwise perform in Excel. If you want to use an excel spreadsheet, you can simply insert excel spreadsheet from a table in a document.