Tag Archives: Microsoft Office

Finding Commands or Help in Microsoft Office Programs

Do you ever find that you simply cannot find the command you’re looking for in a program? Or need help on how to do something? 

Well, in Microsoft Office programs (such as Outlook, Word, Excel, PowerPoint, etc) there is an easy solution right within the program.

Within the program (eg, Microsoft Word), at the right hand end of the Ribbon Tabs, there is a field containing the text Tell me what you want to do…

This image shows the Help field in Word

 

  1. Click into the Tell me what you want to do… field
  2. Type in what you wish to do
    – The program will list commands relating to your query
  3. Select an option
    or select Get Help on…

 


For other 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.

An Excel Formula to Avoid a #VALUE! Error

If you’re using Excel, this one may be for you.

In M15, you need a formula that multiplies quantity (in, let’s say,  K15) by price (in, let’s say,  L15), but the price column also contains text entries such as Out of stock.  So the formula K15*L15 is not satisfactory because when you multiply a number by a text value (such as “Out of stock”) you get the #VALUE! error.

You could use an IF function to check for text, but there is a shorter solution.

The N function has a single argument: a value. It returns the value if the value is a number, or 0 if the value is text.

So, in M15, use the formula =K15*N(L15).

Thanks to Able Owl Excel tips for this one.


For other 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.

When Excel Menu Icons Are Greyed Out

When you’re using Excel, do you ever find that the Ribbon and menu icons are inexplicably greyed out?

This can happen if you are in edit-mode in a cell (the cursor is blinking in a cell, waiting for you to enter something), or you have a dialog box open. It can also happen when you minimise an Excel workbook, then open a different one: if you were editing a cell in the first workbook (or have a dialog box open), you won’t be able to insert or edit anything in the second.

The solution is easy: hit the Esc key on the upper left corner of your keyboard.

Thanks to Able Owl Tips for this one.


For other 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.

Configuring Out of Office Reply for a Shared Mailbox

Do you manage a shared mailbox in Microsoft Outlook?

Now that it’s Christmas and you may be thinking about switching on Automatic Replies (Out of Office), doing so for a shared mailbox can be a real battle. Christmas is all about The Good News and there’s good news here too: there is an easy way to do this.

The easiest way to switch on Automatic Replies (Out of Office) for a shared mailbox is to do so through Outlook Web App.

This is actually pretty quick and straight forward, so don’t be put off by all the steps in the instructions below. Just forge on!

  1. Log in to Outlook Web App (OWA)
    – by following these steps
    – or by clicking this link

Now you are logged in to OWA, all you need to do is access the shared mailbox and switch on Out of Office.

2. Access the shared mailbox
Click your name in the upper-right corner of the OWA window
(a dialogue box appears titled Open Other Mailbox)
    –
Enter the name of the shared mailbox you’d like to add the Out of Office reply to, then click Open (the shared mailbox opens)

3. Switch on Out of Office
Click options in the upper-right corner (just below where your name was before you opened the shared mailbox)
Click set automatic replies
Set up your Automatic Reply, ensuring you consider replies to senders inside the organisation and outside the organisation
(to get started, click the radio button titled Send automatic replies)
– you can set an automatic start and end date/time if required
Click Save in the lower-right corner (it has a green tick next to it).
When you are finished, click sign out  in the upper-right corner.

If you have a Tech Tip suggestion, please let me know.


For other 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.

Copy Excel Column Width From Another Cell

If you are working in Excel and would like to match the width of a column to exactly that of another column (e.g., for consistency and clear communication), here’s how to do it.

Spoiler alert:
it’s all about using the Paste Special dialogue box.

In this example, let’s say you wish to adjust column B to have the same width as column A….

1. Select a cell in column A, and copy it with Ctrl+C

2. Select a cell in column B, and choose Home tab >Paste drop-down arrow >Paste Special… (Alt H V S)
– the Paste Special dialogue box displays

3. In the Paste Special dialogue box, choose Column widths (the third option from the top on the right), and click the OK button.

Note: You can paste multiple column widths at once, which is very useful when you want to set up a new worksheet with the same layout as an existing worksheet.

Thanks to Able Owl Excel tips for this one.


For great time-saving tips, look up our Archive of Tech Tips 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.