,

Your IP Address

what is my ip address?
Showing posts with label MS Office Tricks. Show all posts
Showing posts with label MS Office Tricks. Show all posts

Change MS Word 2007 Defualt Saving Format from .Docx to .Doc

Change MS Word 2007 Defualt Saving Format from .Docx to .Doc
Microsoft has introduced new formats with Office 07 that created lots of problems for users of Office 2003 or earlier and OpenOffice Users (OpenOffice currently does not support Office 07 formats)

The only thing you can do to prevent this

DEFAULT WORD SAVING FORMAT
Open Microsoft Word 2007
Click the “Office Button” (top left of your screen), then on the bottom of the list click “Word Options”
The “Word Options” window will open. Now click on “Save” in the left panel
Change the top option (in the right panel) “save files in this format” from “Word Document (*.docx)” to “Word 97-2003 Document (*.doc)“
Click “OK”
NEW CONTEXT MENU BLANK DOC DOCUMENT
Next thing you want to change need to be, the New Context Menu to make the Blank .doc document. So here is a reg file to do that. Note: There is a file embedded within this post, please visit this post to download the file.

ELIMINATE THE DOCX BLANK DOCUMENT
After applying it you may be seeing two options for word document. You can eliminate the .docx blank document through applying this file

Read more

Double Click's a Bust


When you double-click a cell, Excel opens that cell in Edit mode. This may or may not be a problem for you. If you get users inadvertently double-click and destroy data in Edit type without realizing what theyre doing, its a problem for you.
Fortunately, you can inhibit this behavior. Choose Tools, Options, then click the Edit tab. Next, deselect the Edit Directly In Cell option. Then, click OK to return to your worksheet. The next time somebody double-clicks a cell, Excel will just select the cell.


Read more

Shortcuts for Changing Fonts

If youre in a hurry, there's a quick, mouse-free way to adjust font sizes. By typing Ctrl-Shift-> or Ctrl-Shift-< you can increase or decrease, respectively, your font size next to the incremental values specified in the Font pull-down menu. For more pinpoint adjustments, press Ctrl-Shift-] or Ctrl-Shift-[ to increase or decrease, respectively, the font size through one point
Read more

Search and Replace


Youre likely familiar with the search and replace feature in your word processing application. This feature finds every instance of a particular word or phrase and replaces it with another word or phrase. Excel can also support this feature. If you misspell a name or must update a frequently used reference, use Search and Replace.
First, select Edit, Replace. In the Replace dialog box, enter the text you want to replace in the Find What text box. In the Replace With text box, enter the replacement text. Next, from the Search drop-down list, tell Excel whether you want to search through rows or through columns.
Deselect the Find Entire Cells Only option if what youre browsing for may be only segment of whats in a cell. Click Find Next, as well as Excel will get the first instance of the text for which youre searching. Click Replace All to change all references at once, or click Replace to select each occurrence individually.


Read more

Selecting a Line of Text without the Mouse

Having to reach for the mouse when youre typing always slows down your work. Here are a couple of useful keyboard shortcuts for selecting a single line of text in Word 2000: To select everything on a line to the right of the insertion point, press Shift-End; to select everything on a line to the left of the insertion point, press Shift-Home.
Read more

Selecting an Underline Style

Although it may seem such as overkill, you may be interested to know which you can choose from no less than 17 unique styles for underlining text in Word 2000. Choose Format, Font to open the Font dialog box, then click Underline Style and observe the myriad underlining possibilities. You can choose one of these underlining styles through selecting it and clicking OK to exit the Font dialog box.

Read more

Speed Up Your Typing with AutoCorrect

If you get yourself typing lengthy words again and again, you should consider setting up typing shortcuts, so you only must mode in segment of the word and Word fills in the rest. For example, if I must mode New Smyrna Beach (the town where I live), I just mode NSB; then I press the SPACEBAR, Word automatically spells out all the words.

Heres how I configured this shortcut:

On the Tools menu, click AutoCorrect. Select the Replace text as you mode check box.

In the Replace box, mode an abbreviation you will rememberâۉ€for example, NSB.

In the With box, mode the complete spelling of the word for example, New Smyrna Beach.

Click Add.

Repeat steps two and three to add additional terms, then click OK.

You can also use this tip to quickly mode peoples names, technical terms anything you want. And once you add a term to your AutoCorrect list, it also works in PowerPoint and Outlook if you use Word as your default e-mail editor.
Read more

Understanding Date Arithmetic


Most applications store dates as an integer and time as a decimal value. As a result, you can use simple calculations to create date- and time-specific values. For instance, to learn the number of days between two dates, you could use the simple formula
enddate - startdate
In a similar manner, you could return a date in the future through adding a value to a date in the form
startdate + days
Since one of your formula references contains a date, you may must format the cell containing the above formula as a Number cell to display the actual value.

Read more

Undo All Previous Actions

Most of us are familiar with the Undo button on the Standard toolbar. Clicking this button will undo your past actions. Unfortunately, its easy to forget every little process youve made, as well as consequently you may undo an action you meant to leave intact. If youd want to refresh your memory, simply open the Undo buttons drop-down list. Every action that is undoable is listed there. The Redo button has a similar drop-down list.
Read more

Easy Access to Functions


If you use lots of functions in Excel, you might want to know there is a simple and efficient way to enter functions without accessing the Insert menu.
Try using the keyboard shortcut--Shift-F3--which opens the Paste Function dialog box. From here you select the function category and then specify the actual function. Excel will display the functions arguments and hints about the function. Using the Paste Function dialog box, youll avoid typos and argument errors.

Read more

Adding a Calculate button

