 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
Free Music Lessons
Free Spelling Lessons
Free ESL Lessons
Free French Lessons
Free Spanish Lessons
Free Math Lessons
Free Crocheting Lessons
Free Knitting Lessons
Free DOS Lessons
Free Word 97 Lessons
Free PowerPoint 97 Lessons
Free Excel 97 Lessons
Free Business English Lessons
Free Access 97 Lessons
Free Internet Lessons
Free Windows 95 Lessons
|
|
| Free Excel 97 Lessons from AQE |
 |
| ||||||
| Free Excel 97 Lesson 1 from AQE Keyboard Movements [Page Up] moves cell pointer up one screen. [Page Down] moves cell pointer down one screen. [Alt + Page Up] moves cell pointer one screen to the left. [Alt + Page Down] moves cell pointer one screen to the right. [Ctrl + Home] moves cell pointer to upper left cell of active worksheet. [Ctrl + End] moves cell pointer to lower right cell of active worksheet. ------------------------------------- Free Excel 97 Lesson 2 from AQE Automatic Features AutoComplete - compiles a list of entries. When you type the first few letters of a repeated entry, Excel finishes typing the entry for you. AutoFill - creates a standard series of labels on a worksheet (e.g. months of the year). When copying a range down from the first label, if Excel recognizes the first item in a standard series, the range is filled with the rest of the items in the label series. AutoCalculate - displays the sum, average, etc. The results, which appear on the status bar, are temporary and are not placed in the worksheet. --------------------------------------- Free Excel 97 Lesson 3 from AQE Deleting *To delete data in a cell, Edit, Clear, Contents. *To delete formatting, but not contents, Edit, Clear, Formats. *To delete a Conditional Format, Format, Conditional Formatting, Delete, select checkbox of the condition you want to delete, OK. *To delete a worksheet, right-click on the worksheet tab, select Delete. * To delete a custom sort order, Tools, Options, Custom Lists tab, select custom sort order, Delete, OK, OK. |
| For personal Excel 97 Lessons, see AQE's Homepage at http://maxpages.com/aqe |
 patty88keys@hotmail.com |
|
. |
| Visitors: 04961 |