Posts Tagged ‘auto’

Auto Fill Weekdays Onlyin MS Excel

Monday, May 23rd, 2011

I am sure most of you most likely know how to use the AutoFill feature in MS Excel. Those of you who are premium subscribers to Carol’s Word Bytes Newsletter have read articles about this feature in past editions. In any event, you all most likely are aware that the AutoFill feature can save you lots of time.

MS Excel recognizes myriad series with the AutoFill feature and one of those is the Days of the Week.  You enter the Monday into a cell and left-click the fill handle and drag it down or across and MS Excel will automatically fill your cells sequentially with the days of the week.  But you already knew that, right?

Here is something about that AutoFill that you many not know – you can also use this feature to only get the days of the week and NOT the weekend.

Follow the steps below to learn how:

  1. Key in Monday or any other weekday.
  2. Rather than left-clicking the fill handle, use your alternate click (right-click) and drag. Once you release the mouse button,  you will see a contextual menu.
  3. From the menu, select Fill Weekdays.

Another method is:

  1. Perform your AutoFill as you normally would with the left-click.
  2. Once you release your mouse button, look for the Autofill options button at the bottom right of your filled cells.
  3. Click on it and you will see several options, one of which is Fill Weekdays.

Always remember! Left click selects and right click gives you choices!

Tags: , , , , , , , ,
Posted in Excel 2003, Microsoft Office Excel | No Comments »

Answer Interrogatories Easily in MS Word

Friday, November 21st, 2008

Any legal secretary will tell you how tedious it can be to continually type in Interrogatory No. 1 or Response 1, and so on through thirty or more Interrogatories or Requests for Production of Documents. If you work in a larger firm that has a document assembly package in place or one that employs a scanner it makes your life a lot easier when it comes to this task. But for the small, boutique firm or solo practice it can still be a pain.

This is where AutoText comes in handy in MS Word. You can combine AutoText with another feature called AutoNumbering to make this whole process go a lot more smoothly for you with way less keystrokes and a lot less time. You can make the phrase an AutoText entry. The key to doing this is to enter the required number using a Field.

Follow the steps below to learn how:

  1. Type the phrase you are going to use (i.e. Interrogatory No.), including the and bold attributes.
  2. Click on Insert | Field.
  3. Use the drop-down list under Categories and select Numbering.
  4. The Field name you want is AutoNumLgl.
  5. The Field properties is 1, 2, 3…
  6. Check the Field Option for Display number in legal format without a trailing period.
  7. Click OK.

Don’t forget to turn off the underlining and bolding attributes before you type in the colon!

Now, Select the entire phrase and Add it as an AutoText thusly:

  1. Click on Insert | AutoText  New or use the shortcut Alt + F3.
  2. This will open the AutoText dialog box.
  4. Click Show Autocomplete Suggestions.
  5. Under AutoText Entries, key in Inte or something that will be intuitive for you.
  6. Click OK.

You can now start keying in the Word Interrogatory and tap the Enter key and keep right on on going!

Makes like a lot simpler doesn’t it?

Tags: , , , , , , , , , , ,
Posted in Microsoft Office, Word 2003 | No Comments »

Word 2007 Auto Text

Wednesday, July 16th, 2008

9. May 2008 by Carol.

 


AutoComplete has been disabled in Word 2007 due to the enormous quantity of Building Blocks (the expanded successor to AutoText) that would otherwise cause AutoComplete to occur just about all the time.

To force completion after typing the first four characters, you’ll need to press the F3 key. This will work with any Building Block, not just AutoText. But, it will work only if there are no other entries that begin with the same four letters.

Some users are finding it useful to use AutoCorrect entries instead of AutoText entries as a work-around, and to purposely create short names that match what they were typing in Word 2003 and earlier. There is still no AutoComplete display, but typing any Word separator (space, period, comma, etc.) will trigger that automatic change from the short name into the expanded form.

Tags: , , , , ,
Posted in Word 2007 | No Comments »