 |
| - Enter Numbers, Text, Date or Time | - Save a Backup Copy of Excel Workbook(s) | |
| - Enter the Same Data in a Range of Cells | - Other Tips | |
| - Enter a Formula | ||
| Enter Numbers, Text, Date or Time | ||
1. Select
the cell where you want to enter data. 3. Use a slash or a hyphen to separate the parts of a date, for example type 9/5/97 or Jun-92. 4. To enter time based on the 12-hour clock type a space and then a or p after the time; for example 9:00 p. |
||
| Back to top | ||
| Enter the Same Data in a Range of Cells | ||
1. Select the worksheet where you want to enter the data. 2. Select the cell range where you want to enter data. 3. Type the data in the first selected cell. 4. Click Edit in menu bar. 5. Click Copy from drop-down list (you will see a dashed-blinking line around the cell). 6. Drag cursor over the cells where the data is to be repeated. 7. Click Edit in menu bar. 8. Click Paste in drop-down list. |
||
| Back to top | ||
| Enter a Formula | ||
1. Select the cell in which you want to enter the formula. 2. Type = (an equal sign). Alternatively, if you select Edit Formula or Paste Function, Microsoft Excel inserts an equal sign for you. 3. Enter the formula. |
||
| Back to top | ||
| Save a Backup Copy of Excel Workbook(s) | ||
| To have Microsoft Excel automatically
create a backup copy of any workbook when you make changes, you
need to set the option for each Excel workbook. To set this option before a new workbook has been saved: 1. Left-click File 2. Left-click Save As instead of Save 3. Left-click on the dialog box's Tools button 4. Left-click on the General Options button 5. Left-click to check-mark the "Always create backup" box 6. Left-click on OK button, then Save. To activate the option for a previously saved workbook, follow the same initial procedure. When Excel prompts "The file already exists. Do you want to replace the existing file?" click on Yes. Excel then creates a backup copy in the form Backup of filename |
||
| Back to top | ||
| Other Tips | ||
| · You can add drawings
or pictures to your worksheets by using the horizontal draw toolbar
that you can find if you right-click on the little horizontal bars
next to the Excel icon in the File toolbar. Then, highlight Drawing.
The drawing toolbar will then appear at the bottom of your screen.
· You can quickly get from sheet to sheet by using the scroll buttons at the bottom left of your screen. |
||
| Back to top | ||