|Quickly Inserting the Date into a Worksheet
Summary: There are many times when you need to insert the date into a cell in a worksheet. Here is an Excel shortcut that will do that very quickly:
Select the cell where you want to enter today's date. Hold down the Ctrl key while you press the ; (Semi colon key) on your keyboard. Excel will enter today's date into the cell.
Updating a Workbook Manually
Back to top
Summary: Normally your Excel workbook recalculates automatically whenever you make a change to a worksheet. With large workbooks this can slow your work down as the workbook constantly recalculates. To overcome this problem, you can turn the calculation mode to manual, so you determine when you want the workbook to recalculate. Here is how to do this:
- Click on the File Tab in the Ribbon. In Excel 2007 click on the Office Button.
- Select Options.
- Click on Formulas in the left hand panel.
- Under Workbook Calculations click on the Manual radial button.
- Click on OK.
With calculation set to manual, you press the F9 Function Key to recalculate your workbook.
Summary: Often times when you import data into Exel dates will come in as text . They do not display properly and you cannot do date arithmetic. Here is how to convert text date to dates:
Select the desired cell that contains the text date. Let's assume the selected cell is A1.
- In cell A2 enter the following formula.
- The DATEVALUE function returns the serial number of the date represented by the text date.
- Right click on the selected cell that contains the formula.
- Select Format Cells.
- Select Date
- Select the desired date format.
- Press the Enter key.
- To convert the formula to a value copy the cell(s) that contain the =DATEVALUE formula.
- Then in A1 do a Paste Special Values.
You can now delete the cells that contain the =DATEVALUE formula.
Selecting a Group of Words
Summary: Many times when you are working with a Word document, you need to select a group of words. Here is a fast way to do this:
- Position the insertion pointer inside the word at one end of the group you want selected.
Click on the word at the other end of the group, while you are holding down the Shift key.