Posts Tagged ‘create’

How to Easily Create a Round Trip Fill-In Client Intake Form in MS Word 2003

Thursday, June 18th, 2009

I recently created a copyrighted tutorial article for Technolawyer entitled Create a Fill In Form in MS Word and they changed the title to that above and published it with only one or two of the step-by-step screenshots that are a signature of my tutorials.

I have found, after years and years of training folks in the intricacies of MS Office that there are many methods of teaching. Not everyone learns from the written word; some folks need to see what I am describing to them with words. I really did not want to have something published under my name without step-by-step screenshots but Technolawyer told me that they “couldn’t handle images.” 

So, I am just letting my loyal readers know that if you want to see the original tutorial that I created, complete with screenshots for every step, I cannot give you access to their article, but I can certainly make my original copyrighted article available to you.

My tutorial showing you, step-by-step, how to create a fill-in form in MS Word,  will give you the wherewithal to create any kind of fill-in form that you like in MS Word for any topic or need within your company. You can then e-mail your form to customers, family, etc. who can fill in the required data and e-mail it back to you. If you are a teacher, you can even create a test  for your students using a fill in form!

The sky is the limit!  Once you learn how to create a fill in form you can let your imagination run wild and I know you will find many, many uses for fill in forms.

CREATING AND SAVING NEW STYLES IN OPENOFFICE WRITER

Monday, April 13th, 2009

As in MS Word, you can create your own styles, both character styles and paragraph styles. There is another type of style that you can create in Oo Writer, which is the frame style, that controls objects like graphics, frames, etc., but we will cover that in another article at a later date.

Just like in MS Word, paragraph styles affect indentation, spacing, font, and font size and apply to the entire paragraph. Character styles affect the size and color of individual characters.

Creating a new style in Oo Writer is just formatting within the Styles and Formatting window.

Follow the steps below:

  1. Select your text.
  2. Choose Format | Styles and Formatting to display the Styles and Formatting window.
  3. Click the appropriate icon at the top for the type of style you wish to create. Right-click in the blank part of the window and choose New.
  4. In the Style window, name your style and specify your other formatting options.
  5. Click OK to close the window and save your style.

You can modify your style much like you do in MS Word – simply select the style and choose Modify.

Yet again, these two programs are not all that different from one another except OpenOffice is FREE.

Create a Drop-Down List From a Range of Cells in MS Excel

Tuesday, February 10th, 2009

There are many reasons why one would want to create a drop-down list in MS Excel, but mostly I think, because it makes your data entry much easier and you can limit the entries to certain items that you can determine.

You can create a drop-down list of entries that is compiled from cells elsewhere on your worksheet and when you create the drop-down list, it will display a drop-down arrow next to that cell. When you want to select an item from that list, you can simply use the drop-down arrow and click the item that you want.

To create a drop-down list in MS Excel 2003, follow the steps below:

  • Use a single column or row without blank cells to create your valid entries for your drop-down list.

 

  • Make sure that you have sorted the list in the order in which you would like it to appear in your list.

You can use another worksheet or workbook if you like. To use a different worksheet in the same workbook:

  • Type the list on that worksheet.
  • Define a name, such as classes.
  • Select the range of cells.
  • Click the Name box at the left end of the Formula Bar.

  • Type the name for the cells.
  • Click Enter.

Pretty simple to do and it looks so very professional and is very helpful to boot!