One feature missing from a button or menu in Word is the ability to calculate a string of numbers and paste the total at the end, i.e. you might have the sequence 49+88= in the text and want Word to calculate the sum for you.

This feature is available as a WordBasic command which can be added to a menu, toolbar, or shortcut key combination. To add the item to a menu, choose Tools, Customize, Menus. In the Categories list box, select All Commands, then highlight the Tools Calculate command in the Commands list box. Select a menu for it in the Change What Menu box and select a position in the Position on Menu box. Designate a menu item name in the Name on Menu box, then click the Add Button.
Read more

Using Negative Indents

One cool way to make your headings stand out from the body of your text is to offset them to the left of the body text margin; this is called a hanging heading. With hanging headings, a reader can quickly scan the left margin of your document and get a feel for how the work is organized. One easy way to make a hanging heading is to indent the heading line through a negative number, thereby moving the heading text into the margin. Click on the line containing the heading and choose Format, Paragraph. Under Indentation, enter a negative number in the Left box (try -.2 inch) and click OK.
Read more

Insert Accents and Special Characters in Word


If you are tired of the intricate steps involved in inserting accents and special characters, here is a quick and easy way.
To insert an accent or special character through typing a character code:
Click where you want to insert the accent or character.
Make sure the NUM LOCK is on.
Hold down the ALT key, as well as then, using the numeric keypad, mode the character code.
Here are some commonly used codes:

Read more

Add Links to Web Pages in your Files

SUMMARY: Here are two ways to add hyperlinks to WebPages inside your Microsoft Word 2000 documents.

Adding links to WebPages in your Microsoft Word 2000 documents is easy. Just mode in a internet address, starting with http:// and Word will automatically convert your link to a hyperlink.

However, would you want to mode in some text, such as "Link to my homepage", as well as have that text displayed in your document, instead of the actual URL? That, too, is simple. Click on the "Insert" button and choose "Hyperlink" (you can also press CONTROL-K). On the "Insert Hyperlink" dialog box that follows, click on the "Text to display" field and enter the text which you would such as visible in your document. Then, underneath "Type the file or Web page name", mode in the webpage to which you want the hyperlink to link. When you are done, press "OK" to close the dialog box and see your link inserted in your current document.
Read more

Automatically Hyphenating Documents

In our past tip, we showed you how to insert hyphens through hand into words. Keep in mind that these types of hyphens differ from those you would get just through pressing the Hyphen key--they disappear if they become unnecessary. Its also possible to have Word 2000 hyphenate your documents automatically. Go to Tools, Language, Hyphenation and select the Automatically Hyphenate Document check box. You may end up having to return to this dialog box to fiddle with the Hyphenation Zone (the quantity of blank space on the right margin necessary to require a hyphenated word) and the number of consecutive hyphens (having too lots of in a row makes for difficult reading). When you have these settings where you want them, click OK.
Read more

Better View of Worksheet

Ever wish you had a bigger monitor? Well, maybe you do not really need a bigger monitor--what you need is a bigger watch of your worksheet. Just choose View, Full Screen. Excel will display only your worksheet and the menu bar--everything else has been neatly tucked away out of watch. That means you can see more of your work. When youre ready to return to the average watch, choose Close Full Screen from the small floating toolbar that Excel displays during Full Screen watch. Or simply deselect Full Screen on the View menu.
Read more

Charts-- Selecting Different Types of Charts


In this series of tips, were examining the built-in chart features of Word 2000. By default, Word 2000 opens a simple chart that lists three types of data over four periods, but this is only one of an infinite number of possibilities for charts. The kind of data youre dealing with--and the way you want to present it--will dictate the formatting for your chart.
First, you must insert a chart through selecting Insert, Picture, Chart. You can then choose the kind of chart you want to use through right-clicking on the chart and selecting Chart Type. Youll see upwards of a dozen unique types of charts in the left column, more than we ever knew existed, including Doughnut charts (which unfortunately have nothing to do with measuring how delicious doughnuts are), Radar charts, as well as Column charts. Click on the charts in the left column, as well as on the right youll see a handy one-line description and several examples of what the chart looks like. The best thing to do when youre just starting is to experiment with unique chart types to see which best expresses the kind of data youre dealing with.


Read more

Custom Menus

If you determineyou do not such as the changes you made, or you delete a menu and you can not figure out how to get it back, you do not need to reinstall Excel. To return a menu bar or toolbar to its original settings, open the Customize dialog box through choosing Tools, Customize. Select the menu bar in question and click the Reset button. Doing so will return the menu bar to its original condition.
Read more

Edit Text in Print Preview

Sometimes when you watch a Microsoft Word document in Print Preview mode, you notice adjustments or edits youd want to make to graphics and text. Did you know you can make those changes while youre still in Print Preview mode? Heres how you do it:

Click Print Preview on the File menu.

Click the text in the area you want to edit. Word zooms in on the area.

Click Magnifier on the Print Preview toolbar. When the pointer changes from a magnifying glass to an I-beam, you can begin making your changes to the document.

To exit Print Preview and return to the past watch of the document, click Close

Read more

Fit Multiple Pages on One Page

SUMMARY: Heres how to fit more pages of your Microsoft Word 2000 documents on less sheets of paper.

Short on paper? You can have Microsoft Word 2000 print 2, 4, or more pages of your document on one sheet of paper. To attempt this trick, choose the "File" menu and select "Print". On the "Print" dialog box that appears, head to the bottom-right section of the window labeled "Zoom". Click the "Pages per sheet" pull down and select how lots of pages which you want printed on one sheet of paper.

Note that, especially if you want to print more than six pages per sheet of paper, your printer needs to handle 600 dpi or better. Most modern printers can handle this with ease, but if your printer is several years old, you should test this feature on draft documents first.

Read more