Welcome to Blaisdell's Little Corner of the Web

Home Browsers Microsoft Office 97 Site Search Windows

Albion | Freeware | Freeware From A-Z | Security | Virus Information

Office Index II | Office Index I | Found a Broken link? Click here to let me know | This site was Updated on  02/28/2006 |
Welcome to Bohunky0's Software Tips And Tricks
 
Microsoft is playing that old song and dance, this time WOW caught them in the act. Read more about WOW's discovery by clicking here.
This page is a work in progress. Items will be added as they become available. Thanks for visiting and please come back often.
 
Be sure to hit your reload or refresh button often, we are adding stuff all the time.
 
Thanks for taking the time to visit, please come back real soon.

Need an example of what you'll find here? Try these Office 97 shortcuts:
Combine these shortcuts to jump around a document faster.

  Jump one word left    Ctrl + left arrow
  Jump one word right   Ctrl + right arrow
  Jump up to start of paragraph         Ctrl + Up arrow
  Jump down to start of paragraph       Ctrl + Down arrow

~Bohunky0~


By far the most questions that I am asked is different functionality's of Microsoft Word. This is a compilation of many of those questions along with their associated answers. I am certain that you will find an appropriate solution among these archives. If not, give me your Word questions. If I can not find the correct answer for you. I will find someone who can..

~Bohunky0~

Microsoft Office Word-up!
Also see, "Excel with Excel".

Check out these other great sites for help in anything word:
Woody's Office Watch .... WOW

and

Ziff Davis Help Channel ... ZDNet

More coming:
Know of a little known keyboard shortcut or MSWord technique? Share it with us.

Excel with Excel                        Excel Downloads from ZDNET helps you excel with Excel

Also see:

Some of you have asked about Power Point. Why don't you have Power Point tips Bo?
Well, the truth of the matter is I don't get that many questions about Power Point, and it isn't one of my strong points. But, I'll attempt to act on as many questions as possible. Click here to go to the newly formed Power Point Page, and no, I will not be adding tips for Access 97. I could write volumes on that one and barely scratch the surface.

Go to top of page
Just started a new Excel section. Want to know of a keyboard shotcut in Excel? Click here
Do you have an Excel 97 tip, trick, or shortcut? Tell us about it.
Return to top of Page




Look for a better word?  The Thesaurus is only a shortcut away.  There's no need to select the word, just put the insertion point before, after or inside the word and hit the shortcut.

       Thesaurus Shift + F7




" I'm trying to create some exceptions to the initial caps and capitalize first letter actions.  But sometimes as I enter the exception the 'OK' button is greyed out.  Why? "

In Word 97 and 2000 you can put in exceptions to the general action of AutoCorrect to 'fix' cases where it would otherwise try to put a capital at the start of a sentence or remove the capital letter from anything but the first letter in a word.

For example, if I type 'approx.' Word 97 would normally assume that the period is an end of sentence marker and try to capitalize the first word of what it thinks is the sentence. Having 'approx.' in the exceptions list stops that.  Similarly, typing 'ZDnet' would normally get wrongly converted to 'Zdnet' by AutoCorrect (it thinks that I held the Shift key down too long) - putting 'ZDnet' in the
exceptions list prevents it happening for that word. "Of course Word thinks! You were not aware of this?"

bohunky0 All the AutoCorrect controls are at Tools | AutoCorrect. Under the 'AutoCorrect' tab you'll find an 'Exceptions' button. But AutoCorrect exceptions only work for single words - the program can't recognize multi-word exceptions.  Because of that design limitation, as soon as you press a spacebar in the entry box it realizes it's an invalid exception and greys the 'Add' button until you fix it.

Of course, it would be more helpful if the program gave some clue as to why the button is greyed. Maybe in Word 2010?

Return to Index



"How can I insert todays date on the right hand side of the page like my English
  teacher taught me many years ago?"

You can do it using two simple shortcuts.  Firstly, right
  align the current line:

    Right Align Ctrl + R

  Then insert today's date:

    Insert date Alt + Shift + D
Return to Index




Microsoft Word searching techniques:
" Word's Find & Replace uses two entirely separate search engines.

