Tag Archives: Tech Tip

Select Non-Consecutive Paragraphs and Format Them

When you’re formatting a long and unwieldy Word document (or email), it is useful to know some tricks that make the job  easier. One of these is selecting non-consecutive paragraphs and applying formatting to only those paragraphs.

To select non-consecutive paragraphs:

    1. Select your first paragraph
    2. Press the Ctrl key (hold it down)
    3. Select your next paragraph
    4. Keep the Ctrl key held down
    5. Select your next paragraph

Now apply formatting, being careful not to de-select the selected paragraphs.

Only the paragraphs you selected will be formatted.


For great time-saving tips, look up:
Being more efficient with your technology
Technology Information for Staff website

Was this tip helpful to you? Anything else you want to know? Got some suggestions? Please leave a comment below or let me know.

You’ll find more learning at Learning and Development.

Tech Tip: How Efficient!

What are the Top 5 things you can do to be more productive in Word, Excel, Outlook, etc?

Look up Being more efficient with your technology to find out!


For other great time-saving tips, look up:
Technology Information for Staff website

Was this tip helpful to you? Anything else you want to know? Got some suggestions? Please leave a comment below or let me know.

You’ll find more learning at Learning and Development.

The Crucial Shortcut to PowerPoint’s Slide Show View

Yesterday I had to make a last-minute emergency edit to a PowerPoint presentation after the audience had already come into the room. I managed to get it done but the wireless mouse wasn’t working properly, so getting back into Slide Show view in a hurry was proving to be a nightmare!

F5 key to the rescue!

Pressing F5 or Shift+F5 will take you straight into presentation view.

F5 starts the slide show from the beginning (ie, from the first slide)
Shift F5 starts the slide show from the current slide.

Write them down and stick them to your laptop because you WILL be grateful!


For great time-saving tips, look up:
Being more efficient with your technology
Technology Information for Staff website

Was this tip helpful to you? Anything else you want to know? Got some suggestions? Please leave a comment below or let me know.

You’ll find more learning at Learning and Development.

Disabling ‘auto play’ on social media

By following these steps, you will retain control over what you watch on your social media platforms.

Facebook:

  1. From the top right of Facebook, click and select Settings
  2. Click Videos in the left menu
  3. Click the dropdown menu next to Auto-Play Videos and select Off.

Twitter:

  1. Log in to your Twitter account
  2. Click on your photo in the top-right corner
  3. Click on Settings
  4. Scroll down and you will see “Video autoplay” (located under Content)
  5. Uncheck it.

Instagram: 

  1. Launch Instagram and navigate to your profile page
  2. Tap on the Settings cog (iOS) or the three dots (Android) in the top-right corner
  3. Scroll down to the Preferences section, find the “Auto-Play Videos” option, and uncheck the box.

Remove Duplicates in Excel

If you have ever needed to remove duplicates from a database in Excel, you will know how incredibly useful this tip is.

This is so simple and quick to use. Remove Duplicates does exactly what you’d expect — it removes the duplicates in any given range of data.

Excel’s Remove Duplicates tool is found:
– on the Data Ribbon…
– in the Data Tools section of the Ribbon.

BONUS: If you just want to highlight duplicates, you can do this using Conditional Formatting. The shortcut to get you there is Alt H L. (Or find it on the Home ribbon under Styles).

Thanks to Harvard Business Review for this tip.
If you have a Tech Tip suggestion, please let me know.


For great time-saving tips,
look up our tips on Being more efficient with your technology or look through the the Technology Information for Staff website.

Was this tip helpful to you? Anything else you want to know? Please leave a comment below.

You’ll find more learning at Learning and Development.