52 Tips on
Windows 95/98/ME Great place to start mastering Windows.
How can I get the text to run down the column. You know like this:
I
L
I
K
E
T
H
I
S
?
You can format the cell (Ctrl + 1) with:
Vertical: Justify
Orientation: Character over Character
This is great for just one row but if you have anything else in the row kiss it good-by!
The whole row is now 3 or 4 inches down.
You want it to go over the other rows!
Try this:
If you click the drawing tools button; get that toolbar up.
Click: Text box
Hold down the Alt key ( this will make the text box fit perfect in the column)
Drag down to where you want the text to go.
Right click the object - Select: Format object - Then select: Alignment.
NOW -
Set it the way you want it!
voila'
Almost forgot; if you want this to print (by default it should) but remember check it!
Right click the object (text box)
Select: Format Object
Click: Properties (tab)
Make sure the check mark is in the box for - Print Object
Or remove it if you don't want the object to print.
Delete
Blank Rows
All you need is a little short macro to delete those extra blank rows that we end up
with from time to time.
Take the following macro and copy it to a module sheet in Ver. 5.0, 7.0 or 8.0.
Sub DeleteEmptyRow()
LastRow = ActiveSheet.UsedRange.Rows.Count
Application.ScreenUpdating = False
For r = LastRow to 1 Step -1
If Application.CountA(Rows(r)) = 0 Then
Rows(r).Delete
Next r
End Sub
Wrap text in a cell
Press Ctrl - 1
Click the Alignment tab
Click the check box for Wrap text
Click OK
Excel finds your first link; click Find Next to find the next one and
again to find the next one, and so on and so on.
ALSO: IF you can not find it try looking at your named ranges. If you
have an old name range that was part of a link, it well give you a false
reading.
So that on the Edit menu you will see Links in black (vice dimmed) and
think you have links. And of course when you open the file it will always
ask you if you would like to up date links when you know you do not have
any.
1. Select cell A1.
2. Choose Edit + Find.
3. Type an exclamation point.
4. Make sure Look in is set to Formulas (it should be; it's the
default).
5. Make sure Find entire cells only is not selected.
6. Click OK.
If you would like to see an example of a VLOOKUP function in Excel and use it with a
form download the following file:
Example.xls
WHERE'S THE TEXT? - Excel
You may, on occasion, need to determine when a group of cells contains
numbers or text. Let's imagine that you need to find out how many
cells in a column contain text. Enter in cells A1 through A5
1
2
3
A
5
Now enter in cell A7
=counta(a1:a5)
This tells you how many cells in the specified column contain
something (5). Now, move to cell A9 and enter
=count(a1:a5)
to find out how many cells contain numbers (4). To find the number of
cells containing text only, subtract the difference:
=counta(a1:a5) - count(a1:a5)
This produces a result of 1, which is the number of cells that contain text.
| 