The more familiar engine is adequate for very specific or very general targets ("Massachusetts" or "*"), but the lesser known engine is much more powerful, and  can track down and modify subtler targets such as any date, any time, or any dollar value.
  To toggle between the two, check or uncheck Find & Replace | More | Use Wildcards. For documentation, read the help-file page entitled "Examples of search wildcards" (in
the Word97 help file search index, look for "Searching", choose the subtopic "Wildcards", and then click the "How"  button under bullet 4). For key differences between the two engines, see
  http://support.microsoft.com/support/kb/articles/Q176/7/76.asp

  DETAILS
  All you need to know: just four types of pattern-matching brackets

    [] A pair of square brackets matches any of the characters which it encloses. To find any vowel, in upper or lower case, enter [AEIOUaeiou] in the find box . There are a couple of useful abbreviations which work with the square brackets : (1 - Negation with "!") To find any kind of character except for lower-case vowels, enter

       [!aeiou] (The exclamation symbol is an abbreviation for "anything except") (2 - Ranges with "-") To find any digit, enter [0-9]. [a-z] finds any lower case alphabetic character. [!0-9A-Za-z ] finds any character (such as punctuation) which is neither numeric, nor alphabetic, nor a space character).

[.?\!] finds any full stop, question mark, or exclamation mark. (The backslash enables you to search for characters which have a special pattern-matching meaning.)

    {} Curly brackets enclose instructions to look for a certain number of the preceding type of character.
        [0-9]{2} will find any sequence of two digits.
        [0-9]{2,6} will find any sequence of between two and six
       digits.
        ^t{2,} will find any sequence of two or more tab characters. An optional abbreviation for
        {1,} is @. So
       ^t{1,} and ^t@ will both find any sequence of one or more tab.

    <> Opening and closing angle brackets match the beginning and end of a word respectively .

    [aeiou]> will find any vowel at the end of a word. <[!AEIOUaeiou0-9]{2} will find any pair of consonants at the beginning of a word.

       <1[89][0-9]{2}> will find any nineteenth or twentieth century year.

        () Most powerful of all, plain brackets enable you to define groups which can be referred to in Replace operations. To correct all millennium-bugged dates of the form 05/03/00 to the form 05/03/2000, you could enter ([0-3][0-9]/[01][0-9]/)([0-5][0-9]) in the Find box, and \120\2 in the Replace box.  \1 refers to the first bracketed group and \2 refers to the second bracketed group.

Return to Index




" How can I put white text on the black background in Word ? "

  White text on a black background is an effective heading  it was always possible in Word, but got easier as versions changed. Put simply, type in your text, highlight it and choose
Format | Borders and Shading | Shading.  Change the shading color to Black.

In later versions of Word this is enough because the default text color is 'Auto' and will change automatically to a contrasting color when the background changes.
  Otherwise you have to choose Format | Font (or Format | Character) and alter the font color to 'White'.
  In earlier versions of Word there can be a problem with the printer drivers when you try this - you may get only a black box on the printed page.
  Here are two things to try if this problem hits you:
 Go to your Printer setup (File | Print | Properties or
      File | Print setup depending on your version of Word) and uncheck the 'Print TrueType as Graphics' selection.
    - Otherwise try the old favorite solution - update your printer driver.
Return to Index




Problem: You like using the mouse in Word, how do you set tabs and spacing in word without having to select the >MRNU< >format<

Solution:
Try holding down the Alt key while using the mouse to adjust tabs, indents, columns and margins on the ruler. When holding down Alt, the ruler shows changing distances between settings as you move the marker.
  Very handy for precise placement of your work on the page

Return to Index



Moving lines, paragraphs or rows in Word.
Stop Mousing around, use keyboard shortcuts to speed your work and influence friends and impress the boss. Oh come on, you know you want too.
After you've selected a block of text or rows in a table you can move
them up or down the document using these keystrokes.
      Move Up Alt + Shift + Up Arrow
      Move Down Alt + Shift + Down Arrow




Rapid Font Association
Jump to the Format | Font menu.  When the formatting toolbar isn't enough you can quickly bring up the Font menu using this shortcut:

  Format | Font menu Ctrl + D

Return to Index



