Insert a static date or time into an Excel cell On a worksheet, select the cell into which you want to insert the current date or time. Do one of the following: To insert the current date, press Ctrl+; (semi-colon). ( Windows) To insert the current time, press Ctrl+ Shift+; (semi-colon).
Create a cell reference to another worksheet Click the cell in which you want to enter the formula. In the formula bar , type = (equal sign) and the formula you want to use. Click the tab for the worksheet to be referenced. Select the cell or range of cells to be referenced.
Method 2 Inserting a Link to a Webpage Copy the address to the site you want to link to. ... Select the cell in your Excel spreadsheet that you want to insert the link into. ... Click the " Insert" tab and click the " Hyperlink" button. ... Select " Existing File or Web Page" on the left side of the window.
Use numerical keypad shortcut to add rows in Excel Select the range in Excel to insert a new row. To do this left-click on the row number button next to the fist cell of the selection and extend the range keeping the left mouse button pressed. Now press Ctrl + Plus on the numerical pad.
Auto fill weekdays, months or years You can use the Excel Auto Fill options as described above. ... Another way is to enter your first date, select that cell, click the right mouse button and drag the fill handle down the cells you want to auto fill with dates, and then release it.
Click in the cell where you want to insert the current date, and then click the “ Formulas” tab on the command ribbon. Click the “ Date & Time” button in the Function Library group, and then click “ NOW” to open the Function Arguments dialog box.
Combine Cells With Text and a Formatted Date Select the cell in which you want the combined data. Type the formula, with text inside double quotes, and the date inside the TEXT function. For example, to show the full weekday name, for the current date: ... Press Enter to complete the formula.