Technology Q&A
Opening
unopenable files
Faster alternatives to Bookmark in
Word
Boilerplate access in Outlook...Use Outlook to
track telephone calls
Formula crib sheet in
Excel
Sort out text from numbers in Excel
How
to silence the hissing modem
Shortcuts.
Key
to Instructions
To help readers
follow the instructions in this article, we use
two different typefaces.Boldface
type identifies the names of icons,
agendas, URLs and application commands.
Sans serif type indicates instructions and commands that
users should type and file names.
|
On
occasion you may find that you cannot implement a
function we described in this column. More often
than not its because not all functions work
in every operating system or application. We try
to test everything in the 2000 and XP editions of
Windows and Office. Its virtually
impossible to test them in all editions and
its equally difficult to find out which
editions are incompatible with a function. We
apologize for the inconvenience. The
editors
|
| |
WORD
Q. Recently I received a file that lacked
an extension (such as .doc, .xls or .txt) and
when I tried to open it, I got a message that
said Windows cannot open this file. But it gave me the option to try to open
it with a variety of applications by clicking on Select
the program from a list, and I clicked
on OK. I selected the
application I thought was bestin this case
Notepadand heres where I made my big
mistake: Without thinking I also checked the box
at the bottom of the screen that says Always
use the selected program to open this kind of
file. By doing that I seem committed to
a kind of purgatoryforever forced to use
Notepad to open that file. I didnt realize
the extent of my error until I later discovered
there was a better way to open the file, but
because I had checked that darn box, I
couldnt go back to change my selection. Is
there a way to appeal my sentence so I can open
the file with Word, say?
|
| A. OK, youve served enough time for
your crime; I can commute your sentence.
Heres what you have to do: With the cursor
on the errant file, right-click on it while
holding down the Shift key and click on Open.
That will open the Windows cannot open
this file screen. Once again check the
second optionSelect the program
from a listand then choose the
application of your choice. You may want to save
that file in that application by using File,
Save as. |
| Q. When Im working in a long Word
document and have to jump back and forth between
several locations I generally use the Bookmark
function. But sometimes, because it requires
several keystrokes, its not worth the
effort. Is there any other way to bookmark places
in a document without having to go through the
rigmarole of creating a bookmark and then
deleting it when Im through with it? |
A. Yes, there are at least two fast ways
to do it. But bear with me while I describe the Bookmark
function to readers who arent familiar with
it.The Bookmark
icon is in the toolbar under Insert.
If its not there, go to Tools,
Customize and under the Commands
tab, find Bookmark in the Insert
category and drag it up to your toolbar.
Now if you want to bookmark a
place in a document, engage it and enter a code.
To demonstrate for the screenshot at left, I
typed in my initialssz. Then click on Add.
You can add many bookmarks, and
as you see in the screen, Word will sort them by
location or by alpha name. If you do not put a
check next to Hidden bookmarks,
Word will place a large gray I at the
bookmarked location, like this one below.
The location
marker will not print. To get rid of a bookmark,
just click on Bookmark and then on Delete.
So, as you can see, it does
take a few steps. But if all you want to do is
bookmark two or three places, consider either of
these methods:
Press Shift+F5 and Word
will take you back to the last three places
youve been.
Place your cursor on a
scroll bar and then press the space bar. That
will take you back to the last location you
edited.
|
OUTLOOK
Q. Im getting loads of e-mails that
require only boilerplate responses. I know I can
set up AutoText in Word, but how
can I do it in Outlook?
|
A. Its essentially the same
procedure, but the trick is that first you have
to set your Outlook Mail Format
to default to Word, which, of course, makes your
e-mail preparation much more convenient.
Here are the steps
to follow: Go to Tools, Options, Mail
Format and then place a check in the box
Use Microsoft Word to edit e-mail
messages.
Type or copy the
boilerplate text into a message and highlight it.
Go to Insert, AutoText, New and
enter an abbreviation for the text and click on OK.
Now when you want
to evoke the boilerplate in an e-mail Reply,
go to Insert, AutoText and click
on the abbreviation. Shortcut: Type the
abbreviation and press F3.
|
| Q. A friend told me I could use Outlook as
a way to keep track of my client telephone calls.
Is that right? |
| A. It sure is. Its a very handy
function in Outlooks Journal. Heres
how its done: When
youre about to make a call, go into
Outlooks Contacts for the
phone number. Double-click on the contact, which
will evoke this screen:

