Archive | Uncategorized RSS feed for this section

Tame your computer – drag and drop with Excel

6 Jan

Happy New Year! Let’s make 2018 the year that you learn heaps and have fun doing so. Hopefully this tip is a good start and worth checking out …

As you know, there are many ways to move or copy cells in Excel. Perhaps you use CTRL + XCTRL + C and CTRL + V? Or are you a “right-mouse-clicker”? Perhaps you prefer the Cut and Copy buttons on the Home tab?  Or maybe you use AutoFill to copy values and formulas into adjacent cells?

But did you know you can also move or copy any cell into any worksheet location by using a drag and drop technique?

Here’s how:

Moving cells

  1. Select the cells that are to be moved.
  2. Point to the border of the selection and wait until the mouse pointer appears as a combination of an upward-pointing arrow and four-headed arrow.
  3. Press and hold down the mouse button.
  4. Drag the mouse pointer to the new location.
  5. Release the mouse button.

Copying cells

  1. Select the cells that are to be copied.
  2. Point to the border of the selection and wait until the mouse pointer appears as a combination of an upward-pointing arrow and four-headed arrow.
  3. Press and hold down both CTRL and the mouse button.
  4. Drag the mouse pointer to the new location.
  5. Release the mouse button and CTRL.

You can also move or copy between sheets by holding down the ALT key when dragging the content over the sheet tab.

By the way, the Paste Options button will not be displayed when you use the drag and drop method.

Related tips:
Copy the content of a worksheet

Tame your computer – specify your search

30 Oct

I hope you’re using the improved search that was introduced in Outlook version 2007? I don’t mean simply typing in the Search box, but using the different buttons to refine your search. For example, use the From button and click on Has Attachments and This Week to find any message from a certain person that you received this week (as long as it contains one or more attachments).

You might have noticed that the This Week drop-down list is restricting you to search for Today, Yesterday, This Week, Last Week, This Month, This Year and Last Year. So what if you want to search for a specific period?

Here’s how:

  1. Click in the Instant Search box in the top right hand corner or press CTRL + E.
  2. Type received:>=d/m AND <=d/m

For example, received:>=1/9 AND <=13/9 will find any emails that arrived between 1 and 13 September 2017.

If you did not find what you were looking for, click on the Try searching again in All Mail Items link at the bottom of the search results page.

Oh, and don’t forget that your 10 most recent searches are saved and can be found when clicking on the Recent Searches button on the Search Tools ribbon.

Related tips:
Find that needle in a haystack
Find even more needles in that haystack
Reduce irrelevant search results
Search for messages sent to a particular person during a certain period of time

 

Tame your computer – build a bullet list

23 Oct

Microsoft Excel does not have a built-in function to create a bulleted list like in Word, PowerPoint and Outlook. But during a course yesterday I found out you can create one using a nifty keyboard shortcut.

Here’s how:

  • Select the cell where the list is to appear.
  • Press ALT + 7 on the numeric keypad.
  • Type your text.
  • Press ALT + ENTER if you want to insert another bullet in the same cell.
  • Repeat steps 2 – 4.

With thanks to Alex for the tip inspiration!

Related tips:

Tip # 506: Fast way to start a bulleted or numbered list (Microsoft Word and Outlook)
Tip # 458: How to add, find and remove line breaks (Microsoft Excel)

Tame your computer – open another window

29 Jun

Would it be helpful to be able to move one of your browser tabs to a new window so that you can display it next to another window? In Internet Explorer you can press CTRL + N to open your current tab in a new window, but that will leave the original tab open as well. So why not move it to a new window and display it next to any other window?

Here’s how:

  1. Click on the tab and drag it downwards.
  2. Press WIN + right arrow or WIN + left arrow to “snap” the window to the right or left.
  3. Click in any other window of any of your open applications and press WIN + right arrow or WIN + left to display the windows side by side.

By the way, if you keep pressing the same keyboard combination, your window will go round in circles.  I cannot test this out as I don’t have two monitors, but apparently it even cycles through both monitors.

 

Tame your computer – slick ways to add slides

14 Apr

When you open PowerPoint, a slide appears with two “placeholders” – one for a title and one for a subtitle. There are various ways to add additional slides and they might be faster than your current method.

Here’s how:

  • Click on the New Slide button in the Slides group on the Home tab.

OR

  • In the slide pane on the left, click where you want to add a slide and press ENTER.

OR

  • Press CTRL + M.

The new slide in your presentation contains “placeholders” that you can use to build your layout, such as a bulleted list, table, charts, SmartArt graphics, pictures, movies and sound. You can select a different layout that might better accommodate the content that you plan to add to the slide by clicking on the Layout button in the Slides group on the Home tab. If you use the first option described above you can also do this “on the fly”, making sure you click on the drop-down arrow, not the New Slide button itself. Any subsequent slides will automatically get the layout from the previous slide.

There are obviously other ways that you can add slides to your presentation, such as copy (CTRL + C) and paste (CTRL + V) or duplicate selected slides (CTRL + D). And you can also quickly import slides from other presentations, but let’s make that the content for a future tip.

Related tips:
Tip 228: Convert your Word documents to PowerPoint presentations

Tip 268: Convert an existing bulleted list to a SmartArt graphic

Tame your computer – take a shortcut

19 Feb

Why use the mouse? Here are a few shortcuts that I find most useful:

Switch to Mail : press CTRL+1
Switch to Calendar : press CTRL+2
Switch to Contacts : press CTRL+3
Switch to Tasks : press CTRL+4
Switch to Notes : press CTRL+5
Switch to your Folder List : press CTRL+6
Switch to Shortcuts : press CTRL+7
Switch to Journal : press CTRL+8

Keyboard shortcuts may sometimes be unintuitive or hard to remember, but I “drip feed” a new shortcut  every week on my home page, to help you to boost productivity without reaching for your mouse. You can download a list of those published so far from http://www.roem.co.uk/inc/shortcut_archive.pdf. Where available, it links to a tip of the week.

Tame your computer – fancy filtering

21 Jan

Do you use dates in Excel? If so, you have probably at some point needed to display only those containing relevant information.

For example, you might want to filter out all deliveries you are expecting in February. Or all courses planned for March. You can obviously use Excel’s Find functionality (CTRL + F) to find a specific date. Or perhaps you use the Date Filters and select, say, Next Month. But did you know you can use the table’s Search functionality?

Here’s how:

1.       If necessary, create a table. (CTRL + T or CTRL + L, anyone?)

2.       Click on the drop-down arrow of the date’s column header.

3.       Click in the Search box and type (part of) your search term. For example, Feb.

4.       Press ENTER.

And no, this isn’t relying on you having entered your dates as, say, 16 February 2017. As long as the entries have been formatted as dates, this should work. And remember, there is no need to type the current year if the date you want to enter is part of this year. Simply type, say 16/2.  Perhaps have another look at tip 442.

Related tips:
Tip 358: Enter the current date and/or time into a worksheet  (http://roem.co.uk/tip_358.php)
Tip 426: Fast filtering (http://www.roem.co.uk/tip_426.php)
Tip 429: Quickly format and enable filtering of your data (http://roem.co.uk/tip_429.php)
Tip 442: Save time entering dates (http://roem.co.uk/tip_442.php)
Tip 474: Filter data in a PivotTable and PivotChart using Slicers (http://roem.co.uk/tip_474.php)