|
|
Technologies Tricks |
|
|
Technologies Tricks |
|
MS-Office Tricks |
|
Microsoft
Word
When creating a table, you might end up with irregular columns
and rows that you find difficult to resize. Just select the
cells you need to resize and click on Table > Distribute Rows
Evenly or Table > Distribute Columns Evenly.
If you need to repeat certain words or phrases in your document, use the AutoText feature under the Insert command on your toolbar. First highlight the text you are likely to repeat, select Insert > AutoText, choose New and enter a name for the AutoText entry. Henceforth, each time you type the AutoText entry, Word 97 will display the original text automatically. Press [Enter] when the AutoText is displayed.
The blue-coloured, underlined-text format of URLs in a Word document makes them conveniently distinct on screen, but when you print out your documents they don't look good. To change URL formats, click on Format > Style. In the List box, pick All Styles, and scroll to Hyperlink. Then click on Modify and Format, and customise the format to your liking. Make sure the Add to Template box is checked and click OK.
If you wish to highlight a line with a bullet, Word 7.0 offers a
function with which you can automatically replace particular
characters in the beginning of the line with a special character
while entering. This is faster than getting to the menu bar and
selecting the Bullets and Numbering... option.
You can assign custom keyboard shortcuts to Word menu commands. Hold down Ctrl and Alt and press '+' on the numeric keyboard. The cursor will change to a special symbol. Selecting a menu command now will bring up the Customize dialog box. Press any key combination now to assign it ( the key combination ) to the menu command. If the selected combination conflicts with another menu command shortcut, Word will display a message below the key combination entry box
Copy the data that you want to duplicate. Hold down the [Ctrl] key and click on the destination cells. When all the destination cells are selected, press [Enter] to copy the original cell into all of the selected cells.
On opening a New Excel spreadsheet press F5 ( go to ) and enter the range X97:L97 then click on the OK Button. Press the Tab key once to put you in cell M97. Holding the Ctrl+Shift keys down, left click once on the chart button on the toolbar. You'll now have a full screen fractal landscape. You can fly around using the mouse and left and right mouse buttons to control your speed.
You can add a background to an Excel bar or line chart, Right-click on the plot area (the part behind the data points) and select Format Plot Area. Under the Patterns tab click on the Fill Effects button and Select the Gradient, Texture and Pattern tabs. You can even import a photograph under the Picture tab. When you're done, OK should be clicked twice.
To edit a chart, first select the chart you want to edit and choose the Chart menu to see a list of the wizard dialog boxes. Now select the one you want to work with.
To open Web-based spreadsheet, type or paste its URL into the File Open dialog box. Now select and copy the cells you want, in your spreadsheet.
While working in Visual Basic for Applications, you can make your code easier to read. Go to Tools/Options/Module and pick different colours for different kinds of code including keywords, comments and so on. Put some colour into that boring database!
You have a readiness indicator for your presentation slides -the Scroll Lock light. It lights up when your next slide is ready while you are going. through a presentation. To stop fiddling with your mouse in a presentation (it shows your nervousness), use the keyboard. The arrow keys, Page Up, Page Down, N (for next) and P (for previous) can be used for moving among the slides.
Check out the PowerPoint Central (under Tools Menu) for the slideshow on tips for PowerPoint and links to free PowerPoint goodies on Microsoft Web site. This requires an Internet connection. The PowerPoint Central feature can be automatically updated over the Internet.
The Pack and Go utility available on the Office 97 CD and also online; can be used for distribution of presentations for people without PowerPoint. Pack and Go stores the presentation in both PowerPoint 97 and PowerPoint 7.0 formats. This is the reason why the `unpacked' presentation is much larger than the original.
Font-o-mania could be a bit difficult at times. Palatino is a no-no in case you plan to take printouts of your presentation on PostScript printers. Use. Book Antiqua TrueType font instead - it looks very similar. To change all instances of a font in one go, select Replace Fonts in Format menu item.
Convert
your favorite PowerPoint 97 picture into a 'water - mark' so
that any text will display over it. Select a ClipArt picture,
choose Format, Picture and click the Picture tab. Click the down
arrow at the right of the list box labelled Color to expand it.
Create a macro with anything (or nothing) in it. Save it as Magic 8 Ball and place the macro on the tool bar. Change the button to the 8 Ball icon. Click on the new button and see what happens.
Forgotten what that table was all about? Not to worry-right clicking on a table in the Table list opens a Properties sheet. One of the properties, Description, is a free-form memo field that lets you jot down anything you need to remember about that table. You'll never be at a loss again.
Are you an Access 97 user who runs macros or does VBA programming? If you are, you can take command of the cursor. To change the cursor into the hourglass or `please wait' cursor, use the VBA command DoCmd.Hourglass True. To restore it to normal, use DoCmd.Hourglass False.
While working in Visual Basic for Applications, you can make your code easier to read. Go to Tools/Options/Module and pick different colours for different kinds of code including keywords, comments and so on. Put some colour into that boring database! |
Balance your tables