Go back - a handy shortcut that takes you back to the last location that you took an action (like typing).  This is very handy if you accidentally hit a key or mouse and move away from the location you wanted.

      Go Back Ctrl + Alt + Z

  It takes a bit of getting used to, but once you've done it a few times I think you'll see how handy

Return to Index
Go to top of page




PROBLEM: You need to keep a running count of the number of words in a Microsoft Word document. Is there a way to do this that's easier than using the Tools, Word Count command?

SOLUTION: Insert the NumWords field at the end of your document (Insert, Field), then press F9 (recalculate) to tally the number of words written. Other options are to assign a keyboard shortcut to the Tools, Word Count command or to add that command to a toolbar.

Go to top of page
Return to Index




PROBLEM: What are hidden bookmarks in Microsoft Word?

SOLUTION: As a navigational aid, Word automatically creates hidden bookmarks when you insert cross-references, tables of contents, and similar items in a document. To access hidden bookmarks, go to the Bookmarks dialog box (Insert, Bookmark).

Go to top of page
Return to Index




Changing font sizes.

  There are two sets of shortcuts for changing the font size of the current text selection.  The first set grow or shrink the sizes in the jumps listed in the pull down font size menu (ie 8, 9, 10, 11, 12, 14, 16 etc)

      Increase the font size Ctrl + SHIFT + >
      Decrease the font size Ctrl + SHIFT + <

  The alternative shortcuts change by a single point size at a time.

      Increase the font size by 1 point Ctrl + ]
      Decrease the font size by 1 point Ctrl + [

 The second set in particular is handy if you're trying to fit some text into a specific space.  For example, expanding a heading to fill the whole line without wrapping to a second line.  Just highlight the text then use the shortcuts until it's just right.
Return to Index
Go to top of page



Top Ten Office Features You Don't Use
(But Probably Should)

Return to Index
Go to top of page



Microsoft Office 97 Upgrades

Do you share Word, or Excel files with other people that may not have Office 97? I have some important information of you to rectify that very situation. Click here for information on the Microsoft Office 97 free viewers available at no cost to you from Microsoft.

Office Updates
Microsoft Office Excel 2000 OBDC Security Hole Update
Microsoft Office Excel 97 OBDC Security Hole Update
Office 97 Service Release 1(SR-1) Fact Sheet
Office 97 Service Release 1 (SR-1)
Office Service Release 2 or sr2b

Before runing any Office 97 update first run
Microsoft Office Update Checker. Read more
about this newest update by clicking here
 




Office 97 Service Release 2b (SR-2b) is out once again. We try to make some sence of this latest update feasco. Like I said, we try. Please take a few minutes to read our information before you begin downloading the patch. You may not need all of the 23 MB download if you already have SR-2 installed. Read our take on SR-2b or Not 2b

        Microsoft is very soon going to be stopping support for Office 97/98. Be sure to grab this stuff while you can. Once it is gone, it is gone. Hey, blame Bill - Okay!

        The Version Checker utility that is supposed to help customers identify which version of Office 97 they have will not be updated to allow for SR-2b, the Help | About screens remain the same and the VBA properties that are designed to identify the software version are also unchanged.

        If you think it's confusing - join the club.  It's bad enough for individuals, spare a thought for managers in large companies who are trying to keep a track of hundreds or thousands of computers.

The first release of SR-2b that was promptly removed
Microsoft has quietly released an update to their last Office 97 update called Service
Release 2 (SR-2b) - but it has now been withdrawn

What is the reason for this about face?
See what Woody's Office Watch had tosay about this reversal:

"What we suspected when the last WOW went out has now been confirmed - Microsoft had not properly updated the text, FAQ's etc on the web site.  Someone had gone over the SR-2 pages altering all version references to 'SR-2b' with no consideration about whether the text still applied to SR-2b! This resulted in many people writing to WOW quoting
parts of the Microsoft web site and claiming we had wrongly attacked Microsoft.   But the parts they were quoting really related to SR-2a even though the version number had
been changed!  The belief that SR-2b doesn't have any new fixes and is only a change in the installation process is wrong and comes from the false and misleading FAQ (the
installation fix was covered in WOW last year in the change to SR-2a).

