52 Tips on
Windows 95/98/ME Great place to start mastering Windows.
Excel is full of nice things
that really help you be productive and get the work done very fast.
Try this one, when you are at the top of a column full of numbers or labels and you need to move to the
bottom:
- With a standard pointer on the bottom
border double-click
The good thing about this is that it works in all four directions. If you double-click the
top, bottom, left or right you will go in that direction as long as there is data.
So if you have 5,000 records to get to the end or top of this is a quick way to get there.
If you would like to highlight as you go; for example: If you would like to highlight the
labels across the top and your active cell is in the top left corner of your data:
- Hold the Shift key down when you
double-click the right side of active cell
If your labels go down the left side and your active cell is in the top left corner: Hold
down the shift key and double-click the bottom border of the active cell.
My favor hot key in Excel is the one that
will highlight the complete table for me. You know the area where all of your labels and
numbers are.
- Put the active cell in your table and press
Ctrl + asterisk (on the 10 key pad)
If you are a touch typist like I am you might prefer the Ctrl + shift + asterisk.
Personal preference thing you know.
The next time you need to add a column or
a row use the right mouse to do it.
- Right click the row or column heading when
you want to insert or delete a column or row
You just pick the one you want from the menu and it will be inserted or deleted. When you
click on a row or column heading; that selects it, so when you pick the insert or delete
from the menu Excel will insert or delete at that point. This is faster than clicking
first with the left mouse button then pressing the right button to get the menu. If you
need to add more than one or delete more than one; Press and hold the left mouse button
down and drag across the number you need to select. Now when you click the right mouse
button down for the menu, you will delete that number or insert that number of rows or
columns.
You can't exactly bring two columns together but there is a
little trick to that will help you make it happen.
=B2&C2
Place the above formula in a cell in a blank column. Of course
change the cell address as needed.
You may have
to insert a column where you would like the two columns to end up as
a single column.
Placing this formula in the blank cell at the top of your new
blank column. You then copy the formula all the way down to the bottom of your
list. Use the autofill handle.
If you would like to add a character you could write the formula:
=B2&"-"&C2
Use the copy then Paste Special | Values to get a new
column without the formula..
| 
