[May 15, 2008]
It has been a very difficult couple of weeks around our household. My mother-in-law has been very ill and passed away on Wednesday, April 24, 2008. She was a very good person and a great mother-in-law. Please say a prayer on her behalf.
On Sunday, April 27th, my cat became ill and I had to rush her to the emergency vet. They are currently treating her for a viral infection or a liver problem so please think a good thought for her. She is only four years old and I am very attached to her. She showed up one day a year or so ago and adopted us. She stayed outdoors until it started to get cold and I couldn't bear the thought of her being outdoors in the Winter and brought her inside. The rest, as they, is history...I apologize that there was only one newsletter in April because of the upheaval in the Bratt household.
By the way, since I started this newsletter, I am happy to report that Ms. Kitty is home and doing very well!
Let's welcome Henry, David, Joyce, Clive, Joe, and Pedro, our newest premium subscribers thus far this month. Welcome to the family and thanks for your support!
Let's get to the tips now!
Table of Contents
Automatic Creation of Hyperlinks in MS Excel - How to Stop them!!!
Display Only the Days you Want in your Outlook Calendar - Get Rid of the Extraneous Stuff!
Summing it up with Two Keys in MS Excel - It couldn't be any easier!
Automatic Creation of Hyperlinks in MS Excel
At times, it can be a real problem when an URL is entered into a cell and MS Excel automatically creates a clickable hyperlink. There may be times when you would like to disable that particular feature. Preventing the automatic creation of hyperlinks can be accomplished by three different methods.
Follow the steps below to learn how:
From version 2000 forward, the automatic creation of hyperlinks can be disabled by reconfiguring the AutoCorrect settings by following these steps:
- Click on Tools | AutoCorrect.
- Click the AutoFormat As You Type tab.
- Under Replace As You Type, uncheck Internet And Network Paths With Hyperlinks.
In version 2003, you will be given the option of turning off this AutoCorrect feature with the action dialog that appears after entering the first URL.
Another solution is to enter the URL into a cell as a label, which will prevent the automatic creation of a hyperlink. A label is indicated by preceding the cell entry with an apostrophe, such as 'http://www.carolscorneroffice.com.
There is another, far more complicated solution that uses VBA code, but I will not go into it in this newsletter as it deals with creating a macro with VBA code.
Display Only the Days you Want in your Calendar
The default in the MS Outlook Calendar is to display all of the days of the week for you. For whatever reason, however, not everyone wants to see those days in their calendars. And sometimes they get a little cranky about having to look at them every single day.
Turns out it is easier than you would have thought to change all that! We don't need anymore crankiness in the world now do we?
Follow the steps below:
- First, launch MS Excel and open the Calendar.
- Secondly, click on File | View.
- Select Work Week.
Notice the difference in the screen in front of you since you selected Work Week View.
- Now, in the upper right-hand corner, you will notice a small calendar view.
- Simply, highlight the specific days that you would like displayed in your calendar. If you find that you are having difficulty, simply hold down your CTRL key while you select your days.
You will now have only the days you selected displayed in your Outlook Calendar.
There is no end to how you can customize things to your liking in MS Outlook!
Summing it Up with Two Keys in MS Excel
Most of you are familiar with the AutoSum feature in MS Excel and find it very handy indeed. All you have to do is click that icon on your toolbar and bingo! your formula for the sum of a data range is located just above whatever cell you have selected.
I know that there are lots of folks out there like me who prefer to use the keyboard as much as they can because we like fewer keystrokes and saving time! So if you are one of those folks, here is another quick and easy way to sum in MS Excel.
- Select the cell below your column of data
- Then simply click ALT + = (Alt, plus the equal sign).
Ta da! The formula needed to sum up the column of data is inserted with the cell references in place, just as if you had clicked the Autosum icon on your toolbar.
Included in the Premium Newsletter:
- Undoing in Microsoft Office
- Default Folder for Saving in MS Office
- Converting Dates in MS Excel
- Narration in your PowerPoint Presentation
- Free Hide Folder Utility!
Carol's Corner Office members receive the premium edition of the Word Bytes Newsletter. To become a member click HERE.