If you need to add worksheets to an Excel file, chances are that you use the Insert | Worksheet menu command. There's a much faster way to go about this task: Simply press [Shift][F11] and Excel adds a new blank worksheet before the active worksheet.
If you need to add several worksheets to a workbook, you can use either technique to create all of the sheets at once. While holding down the [Shift] key, click on the same number of worksheet tabs as new sheets you want to create. Then, use either the menu command or shortcut key as you normally would.
Thursday, August 27, 2009
Wednesday, August 26, 2009
Instantly find all the fields in any document (MS Word)
Using fields in your documents is a convenient way to retrieve and update all kinds of information automatically. However, as handy as fields may be, they can be difficult to pinpoint when you need to edit them.
One way you can make fields stand out is to apply permanent onscreen shading. To do so, choose Tools Options from the menu bar (Edit Preferences in Word 2004), and then click on the View tab. In the Show panel, select Always from the field shading dropdown list, and then click OK.
In addition, you can easily locate fields by jumping to them. To jump forward from field to field, press [F11]. To jump backward from field to field, press [Shift][F11].
Need more Microsoft Word Help? Click here to find classes on any version of Word you need at New Horizons!
One way you can make fields stand out is to apply permanent onscreen shading. To do so, choose Tools Options from the menu bar (Edit Preferences in Word 2004), and then click on the View tab. In the Show panel, select Always from the field shading dropdown list, and then click OK.
In addition, you can easily locate fields by jumping to them. To jump forward from field to field, press [F11]. To jump backward from field to field, press [Shift][F11].
Need more Microsoft Word Help? Click here to find classes on any version of Word you need at New Horizons!
Tuesday, August 25, 2009
Add Power to your PowerPoint with essential eye contact!
When giving a presentation, never underestimate the importance of good eye contact. If an audience member asks you a question, turn to face them squarely to show that you're listening.
Keep this stance as you begin your reply, without staring directly into their eyes for more than five seconds. (If you need to, glance away momentarily and then regain eye contact--sustained staring can be intimidating.)
Above all, never look at a speaking member of the audience out of the corner of your eye. This can be construed as condescending and doesn't give the speaker the respect he or she deserves.
Also, check out these funny tips of what NOT to do during a presentation:
Keep this stance as you begin your reply, without staring directly into their eyes for more than five seconds. (If you need to, glance away momentarily and then regain eye contact--sustained staring can be intimidating.)
Above all, never look at a speaking member of the audience out of the corner of your eye. This can be construed as condescending and doesn't give the speaker the respect he or she deserves.
Also, check out these funny tips of what NOT to do during a presentation:
Subscribe to:
Posts (Atom)
