Hints and Tips : Office 2000-2003
What I often hear from my course participants is that they came away with new tricks, tips and shortcuts that they never would have found on their own. In my quest to try and help you make the most of your time while using your computer I began publishing weekly tips back in the beginning of 2003. Below is an archive of tips I've cranked out so far. Feel free to reprint any of the tips (with full copyright and subscription information) in your newsletters and message boards.
(To see our Office 2007 tips, please click here. Or why not have a look at the
top 5 tips, nominated by you.)
Don't forget to add this page to your list of favorite pages; simply press CTRL+D. Alternatively, if you would like to start the week with your own copy of this free computer tip covering ideas that help you make the most of your computer send a blank email to subscribe@roem.co.uk. I never sell or share the list, so you can rest assured your details will be kept in strict confidence.
Use this Search facility to find information held on this website. Simply type a few descriptive words in the search field and hit the ENTER key to see a list of pages matching your search criteria.
Your top 5 tips
- Tip # 215: match destination formatting (Microsoft Office)
- Tip # 214: keyboard shortcut to apply currency or percent format (Microsoft Excel)
- Tip # 213: quickly change to double-space lines in a document (Microsoft Word)
- Tip # 212: keyboard shortcuts to reset paragraph alignment (Microsoft Word)
- Tip # 211: quickly locate a person in your address books (Microsoft Outlook)
- Tip # 210: WIN is for shortcut (Microsoft Windows)
- Tip # 209: quickly jump to specific parts of your document (Microsoft Word)
- Tip # 208: insert a "switch off mobile phones" sound clip slide (Microsoft PowerPoint)
- Tip # 207: keyboard shortcut to add a web page to your list of favourite pages (Internet Explorer)
- Tip # 206: set default formatting properties of drawing objects (Microsoft Office)
- Tip # 205: turn off automatic completion of cell entries (Microsoft Excel)
- Tip # 204: add a scrolling ticker effect (Microsoft PowerPoint)
- Tip # 203: password protect your document (Microsoft Word)
- Tip # 202: align objects using the grid and guides (Microsoft PowerPoint)
- Tip # 201: quicky duplicate data from the previous row (Microsoft Excel)
- Tip # 200: Count the total number of words (Microsoft Word)
- Tip # 199: fill a range of cells with the same entry (Microsoft Excel)
- Tip # 198: examine your document's formatting (Microsoft Word)
- Tip # 197: prevent fractions to be converted to dates (Microsoft Excel)
- Tip # 196: quickly insert or delete characters in a field (Microsoft Access)
- Tip # 195: quickly add subtle animation effects (Microsoft PowerPoint)
- Tip # 194: click and type (Microsoft Word)
- Tip # 193: display your numbers with leading zeros (Microsoft Excel)
- Tip # 192: disable the Insert key (Microsoft Word)
- Tip # 191: translate words or phrases (Microsoft Office)
- Tip # 190: shrinking your presentations (Microsoft PowerPoint)
- Tip # 189: change the program you want to use to open specific kind of files (Microsoft Windows)
- Tip # 188: hide grouped messages (Microsoft Outlook)
- Tip # 187: organise your inbox using colour (Microsoft Outlook)
- Tip # 186: rename an e-mail attachment while inserting it (Microsoft Outlook)
- Tip # 185: customize your desktop (Microsoft Windows)
- Tip # 184: hide the master background of a slide (Microsoft PowerPoint)
- Tip # 183: start a new line of text within a cell (Microsoft Excel)
- Tip # 182: Center an object in the middle of your slide (Microsoft PowerPoint)
- Tip # 181: time-saving shortcuts (Microsoft Windows)
- Tip # 180: Using your mouse wheel to display text larger or smaller
- Tip # 179: Repeat a table heading on every page (Word)
- Tip # 178: quickly save all email attachments (Outlook)
- Tip # 177: specify which program is automatically used (Windows)
- Tip # 176: quickly insert trademark symbols (Microsoft Office)
- Tip # 175: save a slide as a picture (Microsoft PowerPoint)
- Tip # 174: setting up a different first page for you slide template (Microsoft PowerPoint)
- Tip # 173: quickly hide toolbars to increase page viewing space (Internet Explorer)
- Tip # 172: Create a log file (Microsoft Notepad)
- Tip # 171: finding a picture for your (PowerPoint) presentation (Google)
- Tip # 170: find the original item of a shortcut (Microsoft Windows)
- Tip # 169: remove an address from the Junk e-mail list (Microsoft Outlook)
- Tip # 168: printable list of your files and/or folders (Microsoft Windows commands)
- Tip # 167: quickly add horizontal lines (Microsoft Word)
- Tip # 166: Inserting an Outlook Contact Address into a Word Document (Microsoft Office)
- Tip # 165: techniques for running panic-free presentations (Microsoft PowerPoint)
- Tip # 164: Automatically open a form when you open the database (Microsoft Access)
- Tip # 163: Searching within a specific website
- Tip # 162: copy (or move) a worksheet to another workbook (Microsoft Excel)
- Tip # 161: resize an AutoShape to fit the text (Microsoft Word)
- Tip # 160: black out the screen during a presentation (Microsoft PowerPoint)
- Tip # 159: adjusting text within an AutoShape (Microsoft PowerPoint)
- Tip # 158: prevent AutoComplete suggestions from being entered (Microsoft Word)
- Tip # 157: turn off AutoComplete suggestions (Microsoft Word)
- Tip # 156: edit and format multiple worksheets ine one operation (Microsoft Excel)
- Tip # 155: keyboard shortcut to start slide show from current slide (Microsoft PowerPoint 2003)
- Tip # 154: navigate to a specific slide during a presentation (Microsoft PowerPoint)
- Tip # 153: navigate through your slides while presenting (Microsoft PowerPoint)
- Tip # 152: keyboard shortcut to go to the next or previous message (Microsoft Outlook)
- Tip # 151: export your data to Word or Excel (Microsoft Access)
- Tip # 150: speed up saving files with similar names (Microsoft Office)
- Tip # 149: quickly add a shortcut to a web page on your desktop (Microsoft Internet Explorer)
- Tip # 148: print a specific row or column as your title on every page of a printed worksheet (Microsoft Excel)
- Tip # 147: Stop Word Attachments from opening up in Reading Layout view (Microsoft Outlook 2003)
- Tip # 146: new shortcut to filter out unwanted data (Microsoft Excel 2003)
- Tip # 145: add a signature to a single email message (Microsoft Outlook 2003)
- Tip # 144: draw a perfect square or circle (Microsoft Office)
- Tip # 143: quickly move to the end of a range of cells in a row or column (Microsoft Excel)
- Tip # 142: Print a document or worksheet with comments showing (Microsoft Word and Excel)
- Tip # 141: apply formatting options to part of a cell's content only (Microsoft Excel)
- Tip # 140: nudging objects, such as AutoShapes. in small increments (Microsoft PowerPoint)
- Tip # 139: arrange information alphabetically, numerically or by date (Microsoft Word)
- Tip # 138: set up a slide show to run continuously for an exhibition information booth (Microsoft PowerPoint)
- Tip # 137: Add Google's free site search to your website
- Tip # 136: browse the Web faster and more easily using your mouse wheel (Microsoft Explorer)
- Tip # 135: make the toolbar's Print button automatically display the Print dialog box (Microsoft Office)
- Tip # 134: Problems resetting the font size or colour of the text of a mail message (Microsoft Outlook)
- Tip # 133: Print each report section on a separate page (Microsoft Access)
- Tip # 132: File a duplicate mail message into a folder (Microsoft Outlook)
- Tip # 131: Quickly insert moved or copied rows or columns between existing rows (Microsoft Excel)
- Tip # 130: Prevent a user from entering a date that occurs in the future (Microsoft Access)
- Tip # 129: Make Web pages available offline (Microsoft Internet Explorer)
- Tip # 128: Send replies to your email message to another address (Microsoft Outlook)
- Tip # 127: Adding AutoCorrect Entries (Microsoft Office)
- Tip # 126: Gathering information using voting buttons (Microsoft Outlook)
- Tip # 125: using wildcards in parameter queries (Microsoft Access)
- Tip # 124: Your Top Three Tips (Microsoft Office)
- Tip # 123: Undo your last entries (Or "how to get unstuck" in Microsoft Access)
- Tip # 122: Restore deleted items (Microsoft Windows)
- Tip # 121: Change search criteria on the fly using parameter queries (Microsoft Access)
- Tip # 120: Count the number of cells that meet a particular criteria (Microsoft Excel)
- Tip # 119: Useful Task Pane tricks (Microsoft Office 2002 and beyond)
- Tip # 118: Remove Reply to All button from toolbar (Microsoft Outlook)
- Tip # 117: Change the slide layout (Microsoft PowerPoint)
- Tip # 116: Delay Delivery of an Outlook Message (Microsoft Outlook)
- Tip # 115: Toggle the value in a check box (Microsoft Access)
- Tip # 114: Automatically convert number entries to a formula (Microsoft Excel)
- Tip # 113: quickly displaying the Clipboard Task Pane (Microsoft Office 2002/2003)
- Tip # 112: Comparing two copies of a document (Microsoft Word)
- Tip # 111: Pack your presentation to use on another computer (Microsoft PowerPoint)
- Tip # 110: View multiple worksheets at the same time (Microsoft Excel)
- Tip # 109: quickly change your computer's time zone (Microsoft Windows)
- Tip # 108: Finding text in an email message (Microsoft Outlook)
- Tip # 107: Finding and organising data using filters (Microsoft Access)
- Tip # 106: time-saving trick for entering data in a range of cells (Microsoft Excel)
- Tip # 105: Set all the folders on your computer to match the current folder's view settings (Microsoft Windows)
- Tip # 104: Quickly change your home page (Microsoft Internet Explorer)
- Tip # 103: Setting a follow-up reminder for an email message (Microsoft Outlook)
- Tip # 102: Displaying all records in form view (Microsoft Access)
- Tip # 101: Saving scraps of documents on the desktop (Microsoft Windows 7)
- Tip # 100: Calculating subtotals and grand totals in a list (Microsoft Excel)
- Tip # 99: Scheduling a meeting with people outside your company (Microsoft Outlook)
- Tip # 98: Setting a new default file location (Microsoft Office)
- Tip # 97: Copying records in Form View (Microsoft Access)
- Tip # 96: Assigning a macro to a button on your toolbar (Microsoft Office)
- Tip # 95: Send the current document, presentation or workbook as an email attachment (Microsoft Office)
- Tip # 94: Tips past, present and future
- Tip # 93: Keyboard shortcut to move cell pointer to last cell of a row or column (Microsoft Excel)
- Tip # 92: Automating repetitive tasks (Microsoft Office)
- Tip # 91: How to control bullet indentations (Microsoft Word)
- Tip # 90: Copy all formatting from one object to another (Microsoft Office)
- Tip # 89: viewing or changing the cells of a formula using the Range Finder (Microsoft Excel)
- Tip # 88: How to change page border margins (Microsoft Word)
- Tip # 87: Save a tree - tips on "green printing" (Microsoft Office)
- Tip # 86: Making the column width fit the contents (Microsoft Office)
- Tip # 85: Verify hyperlinks to other web destinations (Microsoft FrontPage)
- Tip # 84: using the Esc(ape) button on your keyboard (Microsoft Office)
- Tip # 83: Automatically create a new slide from titles of other slides (Microsoft PowerPoint)
- Tip # 82: Save multiple versions of a document in one file (Microsoft Word)
- Tip # 81: Create a custom fill series (Microsoft Excel)
- Tip # 80: Keyboard shortcut to display the Save As dialog box (Microsoft Office)
- Tip # 79: Using Google as a calculator
- Tip # 78: How to stop a frozen application (Microsoft Windows)
- Tip # 77: Ways to organise your Inbox - part II (Microsoft Outlook)
- Tip # 76: Ways to organise your Inbox - part I (Microsoft Outlook)
- Tip # 75: Adding a Subject to your email hyperlinks (Microsoft FrontPage)
- Tip # 74: Quickly copying the data from the previous record (Microsoft Access)
- Tip # 73: Switching between relative and absolute cell references (Microsoft Excel)
- Tip # 72: Using Google as a dictionary
- Tip # 71: Netiquette when emailing a large group of people (Microsoft Outlook)
- Tip # 70: Navigation keyboard shortcuts (Microsoft Excel)
- Tip # 69: Why and how to clear your "cache" (Internet Explorer)
- Tip # 68: Finding cells that have data restrictions (Microsoft Excel)
- Tip # 67: using natural language to specify dates and times (Microsoft Outlook)
- Tip # 66: Resize a picture (Microsoft FrontPage)
- Tip # 65: Restricting cell entries to specific entries in a list (Microsoft Excel)
- Tip # 64: Searching for clips in the Clip Gallery (Microsoft Office)
- Tip # 63: Apply a different design to your presentation (Microsoft PowerPoint)
- Tip # 62: Adding a "tooltip" to display when moving a mouse pointer over a picture (Microsoft FrontPage)
- Tip # 61: Adding a button to your toolbar (Microsoft Office)
- Tip # 60: Post information directly in a folder (Microsoft Outlook)
- Tip # 59: Create a hyperlink to open in a new window (Microsoft FrontPage)
- Tip # 58: Editing multiple worksheets in one operation (Microsoft Excel)
- Tip # 57: Shortcut key to quickly jump to the next misspelled word (Microsoft Word)
- Tip # 56: Using validation rules to ensure accurate data entry (Microsoft Access)
- Tip # 55: Updating the list of recently used documents on the File menu (Microsoft Word)
- Tip # 54: Quickly check recipient names before sending a message (Microsoft Outlook)
- Tip # 53: Quickly add to the end of cell contents (Microsoft Excel)
- Tip # 52: Displaying and printing formulas (Microsoft Excel)
- Tip # 51: Tricks and shortcuts for selecting blocks of text - part II (Microsoft Word)
- Tip # 50: Tricks and shortcuts for selecting blocks of text - part I (Microsoft Word)
- Tip # 49: Quickly enter a series of weekdays (Microsoft Excel)
- Tip # 48: Shortcut key to quickly return to your last edit point (Microsoft Word)
- Tip # 47: Customizing menus to display the full set of commands (Microsoft Office)
- Tip # 46: Arranging the Standard and Formatting toolbars (Microsoft Office)
- Tip # 45: Search the Web using Google without visiting the Google home page
- Tip # 44: Entering a Yes/No value in a check box on a form
- Tip # 43: Keyboard shortcuts for switching tabs from Normal to HTML to Preview (Microsoft FrontPage)
- Tip # 42: Removing items permanently when you delete them (Microsoft Windows)
- Tip # 41: Quickly go back to previous page (Microsoft Explorer)
- Tip # 40: Quickly repeating a formula down a column (Microsoft Excel)
- Tip # 39: Countdown to Christmas (Microsoft Excel)
- Tip # 38: Quickly switching to slide show view (Microsoft PowerPoint)
- Tip # 37: Quickly moving between multiple worksheets (Microsoft Excel)
- Tip # 36: Making sure text displays correctly on another computer (Microsoft PowerPoint)
- Tip # 35: How to quickly change columns to rows or rows to columns (Microsoft Excel)
- Tip # 34: Shortcut keys to quickly insert or delete a record (Microsoft Access)
- Tip # 33: Print a list of shortcut keys (Microsoft Word)
- Tip # 32: Using an equal (=) sign that isn't part of a formula (Microsoft Excel)
- Tip # 31: taking a snapshot of your screen
- Tip # 30: How to delete an entire message thread (Microsoft Outlook)
- Tip # 29: Opening multiple workbooks in one step by creating a workspace file (Microsoft Excel)
- Tip # 28: Shortcut key to quickly copy and align drawing objects (Microsoft Office)
- Tip # 27: How to quickly correct unwanted AutoCorrections (Microsoft Office)
- Tip # 26: using AutoCalculate to compute summary and statistical information in a worksheet (Microsoft Excel)
- Tip # 25: send a Web page in an e-mail message (Microsoft Internet Explorer)
- Tip # 24: Shortcut key to automatically insert a sum for a range of cells (Microsoft Excel)
- Tip # 23: how to know whether or not a virus warning is a hoax
- Tip # 22: Calculating a person's age (Microsoft Excel)
- Tip # 21: quickly switching between running programs (Microsoft Windows)
- Tip # 20: quickly closing all open documents (Microsoft Word and Excel)
- Tip # 19: Shortcut key to quickly vary the case of text (Microsoft Word)
- Tip # 18: Creating a chart quickly without using the Chart Wizard (Microsoft Excel)
- Tip # 17: Clippy gets clipped (Microsoft Office)
- Tip # 16: Make a sent message unavailable after a specified date (Microsoft Outlook)
- Tip # 15: Maximize, restore and close windows quickly (Microsoft Windows)
- Tip # 14: What to do if your browser's "Back" button isn't working (Microsoft Internet Explorer)
- Tip # 13: adding a company logo to every slide (Microsoft PowerPoint)
- Tip # 12: Function keys shortcut toolbar (Microsoft Word 2000)
- Tip # 11: navigating between worksheets (Microsoft Excel)
- Tips 1 to 10
Home
Training
Support
Clients
Contact Details
News
Disclaimer
© Roem Ltd. All Rights Reserved