|
EXCEL
|
WORD
|
OUTLOOK
|
|
Clicking
and dragging a formula down a column is easy! This process can be tedious if you have
hundreds or even thousands of rows of data.
Whether it is 10 rows or 10,000 rows, if there is data on the left or
right of a formula you are about to copy, just double click the auto fill
handle. The way you know you are on
the AutoFill handle is that your cursor changes from a white plus to a black
plus. The formula will stop copying
where your data stops. You can also copy
cells contents by just clicking (with the black plus) and dragging down to a
selected cell, if there is no data in the neighboring cells.
|
Keep repeating the same information over
and over? Do you always close with the same few lines
in your letters or often insert similar requests for information? Create your own Quick Part and repeat your
actions with a couple of clicks. Type
in your verbiage and select it. On the
insert tab, in the text group,
click Quick Parts. Select the last option, Save Selection to Quick Part Gallery. To use it again, simply click the same
button. Your own Quick Parts should
show up at the top of the drop-down menu.
Hint: This works in Outlook too!
|
Follow up with Outlook. Set a follow-up
flag BEFORE you send an
email by using the message tab, which appears in place of the Home tab when composing email. Click
on the drop down button of the Follow
Up tab. Select one of the preset follow-up times or a custom date. You can even set a reminder. It will then show up as a task on your To-Do Bar. You will get a pop up reminder when it is
time to send a follow-up.
|