Karen's Clever Clogs tip archive

As part of her quest to help you make the most of your computers and software Karen began publishing tips back at the beginning of 2003. Below is an archive of all tips. Use CTRL + F to quickly find tips by title or application (e.g. Excel), or visit the search page to find information held on this website.

To help you put these tips into practice Karen developed a series of 60-minute webinars, giving you the opportunity to see the hints, tips and time-saving shortcuts in action. The webinars were scheduled non-stop between 2020 and 2025, but will now only be held on request. Contact Karen on 07941 848326 or drop her a line.

See #CleverClogsTipTime on LinkedIn for more shortcuts, hints and tips.

It's a wrap - thank you and goodbye

• Tip # 761: Best of 2025 - top 3 tips
• Tip # 760: Tag your documents for easy retrieval (Windows 11)
• Tip # 759: Quickly access your most-used folders with Favourites (Microsoft Outlook)
• Tip # 758: Keep what you type - stop fighting Excel's AutoComplete
• Tip # 757: Copy slides between presentations after removal of "Reuse Slides" button (PowerPoint 365)
• Tip # 756: Get more done by reducing distractions using focus sessions in Windows 11
• Tip # 755: Reveal Formatting minus the keyboard acrobatics (Microsoft Word)
• Tip # 754: Easily add "Page X of Y" in Headers and Footers (Microsoft Word)
• Tip # 753: How to disable Table Formulas and use regular Excel Formulas instead (Microsoft Excel)
• Tip # 752: Keep your folders within easy reach with File Explorer's Quick access (Windows 10 and 11)
• Tip # 751: Create interactive filters using Slicers (Microsoft Excel)
• Tip # 750: Use Quick Steps to automatically clear categories when moving emails (Microsoft Outlook)
• Tip # 749: Top 4 of 2024
• Tip # 748: Highlight the column and row of the cell you're working in (Excel 365) Updated January 2025
• Tip # 747: Unlock the full potential of WIN + V
• Tip # 746: Tweak, save and apply your favourite view to other email folders (Microsoft Outlook)
• Tip # 745: Directly add a screenshot of any open window to your document or email (Word, Excel, PowerPoint and Outlook version 2010 and later)
• Tip # 744: Manage your data using checkboxes (Excel 365)
• Tip # 743: Change the way emails are displayed in the message list (Microsoft Outlook)
• Tip # 742: Three "Automatic replies" settings you might not be using, but probably would (new Outlook)
• Tip # 741: Display the name of the person who created a file (File Explorer)
• Tip # 740: How (not) to send a PivotTable report to a third party (Microsoft Excel)
• Tip # 739: Stop asking me to restore items from my last session - and other ways to customise Outlook
• Tip # 738: Force all changes to be tracked (Microsoft Word)
• Tip # 737: Undo send, move and delete for up to 10 seconds (new Outlook)
• Tip # 736: Best of 2023 - top 3 tips and more
• Tip # 735: Change automatic data conversion to suit your way of working (Excel 365)
• Tip # 734: Three reasons to use the Navigation Pane in Word
• Tip # 733: Always show formatting marks when typing email messages (Microsoft Outlook)
• Tip # 732: How to fix weird formatting and blank spaces (Microsoft Word)
• Tip # 731: Get in the habit of renaming new worksheets on the fly (Microsoft Excel)
• Tip # 730: Create an interactive table of contents slide (Microsoft PowerPoint)
• Tip # 729: Display an input message when you select a column or cell (Microsoft Excel)
• Tip # 728: Drum roll please (Microsoft PowerPoint)
• Tip # 727: Display different time zones when you hover over the date on the taskbar (Windows 10)
• Tip # 726: Various ways to flip through your open windows (Microsoft Office)
• Tip # 725: Stop using complicated formulas when there's an easier way (Microsoft Excel)
• Tip # 724: Workaround to keep cancelled meetings in your calendar (Microsoft Outlook)
• Tip # 723: Best of 2022 - top 12 tips
• Tip # 722: Check your document for issues and accessibility (Microsoft Word)
• Tip # 721: Create your free personalised calendars (Microsoft Word)
• Tip # 720: Announce - or ask for - a break in MS Teams Chat using the new OREO emojis
• Tip # 719: Filter dates by month or quarter (Microsoft Excel)
• Tip # 718: Is your Outlook inbox an overstuffed, out-of-control beast?
• Tip # 717: Hide icons on a messy desktop (Microsoft Windows)
• Tip # 716: Capture all content on a long page from a mobile phone
• Tip # 715: Find text or shapes that are hidden, stacked, or behind other objects (Microsoft PowerPoint)
• Tip # 714: Automatically fit the width of all columns (Microsoft Excel)
• Tip # 713: Insert a list of named ranges (Microsoft Excel)
• Tip # 712: Protect your file from accidental changes (Microsoft Word)
• Tip # 711: Do not show deleted data in PivotTable slicers (Microsoft Excel)
• Tip # 710: Enable the F1 - F12 keys on a laptop
• Tip # 709: Split first name and double-barrelled surnames into separate cells (Excel 2013 onwards)
• Tip # 708: New location for the Outlook shortcut buttons - you cannot escape it! (Microsoft 365) Updated February 2023
• Tip # 707: Quickly and easily analyse data (Microsoft Excel 2013 onwards)
• Tip # 706: Add more automatic calculations to your Status Bar (Microsoft Excel)
• Tip # 705: Keyboard shortcut to edit and format text in a shape (Microsoft PowerPoint)
• Tip # 704: Set your homepage and start-up pages (Microsoft Edge)
• Tip # 703: Go hands-free with Word, Outlook - and perhaps PowerPoint (Microsoft 365)
• Tip # 702: Pause slide shows - even if they are automated (Microsoft PowerPoint)
• Tip # 701: Three ways to insert multiple rows (Microsoft Excel)
• Tip # 700: Hear a sound when you - accidentally - hit Caps lock (Windows 10)
• Tip # 699: Quickly insert the current date into your document (Word and Outlook)
• Tip # 698: Coming soon in Outlook
• Tip # 697: Filter while keeping your hands on the keyboard (Microsoft Excel)
• Tip # 696: Keyboard shortcut to jump back to your inbox (Microsoft Outlook)
• Tip # 695: Make delayed delivery of your emails work using Outlook Web Access
• Tip # 694: Indent the second line of a bulleted or numbered list with pictures or text rather than a bullet or number (Word, Outlook and PowerPoint)
• Tip # 693: Move rows and columns using drag and drop (Microsoft Excel)
• Tip # 692: Temporarily unmute yourself (MS Teams)
• Tip # 691: Show the day of the week in your Outlook calendar
• Tip # 690: Prevent your browsing history from being stored Updated August 2023
• Tip # 689: Search the way you would say it (Microsoft Outlook)
• Tip # 688: Enable dragging of fields in the PivotTable grid (Excel for Microsoft 365, 2021 and 2019)
• Tip # 687: Speed up saving files in your favourite folders (Microsoft Office 365)
• Tip # 686: Open PDFs directly in your favourite app
• Tip # 685: Add follow-up reminder text and column to an email (Microsoft Outlook)
• Tip # 684: Don't show the Start screen when opening Word, Excel or PowerPoint
• Tip # 683: Best of 2021 - top 11 tips
• Tip # 682: Make your transparent circles the default in all new files (Microsoft PowerPoint)
• Tip # 681: Increase your chance to recall your email message (Microsoft Outlook)
• Tip # 680: Quick way to open your Camera App (Windows 10)
• Tip # 679: Remove flagged messages from your For Follow Up folder using your keyboard (Microsoft Outlook)
• Tip # 678: Listen to Hazel, George or Susan stumble over mistakes in your draft email or document (Outlook and Word 365) Updated January 2024
• Tip # 677: Use Outlook's predefined filters to find that needle in a haystack
• Tip # 676: How to make sure hidden rows and columns are not copied (Microsoft Excel)
• Tip # 675: Ten useful keyboard shortcuts you can do with your spacebar
• Tip # 674: Add an animated GIF or meme to a slide (Microsoft PowerPoint)
• Tip # 673: Automatically move email messages from a particular company in a specific folder (Outlook)
• Tip # 672: Show weather in Celsius on the Outlook calendar
• Tip # 671: Comparing ways to move around the Outlook and Google calendar
• Tip # 670: Remove all speaker notes in one go (Microsoft PowerPoint)
• Tip # 669: Submit your ideas for improvements to Microsoft
• Tip # 668: Make your text cursor easier to spot in Word and Outlook
• Tip # 667: Quickly jump between multiple worksheets (Microsoft Excel)
• Tip # 666: Edit your document while previewing it (Microsoft Word)
• Tip # 665: Add a reminder from your taskbar
• Tip # 664: Have your favourite buttons easily accessible (Microsoft Office)
• Tip # 663: Turn on the underscored letter option (Windows 10)
• Tip # 662: Analyse your data - the easy way (Excel for Microsoft 365)
• Tip # 661: Attach a copy or a PDF version of an active document to an email message (Word, Excel and PowerPoint)
• Tip # 660: Colour-code appointments and meetings by words in the title (Microsoft Outlook)
• Tip # 659: Arrange windows side-by-side without being asked what to snap next to it (Windows 10)
• Tip # 658: Create an alphabetical drop-down list that automatically updates when data is added to your table (Microsoft Excel 365)
• Tip # 657: Ten ways to work faster using the Esc(ape) key on your keyboard
• Tip # 656: Refine your search by sender, date, subject and more - from one box (Microsoft Outlook)
• Tip # 655: Horizontal scrolling and other useful things you can do with your mouse wheel (Excel)
• Tip # 654: Close all open files and desktop app (Microsoft Word and Excel)
• Tip # 653: Transform your documents into interactive presentations, reports or newsletters (Word) Updated October 2025
• Tip # 652: Ten things you may not know about Comments (Microsoft Word)
• Tip # 651: Press / to jump back to the search box (Google Search)
• Tip # 650: A is for Appointments (Microsoft Outlook)
• Tip # 649: Fade pictures, shapes and text in and out using Morph (PowerPoint for Microsoft 365)
• Tip # 648: Make it easier to schedule a meeting with someone outside your organisation (Outlook)
• Tip # 647: Show the day of the week in the taskbar (Windows 10)
• Tip # 646: Convert bullet points into professionally designed layouts (PowerPoint for Microsoft 365)
• Tip # 645: Quickly raise your virtual hand during a meeting (MS Teams)
• Tip # 644: Show running applications and find recently opened documents (Windows 10)
• Tip # 643: Automatically insert page breaks when the content of a certain column changes (MS Excel)
• Tip # 642: Automatically search all mail folders in all mailboxes (Microsoft Outlook)
• Tip # 641: Nifty way to apply dd-mmm-yy format to a date (Microsoft Excel)
• Tip # 640: Search for a document containing certain words or phrases (Windows 10)
• Tip # 639: Set up a rule to delay delivery of all your emails (Microsoft Outlook)
• Tip # 638: Automatically start an application, such as Outlook (Windows 10)
• Tip # 637: Make part of a picture transparent (Microsoft Office)
• Tip # 636: Create and insert reusable pieces of content in a workbook (Microsoft Excel)
• Tip # 635: Six productive things to do with CTRL + N(ew)
• Tip # 634: Best of 2020 - top 10 tips
• Tip # 633: Turn a rectangular picture into a circle (Microsoft Office)
• Tip # 632: Set your shared drive as your default folder (Excel, PowerPoint, Word and Project)
• Tip # 631: Apply existing design to a non-branded presentation (Microsoft PowerPoint)
• Tip # 630: Insert content in the middle of the page by double-clicking (Microsoft Word)
• Tip # 629: Stop the traffic - part II (Microsoft Outlook)
• Tip # 628: Change case without using Formulas and Functions (Microsoft Excel 2013 onwards)
• Tip # 627: Keyboard toggle to mute and unmute yourself (MS Teams)
• Tip # 626: Stop receiving RSVPs from meeting requests (Microsoft Outlook)
• Tip # 625: Quickly jump to what you want to do (Microsoft Office 2016)
• Tip # 624: Create PivotTables - no know-how necessary (Excel 2013 onwards)
• Tip # 623: Spot the difference between two documents (Microsoft Word)
• Tip # 622: Clear all formatting and styles from selected text (Microsoft Word)
• Tip # 621: Automatically move messages where your name is in Cc out of your inbox (Microsoft Outlook)
• Tip # 620: Split first and last name into separate cells or combine first and last name in one cell (Excel)
• Tip # 619: Open several workbooks with a single click (Microsoft Excel)
• Tip # 618: Get trained!
• Tip # 617: Copy and summarise all meeting request responses (Microsoft Outlook)
• Tip # 616: Export a presentation to Word to use as a handout (Microsoft PowerPoint)
• Tip # 615: View and paste your copied items from one place (Windows 10)
• Tip # 614: Set a date using English words and formulas (Microsoft Outlook)
• Tip # 613: Magnify part of a picture on your slide (Microsoft PowerPoint)
• Tip # 612: Play a sound when pressing Caps Lock (Windows 10)
• Tip # 611: Round a number up or down to the nearest half (Microsoft Excel)
• Tip # 610: Open the emoji panel using your keyboard (Windows 10)
• Tip # 609: Use an intuitive keyboard shortcut to mark your email unread (Microsoft Outlook)
• Tip # 608: Create a drop-down list with text to ensure consistent data entry (Microsoft Excel)
• Tip # 607: Quickly add additional text on a slide (Microsoft PowerPoint)
• Tip # 606: Quick way to create a distribution list (Microsoft Outlook)
• Tip # 605: Modify Quick Parts to insert frequently used text, tables or pictures (Word and Outlook)
• Tip # 604: Enter text from a list of previous entries (Microsoft Excel)
• Tip # 603: Set the Print Screen key to open screen snipping (Windows 10)
• Tip # 602: Set the name of the person who created a file to be displayed in all folders (Windows 10)
• Tip # 601: Calculating a person's age (Microsoft Excel)
• Tip # 600: Open your Calendar by default (Microsoft Outlook)
• Tip # 599: Quickly insert a row at the end of a table (Word, Outlook and Excel)
• Tip # 598: Find and select all formulas (Microsoft Excel)
• Tip # 597: Save and insert frequently used tables (Word and Outlook)
• Tip # 596: Turn your mouse into a red, green or blue laser pointer (PowerPoint 2013 onwards)
• Tip # 595: Speed up navigation in a large workbook using named ranges (Microsoft Excel)
• Tip # 594: Quickly jump between the start and end of a row in a table (Word and Outlook)
• Tip # 593: Change the order of data in a chart and its legend (Microsoft Excel)
• Tip # 592: Remove redundant messages from your inbox using a shortcut (Microsoft Outlook)
• Tip # 591: Best of 2019 - top 10 tips
• Tip # 590: Create electronic sticky notes ( Microsoft Outlook)
• Tip # 589: Keyboard shortcut to move rows in a table (Microsoft Word)
• Tip # 588: Exclude data from your PivotTable report using Slicers (Microsoft Excel)
• Tip # 587: Flip through your worksheets (Microsoft Excel)
• Tip # 586: Quickly spot whether change tracking is on or off (Microsoft Word)
• Tip # 585: Set your work hours to help find the best time to schedule a meeting (Outlook)
• Tip # 584: Warn before printing, saving or sending a file that contains tracked changes (Microsoft Word)
• Tip # 583: Display your To-Do list for the week ahead (Microsoft Outlook)
• Tip # 582: Faster way to enter a formula using the numeric keypad (Microsoft Excel)
• Tip # 581: Search for and open your presentation as a slide show (Microsoft PowerPoint)
• Tip # 580: Organise and find email messages in your shared mailbox (Microsoft Outlook)
• Tip # 579: Collapse and expand the ribbon (Microsoft Office)
• Tip # 578: How to keep the first zero of a telephone number (Microsoft Excel) Updated October 2023
• Tip # 577: Make it easier to spot cross-references and other fields in your document (Microsoft Word)
• Tip # 576: Reduce the number of messages in your inbox (Microsoft Outlook)
• Tip # 575: See what styles are applied in a document (Microsoft Word)
• Tip # 574: Attach a PDF version of an active document to an email message (Word, PowerPoint, Excel)
• Tip # 573: Check the spelling of all worksheets (Microsoft Excel)
• Tip # 572: Show totals above a table column that match specific criteria (Microsoft Excel)
• Tip # 571: Quickly move a window from one monitor to another (Microsoft Windows)
• Tip # 570: Specify how many days to keep pages in history (Internet Explorer)
• Tip # 569: Don't ignore Clippy in disguise (Microsoft Office)
• Tip # 568: Go to a specific slide when delivering your presentation (Microsoft PowerPoint)
• Tip # 567: Improve readability by keeping certain words on the same line (Word and Outlook)
• Tip # 566: Quickly jump between the beginning and end of a document or email (Microsoft Office)
• Tip # 565: Find all occurrences of two spaces after a full stop and replace them with one (Word)
• Tip # 564: Top ten Microsoft Windows shortcuts
• Tip # 563: Answer and write prefixed comments below the original message text (Microsoft Outlook)
• Tip # 562: Fill all selected cells with the same text, number or formula (Microsoft Excel)
• Tip # 561: Total the data in a table (Microsoft Excel)
• Tip # 560: Open the right-click menu using a keyboard shortcut (Microsoft Office and Windows)
• Tip # 559: Best of 2018 - top 10 tips
• Tip # 558: Quickly switch between day, week and month views (Microsoft Outlook)
• Tip # 557: Send a copy of your calendar as an email attachment (Microsoft Outlook)
• Tip # 556: Find and insert a word with a similar meaning (Microsoft Office)
• Tip # 555: Quick way to view frequently used folder content (Microsoft Outlook)
• Tip # 554: Quick currency formatting fix (Microsoft Excel)
• Tip # 553: Flip through the tabs of a dialog box (Microsoft Office)
• Tip # 552: Insert today's date or current time (Excel and Access)
• Tip # 551: Manage interruptions by setting up specific notifications only (Microsoft Outlook)
• Tip # 550: Reuse a filename and toggle between beginning and end of a its title (Microsoft Office)
• Tip # 549: Close the active program without using your mouse
• Tip # 548: Replace a picture without losing its size and shape (Microsoft Office)
• Tip # 547: Create different headers or footers for odd and even pages (Microsoft Word)
• Tip # 546: 5 tips to prevent email overload upon your return from holiday (Microsoft Outlook)
• Tip # 545: Autocomplete formulas including its open bracket (Microsoft Excel)
• Tip # 544: Set up a second signature for sending messages outside office hours (Outlook)
• Tip # 543: How to put a zero in front of a number (Microsoft Excel)
• Tip # 542: Update all references in a long document (Microsoft Word)
• Tip # 541: Move to end of a range of cells in a row or column (Microsoft Excel)
• Tip # 540: Top ten Microsoft PowerPoint shortcuts
• Tip # 539: Jump to a specific date in Google Calendar
• Tip # 538: Top ten Microsoft Outlook shortcuts
• Tip # 537: How do I know if a table has been filtered? (Microsoft Excel)
• Tip # 536: Top ten Microsoft Word shortcuts
• Tip # 535: Top ten Microsoft Excel shortcuts
• Tip # 534: Trick to remember you changed your password
• Tip # 533: Easy way to convert formulas to values (Microsoft Excel)
• Tip # 532: Display the total number of messages in a folder, including those you read (Microsoft Outlook)
• Tip # 531: Move bullet points or text using a keyboard shortcut (Word and PowerPoint)
• Tip # 530: Move or copy cells using drag and drop (Microsoft Excel)
• Tip # 529: Best of 2017 - top 10 tips
• Tip # 528: Find email messages sent or received between certain dates (Microsoft Outlook)
• Tip # 527: Print specific rows and columns on each page (Microsoft Excel)
• Tip # 526: Save all pictures used in a document in a separate folder (Microsoft Word)
• Tip # 525: Select rows and columns in a table (Microsoft Excel)
• Tip # 524: Find email messages sent or received between certain dates (Microsoft Outlook)
• Tip # 523: Create a bulleted list in your workbook (Microsoft Excel)
• Tip # 522: Undo several actions in one go (Microsoft Office)
• Tip # 521: Preview and flick through the pages of your document (Word 2010 onwards)
• Tip # 520: Take control of your SmartArt Graphics (Microsoft PowerPoint)
• Tip # 519: Quick way to paste content of the clipboard into an email message (Microsoft Outlook)
• Tip # 518: Protecting your formulas (Microsoft Excel)
• Tip # 517: Change the colour of public holidays in your calendar (Microsoft Outlook)
• Tip # 516: Crop and resize images (Microsoft Paint)
• Tip # 515: Move a tab to a new window and show side by side (Internet Explorer, Chrome, Firefox)
• Tip # 514: Show changes and comments inline instead of in balloons (Microsoft Word)
• Tip # 513: Resize and position photos in SmartArt (Microsoft PowerPoint)
• Tip # 512: Find the best time to schedule a meeting (Microsoft Outlook)
• Tip # 511: Various ways to add a new slide to a presentation (Microsoft PowerPoint)
• Tip # 510: Reopen recently closed tabs (Chrome, Internet Explorer and Firefox)
• Tip # 509: Format dates to include the day of the week (Microsoft Excel)
• Tip # 508: Make it easier to spot the mouse pointer (Microsoft Windows)
• Tip # 507: Park your thoughts (Microsoft Outlook)
• Tip # 506: Fast way to start a bulleted or numbered list (Microsoft Word and Outlook)
• Tip # 505: Filter dates by month (Excel 2010 onwards)
• Tip # 504: How to get people to open your email (Microsoft Outlook)
• Tip # 503: Schedule your e-mail message to be sent at your preferred date and time (Microsoft Outlook)
• Tip # 502: Best of 2016 - top 10 tips
• Tip # 501: Change the emphasis of a SmartArt graphic by changing its direction (Microsoft Office)
• Tip # 500: How to delete all comments in a workbook (Microsoft Excel)
• Tip # 499: Only print the selected content of an email message (Microsoft Outlook)
• Tip # 498: Reveal, select and modify all text with similar formatting (Microsoft Word and Outlook)
• Tip # 497: Find and select all cells that contain a formula (Microsoft Excel)
• Tip # 496: Automatically move low-priority emails from your inbox (Microsoft Outlook)
• Tip # 495: Print the lines between rows and columns to make reading easier (Microsoft Excel)
• Tip # 494: Find and highlight all occurrences of a specific word or phrase (Microsoft Word)
• Tip # 493: Exit the program and close all open files after prompting you to save them (Microsoft Office)
• Tip # 492: Set the default colour of a hyperlink (Microsoft Outlook)
• Tip # 491: How to remove limitations of what is displayed in a cell (Microsoft Excel)
• Tip # 490: Temporarily hide page breaks, headers and footers (Microsoft Word)
• Tip # 489: 5 tips to prevent email overload upon your return from holiday (Microsoft Outlook)
• Tip # 488: Open Mail and Calendar in separate windows (Outlook 2007 onwards)
• Tip # 487: Edit your document while previewing it (Microsoft Word)
• Tip # 486: Create, store and insert frequently used text and graphics (Microsoft Word and Outlook)
• Tip # 485: Jump to a specific date in your calendar (Microsoft Outlook)
• Tip # 484: What to do when no search results are found (Microsoft Outlook)
• Tip # 483: Tile all worksheets and save the layout (Microsoft Excel)
• Tip # 482: Add check boxes to make it easier to select multiple files (Windows 7)
• Tip # 481: Prevent others from viewing a specific worksheet (Microsoft Excel)
• Tip # 480: Save the current document, presentation or worksheet as a PDF (Word, PowerPoint, Excel)
• Tip # 479: Bring back the menu bar (Internet Explorer and Firefox)
• Tip # 478: Find hidden rows and columns in your worksheet (Microsoft Excel)
• Tip # 477: Set a flag to remind recipients to reply by a specific date (Microsoft Outlook)
• Tip # 476: Stop AutoCorrect from capitalizing text following specific abbreviations (Microsoft Office)
• Tip # 475: Make text look like it was marked with a highlighter pen (Word and Outlook)
• Tip # 474: Filter data in a PivotTable and PivotChart using Slicers (Excel 2010-2013)
• Tip # 473: 10 tips for safe online banking
• Tip # 472: Quickly jump to specific parts such as pages, tables or pictures (Microsoft Word)
• Tip # 471: Add holidays to your calendar (Microsoft Outlook)
• Tip # 470: Best of 2015 - top 10 tips
• Tip # 469: Draw straight lines or arrows (PowerPoint, Word, Excel, and Outlook)
• Tip # 468: Change column width without changing the width of the table (Microsoft Word and Outlook)
• Tip # 467: Display the Auto Fill Options on the fly (Microsoft Excel)
• Tip # 466: Jump to and print just part of your document (Microsoft Word)
• Tip # 465: Keep the column width when pasting (Microsoft Excel) Updated March 2023
• Tip # 464: Specify the time to spend on a slide before advancing to the next (Microsoft PowerPoint)
• Tip # 463: Mouse techniques for selecting parts of a table (Microsoft Word)
• Tip # 462: Add additional data to an existing chart (Microsoft Excel)
• Tip # 461: Quickly access your Web browser history
• Tip # 460: Fast way to close a program that isn't responding (Microsoft Windows)
• Tip # 459: When replying to a message that is not in the Inbox, save the reply in the same folder (Microsoft Outlook) Updated January 2023
• Tip # 458: How to add, find and remove line breaks (Microsoft Excel)
• Tip # 457: Move email messages into a recently used folder (Outlook 2010-2013)
• Tip # 456: Change your picture on the Start menu and Welcome screen (Windows 7)
• Tip # 455: Delete tricks (Outlook, Word, PowerPoint and Access)
• Tip # 454: Print the lines between rows and columns (Microsoft Excel)
• Tip # 453: Attach a copy of an active document to an e-mail message (Microsoft Office)
• Tip # 452: Quickly delete empty rows (Microsoft Excel)
• Tip # 451: Keyboard shortcut to show a presentation on a projector (Windows 7)
• Tip # 450: Remove hyperlinks (MS Office)
• Tip # 449: Make reviewer names anonymous (Microsoft Word)
• Tip # 448: Format inserted rows or columns on the fly (Microsoft Excel)
• Tip # 447: In a hurry? Take a shortcut! (Windows 7)
• Tip # 446: Change the starting page number in the header or footer (Microsoft Excel)
• Tip # 445: Always check spelling before you send a message (Microsoft Outlook)
• Tip # 444: Jump to a specific application on the taskbar (Windows 7)
• Tip # 443: Display your flagged messages in a "For Follow Up" folder (Outlook 2010-2013)
• Tip # 442: Save time entering dates (Microsoft Excel)
• Tip # 441: Display the right-click drop-down menu using a key on your keyboard (Microsoft Windows)
• Tip # 440: Open and print your picture on one page (Windows 7)
• Tip # 439: Display the name of the person who saved a file (Windows Explorer)
• Tip # 438: Display multiple calendar months in the Date Navigator (Microsoft Outlook)
• Tip # 437: Find out how many working days are left in 2014 (Microsoft Excel)
• Tip # 436: Clear all formatting and styles from selected text (Microsoft Word)
• Tip # 435: Download your free calendar for 2015 (Excel 2007 onwards)
• Tip # 434: Display week numbers in your calendar (Outlook 2010-2013)
• Tip # 433: Use a keyboard shortcut to switch between open Excel workbooks (Microsoft Excel)
• Tip # 432: Exclude hidden slides from being printed (Microsoft PowerPoint)
• Tip # 431: Send links rather than attachments (Windows 7 and Outlook)
• Tip # 430: Print a single label, reusing a sheet of address labels (Microsoft Word)
• Tip # 429: Quickly format and enable filtering of your data (Excel 2007 onwards)
• Tip # 428: View multiple calendars at the same time (Outlook 2007 onwards)
• Tip # 427: Change the text font size, the easy way (Word, Outlook, PowerPoint 2007-1013)
• Tip # 426: Fast filtering (Excel 2010-2013)
• Tip # 425: Preview and flip through your open windows - part II (Windows 7)
• Tip # 424: Organise your inbox using colour (Microsoft Outlook)
• Tip # 423: Applying and modifying Heading Styles to titles and subtitles (Microsoft Word)
• Tip # 422: Print only one page of an email message (Microsoft Outlook)
• Tip # 421: Find files or folders that contain certain words in its title (Windows 7)
• Tip # 420: Find and delete all data but keep Formulas, Conditional Formatting and/or Data Validation (Microsoft Excel) Updated November 2023
• Tip # 419: Preview and flip through your open windows (Windows 7)
• Tip # 418: Print attachments without opening them (Outlook 2007-2010)
• Tip # 417: Make changes to your document from the Print Preview and Print page (Word 2010)
• Tip # 416: Copy an attachment and attach it to a new mail message (Outook 2007-2013)
• Tip # 415: Move or copy chunks of your document without using Cut and Paste or Copy and Paste (Word 2010-2013)
• Tip # 414: Insert moved or copied rows or columns between existing cells - the easy way (Excel 2007-2013)
• Tip # 413: Rename the subject line of an email message you received (Outlook 2007-2010)
• Tip # 412: Respond to an e-mail message with a meeting request (Outlook 2003-2010)
• Tip # 411: Quickly extend the selection to the beginning or end of the document (Excel, Word and Outlook)
• Tip # 410: Give the Snipping Tool its own keyboard shortcut (Windows 7)
• Tip # 409: Don't use your mouse to scroll (Internet Explorer and Firefox)
• Tip # 408: Turn your mouse into a laser pointer (PowerPoint 2010-2013)
• Tip # 407: How to change the shape of a picture (Office 2007-2010)
• Tip # 406: Search for messages sent to a particular person during a certain period of time (Outlook 2010)
• Tip # 405: Squeeze those last lines on a single page (Word 2007-2013)
• Tip # 404: Fit a worksheet on the printed page (Excel 2010-2013)
• Tip # 403: Adjust the formula bar to read or edit a large amount of text (Excel 2007-2013)
• Tip # 402: Managing interruptions (Outlook 2003-2010)
• Tip # 401: How to find (and replace) highlighted text (Word 2007-2013)
• Tip # 400: Pick up where you left off (Word 2003-2013)
• Tip # 399: See the data behind a specific value in a PivotTable report (Excel 2003-2013) Updated April 2024
• Tip # 398: Remove the underline from hyperlink text (PowerPoint 2003-2013)
• Tip # 397: Copy the content of a worksheet (Excel 2003-2013)
• Tip # 396: What's the fastest way to insert check boxes (Word and Outlook 2003-2010)
• Tip # 395: Show what cells are affected by or are affecting a certain cell
• Tip # 394: Quickly show (or hide) paragraph marks and other hidden formatting symbols (Word and Outlook 2003-2010)
• Tip # 393: How to revert back to the date that a document was first saved (Word 2003-2010)
• Tip # 392: How to quickly insert a comment in multiple cells (Excel 2003-2010)
• Tip # 391: Turn words, pictures or cells in a document into a hyperlink to a full-screen YouTube video (Office 2000-2007)
• Tip # 390: Count and/or print the lines in your document (Word 2007-2010)
• Tip # 389: How to change the view of all your Outlook folders (Outlook 2010)
• Tip # 388: F11 revisited (Excel 2007-2010)
• Tip # 387: Create a distribution list from a single e-mail (Outlook 2010)
• Tip # 386: Capture, edit, save and share snippets of your screen (Windows 7)
• Tip # 385: Inspect your document for tracked changes (Word 2007-2010)
• Tip # 384: Reset your browser's zoom level (Internet Explorer, Firefox)
• Tip # 383: Send a festive message to more than one person without revealing the recipients' addresses (Outlook 2003-2010)
• Tip # 382: Filter your fancy Reports without basing them on Queries (Access 2007-2010)
• Tip # 381: Remove - not just hide - tracked changes (Word 2007-2010)
• Tip # 380: Automatically start an application such as Outlook or - my favourite! - Sticky Notes (Windows 7)
• Tip # 379: Open a recent document that was closed without saving (Office 2010)
• Tip # 378: Download pictures automatically (Outlook 2003-2010)
• Tip # 377: Copy shapes in a straight line, on the fly (PowerPoint 2003-2010)
• Tip # 376: Reduce irrelevant search results (Outlook 2007-2010) Updated April 2023
• Tip # 375: How to find items on a messy desktop (Windows XP-7)
• Tip # 374: time-saving shortcut to select all cells in a row or column (Excel 2003-2010)
• Tip # 373: Create a Table of Contents without using Headings (Word 2003-2010)
• Tip # 372: Repeat a table heading on every page (Word 2003-2010)
• Tip # 371: Apply text formatting to a Memo field (Access 2007-2010)
• Tip # 370: Stop AutoFill (Excel 2003-2010)
• Tip # 369: Is F8 the new F4? (Word 2003-2010)
• Tip # 368: Using Google to get the weather forecast
• Tip # 367: Minimize all inactive windows (Windows 7)
• Tip # 366: add the file name and path to the header or footer (Word 2003-2010)
• Tip # 365: Close everything but Outlook itself (Outlook 2007-2010)
• Tip # 364: What happened to the Up button? (Windows 7)
• Tip # 363: Mark your out-of-date documents as "superseded" or "outdated" (Word 2003-2010)
• Tip # 362: disable transparency of the window borders (Windows 7)
• Tip # 361: turn the Auto-Complete List name suggestions off (Outlook 2003-2010)
• Tip # 360: Set all the folders on your computer to match the current folder's view settings (Windows 7 - 10) Updated 16 April 2024
• Tip # 359: Keep web pages within easy reach (Internet Explorer 7 and beyond)
• Tip # 358: Enter the current date and/or time into a worksheet (Excel 2000-2010)
• Tip # 357: Different ways to open a link in a new browser tab (Internet Explorer 7 and beyond)
• Tip # 356: Countdown to your special day
• Tip # 355: Tweak your SmartArt graphics (Office 2007-2010)
• Tip # 354: Disable to Mini Toolbar (Office 2007-2010)
• Tip # 353: Pimp your chart (Office 2003-2010)
• Tip # 352: Reuse formatting using the format painter shortcut (Office 2000 - 2010) Updated July 2024
• Tip # 351: Automating repetitive tasks (Microsoft Office 2000-2010)
• Tip # 350: Set a date using plain English (Outlook 2000 - 2010)
• Tip # 349: Update PivotTables and PivotCharts when you open the workbook (Excel 2003-2007)
• Tip # 348: Keep an eye on these totals (Excel 2003-2010)
• Tip # 347: Email the current document, presentation or workbook as a PDF attachment (Office 2007-2010)
• Tip # 346: One-click Quick Steps (Outlook 2010)
• Tip # 345: Assign keyboard shortcuts to symbols or special characters (Word 2003-2007)
• Tip # 344: Time-saving shortcut key to use Save As command (Office 2000 - 2010)
• Tip # 343: An oldie but a goodie - Format Painter(Office 2000 - 2010)
• Tip # 342: quickly open a Web page without first launching your browser (Windows)
• Tip # 341: automatically close an email after replying or forwarding (Outlook 2000-2010)
• Tip # 340: Switch to Word 2003 formatting (Word 2007)
• Tip # 339: Different ways to close your browser tabs (Internet Explorer 7 and beyond)
• Tip # 338: How to make desktop gadgets work for you (Windows 7)
• Tip # 337: Quickly change the size of your Explorer window (Windows XP - Windows 7)
• Tip # 336: Save your presentation so that it always opens in Slide Show view (PowerPoint 97-2007)
• Tip # 335: create and insert frequently used text and graphics (Outlook 2007)
• Tip # 334: Save time opening or saving files by customizing the Open and the Save As dialog boxes Office 2003 - 2007 using Windows XP
• Tip # 333: switching between open windows (Windows 7)
• Tip # 332: Quickly launch your favourite programs from your taskbar (Windows 7)
• Tip # 331: What to do if you need a chart in a hurry (Excel 97-2007)
• Tip # 330: arrange windows side-by-side (Windows 7)
• Tip # 329: find and highlight all occurrences of a word or number (Excel 2003-2007)
• Tip # 328: find and highlight all occurrences of a word (Word 2003-2007)
• Tip # 327: Quickly find and open your files or programs - wherever they are (Windows 7)
• Tip # 326: Make all cell content visible (Excel 97-2007)
• Tip # 325: happy birthday to us
• Tip # 324: Countdown to Christmas (Excel 2003-2007)
• Tip # 323: Copy a chart and paste it in Excel as a picture (Excel 2003-2007)
• Tip # 322: How to display all icons in the taskbar notificationa area (Windows XP)
• Tip # 321: Triage your inbox (Outlook 2003-2007)
• Tip # 320: Display today's date on your taskbar (Windows)
• Tip # 319: Trace the relationships between formulas and cells (Excel 2000-2007)
• Tip # 318: How to keep your documents within easy reach - part II
• Tip # 317: brighten up your Google homepage background
• Tip # 316: How to manage a large number of open documents and programs (Windows XP)
• Tip # 315: How to keep your documents within easy reach (Windows 7 - 10) Updated April 2024
• Tip # 314: Mark your document as draft, confidential or personal (Word 2003-2007)
• Tip # 313: Convince Excel you want to type July 2010 (Excel 97-2007)
• Tip # 312: Delete trick (Word 97-2007)
• Tip # 311: Sort your software programs alphabetically (Windows XP)
• Tip # 310: Drag cell contents to a different sheet (Excel 2003-2007)
• Tip # 309: Customize your Status Bar (Word 2007)
• Tip # 308: move text or bullet points with a single keyboard shortcut (Word and PowerPoint 2003-2010)
• Tip # 307: Display thumbnails of all open web pages in a single window (Internet Explorer 7)
• Tip # 306: quickly select a range of cells (Excel 2000-2007)
• Tip # 305: I spy with my little eye (Word 2003-2007)
• Tip # 304: quickly open a folder or document from within Internet Explorer (Internet Explorer)
• Tip # 303: Add a cover page (Word 2007)
• Tip # 302: finding posh synonyms (Office 2003-2007)
• Tip # 301: Turn off the startup and exit sound (Windows XP)
• Tip # 300: Insert Spanish characters using keyboard shortcuts
• Tip # 299: Insert international characters using keyboard shortcuts
• Tip # 298: Make your cursor more visible (Windows XP)
• Tip # 297: quickly book appointments or meetings longer than half an hour (Outlook 2000-2007)
• Tip # 296: quickly fill data down or to the right (Excel 2000-2007)
• Tip # 295: New year, new decade, new look (Windows XP)
• Tip # 294: Find even more needles in that haystack (Outlook 2007)
• Tip # 293: My favourite select trick (PowerPoint 2000-2007)
• Tip # 292: Find that needle in a haystack (Outlook 2007)
• Tip # 291: Insert pictures or shapes in the middle of your slide (PowerPoint 2003-2007)
• Tip # 290: Select text using your keyboard (Word 2000-2007)
• Tip # 289: Open your favourite web pages in one go (Internet Explorer 7)
• Tip # 288: quickly view specific dates in your calendar (Outlook 2000-2007)
• Tip # 287: Hide the arrow pointer during a slide show (PowerPoint 2000-2007)
• Tip # 286: Ditch the filofax and show the calendar by default (Outlook 2003-2007)
• Tip # 285: take a shortcut (Excel 2003-2007)
• Tip # 284: Top 10 keyboard shortcuts to create new items (Outlook 2003-2007)
• Tip # 283: spot the difference (Excel 2007)
• Tip # 282: Switch from one signature to another (Outlook 2003-2007)
• Tip # 281: Download Microsoft's free interactive 2003 to 2007 guides (Office 2007)
• Tip # 280: Rule one of email netiquette
• Tip # 279: keyboard shortcut to copy all formatting from one place to another (Office 2000-2007)
• Tip # 278: Using Google to track flight status
• Tip # 277: Quickly find buttons in the Office 2007 Ribbon Interface (Office 2007)
• Tip # 276: How to sort your folder list the way you want it (Outlook 2000-2007)
• Tip # 275: Count the number of words as you add or delete content (Word 2000-2007)
• Tip # 274: shortcut to log off your computer (Windows)
• Tip # 273: editing text in Print Preview (Word 2000-2007)
• Tip # 272: Close a window without clicking in the upper-right corner (Office 97-2007)
• Tip # 271: quickly rename or copy a file or folder name (Windows)
• Tip # 270: Automatically display the clipboard when copying items (Office 2007)
• Tip # 269: copy and paste multiple items gathered from various programs (Office 2003-2007)
• Tip # 268: convert an existing bulleted list to a SmartArt graphic (PowerPoint 2007)
• Tip # 267: Change the number of times you can click the Undo button (PowerPoint 2007)
• Tip # 266: improve legibility of your workbooks (Excel 2000-2007)
• Tip # 265: Switching between multiple browser tabs (Internet Explorer 7)
• Tip # 264: Find websites you visited in the past (Internet Explorer)
• Tip # 263: Searching for whole words only (Word 2000-2007)
• Tip # 262: Quickly close a dialog box (Windows/Office)
• Tip # 261: Quickly format text using your Mini Toolbar (Office 2007)
• Tip # 260: Turn words, pictures or cells in a document into a hyperlink to a website (Office 2000-2007)
• Tip # 259: Quickly jump between the various Outlook components (Outlook 2003-2007)
• Tip # 258: Quickly increase a list of numbers by one (Excel 2000-2007)
• Tip # 257: Quickly send an active document by email (Office 2003-2007)
• Tip # 256: Display two or more tables side-by-side on the desktop (Access 2003-2007)
• Tip # 255: Display an RSS feed in Outlook (Outlook 2007)
• Tip # 254: Make the background of a picture transparent (Office 2003-2007)
• Tip # 253: Set a prompt to open a file as read-only (Office 2003-2007)
• Tip # 252: setting calendar work days, times and holidays (Outlook 2000-2007)
• Tip # 251: Using Google as a currency converter
• Tip # 250: unhide all rows and columns (Excel 2000-2007)
• Tip # 249: searching for data using the new user-friendly Search box (Microsoft Access)
• Tip # 248: Create a new folder on the fly (Microsoft Office)
• Tip # 247: Use a picture as your desktop background (Windows)
• Tip # 246: Pin a file on the Recent Documents list (Office 2007)
• Tip # 245: select cells using your keyboard (Excel 97-2007)
• Tip # 244: Open an Office 2007 document in an earlier version of MS Office (Office 2000-2003)
• Tip # 243: Save documents by default in an old MS Office file format (Office 2007)
• Tip # 242: Faster form filling, using your keyboard
• Tip # 241: Display your open database objects in separate document tabs (Access 2007)
• Tip # 240: Show slide number x of y on every slide (PowerPoint 2000-2007)
• Tip # 239: Assign a keyboard shortcut to your desktop shortcuts (Windows)
• Tip # 238: Switch between displaying formulas and their values (Excel 2000-2007)
• Tip # 237: Make more space on your screen - minimize the ribbon (Office 2007)
• Tip # 236: Filter for unique values (Excel 2000-2007)
• Tip # 235: Quickly insert sample text (Word 2000-2007)
• Tip # 234: Keyboard shortcut to turn superscript/subscript on/off (Word 2000-2007)
• Tip # 233: Keyboard shortcut for replying to a message (Outlook 2000-2007)
• Tip # 232: temporarily hide data you don't want to see (Excel 2003-2007)
• Tip # 231: calculate the totals for numeric entries in a table (Word 2003-2007)
• Tip # 230: draw three concentric circles with text in each (Office 2003-2007)
• Tip # 229: Delete unwanted copyright symbols (Word 2003-2007)
• Tip # 228: Convert your Word documents to PowerPoint presentations (Office 2003-2007)
• Tip # 227: Customizing the Quick Access Toolbar (Office 2007)
• Tip # 226: Sort favorites by name (Internet Explorer)
• Tip # 225: Split first name and last name into separate cells (Microsoft Excel 2007)
• Tip # 224: Count the number of selected rows or columns (Microsoft Excel 2000-2007)
• Tip # 223: Quickly refresh data on a web page (Internet Explorer)
• Tip # 222: Remove a name from the automatic name fill-in list (Microsoft Outlook 2003-2007)
• Tip # 221: Save time typing web site addresses (Internet Explorer)
• Tip # 220: Selecting commands without using your mouse (Office 2007)
• Tip # 219: Keyboard shortcut for sending a message (Outlook 2000-2007)
• Tip # 218: Adding your favourite commands to the Quick Access Toolbar (Office 2007)
• Tip # 217: Rehearse and time the delivery of a presentation (PowerPoint 2003-2007)
• Tip # 216: locating your favourite Office 2003 commands (Microsoft Office 2007)
Office 2000-2003
• 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