Excel
Hints & Tips
_____________________________________________________________________
Business Computing Tips
By K&K Fainges kfainges@bigpond.net.au
Sometimes, moving the mouse around can really slow you down. Here are some
keys that mean you don't have to lift your hands from the keyboard.
Ctrl+1 -- Prepares to format the selected object
Ctrl+B -- Sets or removes boldface
Ctrl+I -- Sets or removes italic
Ctrl+Shift+~ -- Applies the general number format
Ctrl+Shift+! -- Applies the comma format with two decimal places
Ctrl+Shift+@ -- Applies the time format (hour, minute, a.m./p.m.)
Ever needed to fill in the days of the week or months in your work. Just
type the first one, then click on that cell and a box will highlight it. It
even works for shortened names like Mon.
Click and hold the left mouse button down on the bottom right hand corner.
There is a little box or cross there to show you where. Then drag it across or
down the screen. Viola, the rest will appear. In version 98 or later, it even
shows where you are up to as you drag. When you have the right amount of
days/months you need, let go of the mouse. That easy.
Numbers can do this too, but you need to type in a couple before the
computer works out what you want.
Type 1 & then 2 in the next cell. Highlight both by clicking in the first
& then clicking and dragging over the second. This will give you the one
box around both. Click, hold & drag & it will fill in 3,5,6,7, etc.
Type in 1,3, and it will fill in 5,7,9. There are a ton of combinations.
You can create your own lists, say "cow, horse, chicken' by going to
TOOLS - CUSTOM LISTS - NEW LIST, then type what you want, hitting enter at
each new item.
To save typing out the list you want, you can import them from previous spreadsheets.
This saves a lot of time if you have a list of companies that you have to type
out frequently.
***********************************************************************
Please feel free to pass it on to your friends, just let them know I wrote
it.
Karen Fainges holds a Bachelor of Business, and a Grad. Cert of Vocational
and Educational Training. All this is nice but it's the 14 years of having to
make sales or starve that makes her think she has really learnt what does and
doesn't work. A tutor for all ages, she specialises in helping people get
started on the long road to technology.
"It has to be practical, it has to be cheap, and it has to work."