As we write this, Microsoft has withdrawn the entire Service Release web site presumably to do the proper revision to the text it should have done in the first place. We here at WOW are bitterly disappointed with Microsoft over their inept and unprofessional handling of this release.  To release a new patch with no documentation and worse, simply change existing information to a new version number with no checking is unforgivable.  Given the past history of confusion with Office 97 updates it was essential for the company to go to extra lengths to ensure SR-2b was sent out with all necessary information and questions answered.  The fact that even the most elementary steps were not taken is a sharp indictment on the company and management.

We're beyond understanding what passes for sense in the Office team when it comes to Service Releases - we've suffered one bungle after another and no-one at the company
seems interested in remedying the matter. Everytime we're told "it will be better next time"  -- but it never gets better.

We've set out in the next section the proposal for SR-2b as explained to us by Microsoft.  We consider that this new updated process is flawed and will lead to more confusion
for both customers, IT administrators and even Microsoft's own support staff.  Many of the problems of earlier Office 97 Service Releases are being repeated".
Check out Woody's Office Watch (WOW) for yourself.
Return to top of Page




Calculating dates is easier than you think

Start         End         Days
  11/1/99       11/3/99        2
  11/5/99       11/23/99      18
  11/7/99       11/14/99       7

  The Days are calculated using the following formula =End-Start. You should format the results to display not as a date, but as a number. You do that by selecting the cells and choosing Format, Cells and clicking the General category on the Number tab.

  Similarly, you can calculate time.

  Start         End           Hours
  8:00 AM       10:00 AM      2:00
  11:30 AM       1:00 PM      1:30
  4:15 PM          5:00 PM      0:45

  The trick with time is to format the cells to show Time without the AM or PM. Choose Format, Cells, Number tab. Select the Time category and choose the first option (time
  without AM or PM).

  TIP - To quickly enter the current date press CTRL+; (semi-colon) then press ENTER. To quickly enter the current time press CTRL+SHIFT+; (semi-colon) then press ENTER. Note  - the date and time come off your computer's clock setting (Start, Settings, Control Panel, Date/Time) so make sure that is accurate.

  DATE FUNCTIONS.
  There are a large number of date functions in Excel. The online help does a fair job of explaining these and showing some examples. One of the functions I have used is the NOW() function. NOW() represents the current day and time and does not use any arguments. Suppose you have a deadline