Now go up to the toolbar and
click on Actions and then on New
Journal Entry for Contact. That will
bring up this screen:

Notice that the top of the
screen contains a stopwatch and start and pause
buttons. When you begin the call, click on the Start
Timer button and on the Pause
Timer button when youre finished
with the conversation. Notice, too, that you have
room to take notes about the conversation. When
youre done, click on Save and
Close.

Now when you want to check back
to see your notes and how long the phone call
took, go to your Journal folder
and click on View, Current View
and then on Phone Calls. Youll
get a screen that shows not only when you made
the call, but also the length of the call and any
notes you made.
|
EXCEL
Q. When Im working in Excel, I
sometimes have trouble remembering a formula. Is
there an instant crib sheet I can refer to? I
know I can look it up in Help,
but thats such a slow process. |
A. Yes, there is a very handy tool that
will provide an instant menu of formulas. While
in Excel, click on Insert, Function. That
brings up this screen:Notice
your choices: You can either describe what
youre looking for under Search for
a function or you can click on the
general category under Or select a
category and youll get every
applicable formula.
But if you just need to do a
quick, fundamental analysis on a range of cells,
like a count or a sum or an average, there is an
even faster waya one-click operation with
Excels nifty statistics tray.
Heres how: Select a range
of cells and right-click anywhere on Excels
status barthats the horizontal bar at
the bottom of the window that displays the word Ready
at its left edge. That will evoke a function menu
which includes the following statistical
calculations: Average, Count, Count Nums,
Max, Min, Sum. Select any of the
functions and Excel will display the answer
dynamically right on the horizontal bar.
Its that easy.
|
| Q. My spreadsheets contain a mix of
numbers and text. Is there a way for Excel to
sort out the numbers from the text without
setting up a complex formula? |
A. The easy way is to use the Go
To function. Heres how it works.
Create a spreadsheet with numbers in some cells
and text in others. Then press Ctrl+G and
youll get the Go To dialog
screen. Now, in the lower left part of the
screen, click on Special and
that will bring up the screen at right.
If, for example, all you want
Excel to highlight is text, select the Constants
radio button and of the four square boxes (Numbers,
Text, Logicals, Errors), choose only
Text. Then when you click on OK,
Excel will highlight only the text entries and
the spreadsheet will look like the screen at
left.
While youre at the Go
To Special screen, you may want to try
some of the other selections.
|
MODEM
Q. I use a modem for Internet access, and
while it works fine, the loud hissing sound it
makes irritates everyone in the office. They
react as if I was scratching a blackboard. Is
there a way to get rid of that din? |
A. That sound is called a
handshake. Its the audio signal
that your modem sends to your Internet service
provider (ISP) asking for entry; once your ISP
recognizes the coded signal (thats where
the handshake comes in) youre
connected to the Internet. So you see, you
cant very well eliminate the handshake
without eliminating the connection as well.
However, you can make it quieter so you and your
office colleagues are not irritated. To do that, go to Start
and then click on Control Panel and
the modem icon.
Now click on the Properties
button and the Modem tab, which
evokes the screen at right.
To lower the modem
speakers volume, just slide the Off-On
button to the left. Although you can turn off the
sound entirely, Id suggest you leave it
just so its audible; that way youll
know the modem is working. 
|
| |
|
Shortcuts
Outlook
and Outlook Express: To add an
address to your address book from any e-mail
message, either right-click on the address in the
open message or on the top of the Preview
Panel and select Add to Contacts.
Excel: To move
quickly to the next sheet in a workbook, press
Ctrl+Page Down, and to move to a previous
worksheet, press Ctrl+Page Up.
Word: A fast way to
display the Tabs dialog box is
to double-click on the very lower edge of Ruler.
If you double-click at the top, the Page
Setup dialog box appears. Applies to
Word 95, 97, 2000 and 2002.
Excel: To edit a
hyperlink, press F2.
All applications: A
quick way to toggle Print Preview
is to press Alt+Ctrl+I. Press it again and it
disappears. If all you want to do is print, press
Ctrl+P.
|
| |
| Do you have technology questions for
this column? Send them to Senior Editor Stanley
Zarowin via e-mail at zarowin@mindspring.com. Because of the volume of mail, we
regret that we cannot individually answer
submitted questions. However, if a readers
question has broad interest, we will answer it in
a forthcoming Technology Q&A column. The
editors
|
|