Formatting Templates In Word 2000!
Now suppose you've struggled over three or four Heading
outline-numbered documents, and now you want to continue with
these *better* methods. In a new document, type some sample text
for heading levels 1, 2, 3, and 4, or however many levels you used
in your document. Format them as outline numbered using the method
above. If this is exactly how you wanted it to look the first time
around, save this file as a template. Close it.
Open one of your badly formatted documents. Hit Format-Style and
choose the Organizer button. Your document's styles appear in the
left-hand of the window. On the right, you'll see normal.dot.
Close normal.dot with the Close button. The Close button turns
into an Open button. Choose it and open your new outline numbered
template. Copy whatever styles you created in your template over
to your existing document. Close the template. Hit OK. All of your
previous heading styles should not be replaced with appropriately
outline-numbered heading styles.
Saving Time With Custom View in Excel 2000!
Custom Views is a tool in Excel that lets you assign a name to a
particular sheet layout so you can recall it for later viewing.
You can access it by selecting View | Custom Views. In the Custom
Views dialog box, you'll see a listing of your saved views. You
can add or delete views. When adding a view, you have the option
of including print settings, hidden rows and columns, and filter
settings. Creating a new view even remembers where the active cell
was when the view was saved, so when you open that view, it will
jump to the exact spot in your book that corresponds to that view.
Making good use of custom views can save a great deal of time. For
example, you can eliminate repetitive hiding, resizing, filtering,
and other changes for producing various printed reports. Each set
of options can be saved as a view. Then, all you need to do is
apply the view before you print.
Use the expression builder to add a report total in Access 2000!
Errors in report totals
are most often due to mistyped expressions or incorrect syntax. To
avoid these errors, use the expression builder to add a report
total. Follow these steps:
1. In Design view, click the Text Box tool and click inside the
Report Footer section to insert a text box.
2. Type your caption (e.g., 2003 Total Sales), right-click the
unbound object, select Properties, and select the Data tab.
3. Click the Expression Builder button [...] at the end of the
Control Source box.
4. Click the equals [=] button in the Expression Builder dialog
box to begin building the report total formula.
5. Double-click the Functions folder in the left-hand list box,
double-click Built-In Functions, and select in the middle
list box.
6. In the right-hand list box, scroll down and double-click the
Sum function.
7. Select <> in the box at the top, double-click the Reports
folder in the first list box, and select the report title from the
drop-down list.
8. Click in the middle list box. This displays the
fields used in your report in the right-hand list box.
9. Double-click the name of the field whose values you want to
total (e.g., if Sales is the field name, the resulting expression
is =SUM([Sales]), and click OK.
10.Press [Enter]. The formula is now your control source.
When you run the report, the total for the selected field will be
displayed at the end of the report.
I rebuild old computers for people who cannot afford new ones!
Find out More Here!
Visit My Customer Support Pages!
Database Download Center!
DOS Command Index!
Learn How To Backup The Registry!
Backup your Registry in Windows XP!
Visit our Quick Over View of my Remote Connection Service!
Remote Connection Help Service Hours!
Have Questions on Microsoft Windows & Office Products? Try my New
Forms!
Help Desk Techs!
|
Things to Note
Many Folks ask us how we cover so many topics. Most of our answers
come from a Database with 42 Topics and over 8000 entries. This
came from over 8 years of online help. Couple that with over 5000
documents on various subjects we have the ability to answer most
of your questions.
|