Call us on 01223 214177 or email us
Hints and tips
Unless stated otherwise, these tips were written for MS Office 2010.
Founder Karen Roem began publishing weekly tips back at the beginning of 2003, as part of her quest to help users make the most of their computers and software. She says: “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. Below is an archive of tips I've cranked out so far. Feel free to reprint any of these (with full copyright and subscription information) in your newsletters and message boards.”
(To see the latest tip, please click here.)
Don't forget to add this page to your list of favourite pages; simply press CTRL + D. Alternatively, if you would like your own copy, please send a blank email to subscribe@roem.co.uk. (Tip subscribers are eligible for a 10% discount on Roem's standard, 'off the shelf' training held at their office in Cambridge.) We are registered with the Information Commissioner's Office (ICO) and will never sell or share our lists. So you can rest assured your details will be kept in strict confidence.
Got a tip of your own? Email us and we’ll share it; the bragging rights will last a lifetime!
- 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: Intuitive way to 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 people find the best time to schedule a meeting (Microsoft Outlook)
- Tip # 584: Warn before printing, saving or sending a file that contains tracked changes or comments (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)
- 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 upon your return from holiday (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 (Microsoft 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 e-mail signature for sending messages outside office hours (Microsoft 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)
- 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)
- 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 (Microsoft Excel)
- 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)
- 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)
- 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)
- 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)
- 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 (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)
- 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: Weekly Computer Tip # 249
- Tip # 248: Create a new folder on the fly (Office 2000-2007)
- 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)
- More tips
- top 10 tips of 2019
- top 10 tips of 2018
- top 10 tips of 2017
- top 10 tips of 2016
- top 10 tips of 2015
- Office 2000 - 2003 tips
- Shortcut archive
- Latest tip
Simply type a few descriptive words in the search box and hit the ENTER key to see a list of pages matching your search criteria. For example, type move bullet points to find one of the tips that seemed to strike a chord with lots of our subscribers.
I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.