of completing a project on December 12th. You can use the NOW function to calculate how many calendar days are remaining between today and the deadline. The formula would look like this:

  =12/5/99-NOW()

  If today is 10/12/99 at 1:45 PM, this formula returns 53.42725428 (remember, you have to format the results using Format, Cells and clicking the General category on the Number tab. There are 53 calendar days from today until the deadline. Tomorrow it will show 52 days. The numbers to the
right of the decimal represent time. Use the TRUNC function or one of the ROUND functions to remove the time

You can also use NOW to answer this question ... how long as an employee been with the ompany? If the date the employee was hired is 9/10/84 and is stored in cell C2 you would use this formula:

  =(NOW()-C2)/365.25

  Take NOW() minus the date hired divided by 365.25 (to account for leap years). Make sure you put the subtraction in parenthesis so it is calculated before the division.

  Note: The NOW function does not automatically update. It will update when the worksheet in initially opened. Use F9 to recalculate Did you find this tip useful? Check out the authors website for more and how you can by their new book. Navigate to >http://www.pcqna.com/Excel_Rounding.htm<
Return to top of Page
Return to Excel with Excel Index




Select Excel worksheets with the keyboard

SOLUTION: Press Shift+Ctrl+Page Down to select the current and next worksheet. Press Shift+Ctrl+Page Up to select the current and previous worksheet. Repeat to select additional worksheets.
Return to top of Page
Return to Excel with Excel Index



Microsoft's Internet Explorer 5.0
Search engineTip: Online search engines, not matter your favorite, return thousand of hits for what your looking for. No matter what browser you use, you can esaly find specific information by adding a few typed commands. For example; Add the metaword "url" to your search. For example,  if the word you're looking for is "sports," type URL:SPORTS (all lowercase) in the search field. Of course, you'll probably have to add other search criteria in order to limit the number of hits.

Other metawords include "title" (for finding pages with a specific word in their titles) and "domain" (for limiting searches to a specific domain, such as .org or .gov).


Download Internet Explorer 5.0
Update to Internet Exploreer 5.01
Or if you already have IE 5.0 select >Tools< from the menu bar, then select >Windows Update<.
Once at the site Internet Explorer will examin your current version and what you have for plugins and updates. Navigate to the critical update section when the process is completed
You will also find a section for a fix of the "Bubble Boy".virus...a VBScript nasty.
Downloaad will be from 8 MB to 17 MB depending on yuour slection.

Download the IE 5.0 rendering patch.

Repair Tool for IE 5.0
My IE 5.0 RepairTool doesn't work, what do I do?
 
 

PROBLEM: You've found a useful Web site and want to know what's the easiest way to locate other sites devoted to the same subject. The Solution

PROBLEM: You want to remove the headers and footers when you print data from a Web site using Internet Explorer. The Solution.

PROBLEM: You're looking for a quick way to change the Internet
Explorer security settings. The Solution!

PROBLEM: You want to reorder your Favorites list in Internet Explorer.
BROWSE YOUR HARD DRIVE FROM INTERNET EXPLORER
Wipe out the record of Web sites you've visited from the Address list
Locate other sites devoted to the same subject
Remove the headers and footers when you print data
Reorder your Favorites list

More bugs, more vulnerability. With increasing regularity, security holes are putting private data at risk. On Monday, October 11, 1999, Microsoft posted yet another security bulletin about an Internet Explorer bug that could let a malicious Web site operator read files on a visitor's computer. Click for more.




PROBLEM: You're looking for a quick way to change the Internet Explorer security settings.

SOLUTION: Double-click on the Internet globe (or other custom graphic) on the right side of the IE Status bar to display the Internet Security Properties dialog box.
Return to top of Page
Teturn to IE 5.0 Index



More coming:
Return to top of Page



View reviews and other information before clicking on the image below to download Netscape Communicator 4.7 the latest internet suite from Netscape, now under new management...America OnLine.

Check out Communicator's Quick Reference for tips on using your new Communicator Suite

Update to Netscape Communicator from 4.7 to 4.7.2 has arrived. Get it at ZDNet Software Library by clicking here. File is 18.21 MB.
Click here to learn more before downloading!

PROBLEM: You want to print a hard copy of your Netscape Communicator Address Book.

SOLUTION: Open the Address Book and choose File, Export. Select one of the available formats, then open the saved file with a word processor and print it.

PROBLEM: You're tired of new windows suddenly appearing when you're using Netscape Communicator.

SOLUTION: To disable the feature that automatically launches separate Web windows, choose Preferences, Advanced and uncheck the "Display JavaScript for Mail and News" option.

Problem: You recently upgraded from Netscape Navigator 3.0 to Netscape Communicator 4.7 and want to move your old address book to the new program.

SOLUTION: First, open the Address Book window in Communicator 4.7 and choose File, Import. Select "Communicator Address Book" at the prompt, then enter the name of your Navigator 3.0 HTML address book file.

Return to top of Page



Multimedia & Miscellaneous


PROBLEM: You want to create a screen capture of just one dialog box.



PROBLEM: You want to use an image file in several applications.What's the best file format?

SOLUTION: Both TIF and PCX formats are supported by all major graphics programs for Windows and Macintosh.
Return to top of Page



PROBLEM: You want to stop a CD from playing the moment you  insert it.

SOLUTION: Hold down the Shift key while you close the CD-ROM drive door. This will stop automatic installation from a software CD and prevent an audio CD from playing immediately.
Return to top of Page


PROBLEM: What are some quick ways to change Winamp settings while it's playing?

SOLUTION: Winamp, the free music player for Windows, is considered essential by most Internet music aficionados. The easiest Winamp shortcuts make use of the arrow keys. Up and
Down arrows adjust the volume, while Left and Right arrows rewind or forward the current song in five-second increments.
WinAmp is a part of Netscape Comunicator

Return to top of Page

Entertainment Government Technology

About

Email Me