Excel tip (blank rows)

I needed to add several blank rows to my excel spread sheet..
found these cool tips!
1) add a new colunm A
2) number your existing rows (excel is smart enough to fill with odd numbers 1, 3, 5)
3) number the corresponding rows 2, 4, 6
4) sort the column smallest to largest
5) you could modify this to insert a row above or a row below
6) delete your sorting colunm

This method works well to randomize data in a spreadsheet.
1) use the formula =RANDBETWEEN(1,100) or however many numbers you want
2) drag the formula down the column
3) sort that column and presto! random information for students to sort

OR write a macro!  I have NOT tested this method!!

 Sub insertrow()
' insertrow Macro

Application.ScreenUpdating = True
Dim count As Integer
Dim X As Integer

For count = 1 To 20
If activecell.Value <> "" Then
activecell.Offset(1, 0).Select
Range(activecell, activecell.Offset(0, 0)).EntireRow.Insert
activecell.Offset(1, 0).Select
For X = 1 To 1
Next X
Else
activecell.Offset(1, 0).Range("a1").Select
End If
Next count

End Sub

By: Neville

Microsoft Office Page Numbers

This is interesting.........
I haven't tried it, but it might work!
So you want pages numbered as follows:
page 1 numbered as 1
page 2 not numbered
page 3 numbered as 2
page 4 not numbered
page 5 numbered as 3
page 6 not numbered
page 7 numbered as 4
etc. If I understand the question correctly, then:

In Word 2003 or earlier, open your document, click on
File | Page Setup | Layout tab | check the "Different
odd and even" box | OK. In the odd-page header or
footer where you want the page numbers to appear,
insert a calculated page number field:

{ = { = { page } + 1 } / 2 }

but do not type the curly braces; instead, insert each
pair by pressing Ctrl+F9. When you've finished entering
the page number field, press Alt+F9 to switch back to
display of field results (the page number) instead of
field codes.

Display the field results
By default, Word displays the field results seamlessly with the content of your document so that someone reading the document is unaware that part of the content is in a field. However, fields can also be displayed with a shaded background, to make them more visible in the document.
You can make the field results blend into the content of the document by turning off the option to display fields with a shaded background and by formatting the field results.
If you want to call attention to fields, you can display them with a shaded background, either all the time or only when the field is selected.
You can format the field results by applying text formatting to the field or by adding formatting switches to the field code.

Change the shaded background of fields

1. Click the File tab.
2. Click Options.
3. Click Advanced.
4. Under Show document content, in the Field shading list, do one of the following:
• To make fields stand out from the rest of the document content, select Always.
• To make fields blend in seamlessly with the document content, select Never.
• To make users of Word aware that they have clicked in a field, select When selected.

 Note   When the field shading option is set to When selected, the field displays a gray background when you click within the field. However, the gray shading does not indicate that the field is selected. When you select the field by double-clicking or dragging the mouse, highlighting that indicates selection is added to the gray shading.

Apply text formatting to a field

• Select the field that you want to format, and then apply the formatting by using the commands in the Font group on the Home tab.

For example, to underline the name that is inserted by an AUTHOR field, select the entire field code, including brackets (or select the entire field result), and then click Underline in the Font group on the Home tab.

 Note   If you update a field, any formatting that you applied to the field results may be lost. To retain the formatting, include the \* MERGEFORMAT switch in the field code. When you insert fields by using the Field dialog box, the \* MERGEFORMAT switch is included by default.

Add a formatting switch to a field code

1. Right-click the field, and then click Edit Field.
2. Do one of the following:
• If Field properties and Field options are displayed, select the formatting options that you want.
• If only the field code is displayed, click Options, and then select the formatting options that you want.

If the Options button appears dimmed, additional formatting options may not be available.

You can use three formatting switches to format field results:

• Format switch (\*)
• Numeric format switch (\#)
• Date-Time format switch (\@)

REFERENCES:
 http://www.techrepublic.com/blog/windows-and-office/pro-tip-calculate-the-current-page-number-within-a-section-in-word/

http://office.microsoft.com/en-us/word-help/insert-and-format-field-codes-in-word-2010-HA101830917.aspx

http://www.addbalance.com/usersguide/fields.htm

Experimental Post

Well, this was some Hallmark occasion.  That is a prayer angel and a prayer chicken up front  :-)