Tag Archives: Computer Use

Easily Set Column Width Using Autofit

Have you ever opened an Excel Worksheet only to see ##### in the columns? Yes? (And then perhaps thought it was broken? Umm – yep.)

The ##### symbols simply mean that the width of that column is not wide enough to fully display the values in that cell, so Excel displays ##### symbols instead.

You’ll see it with numbers and dates. It’s no good displaying 3,000 when in fact the number is 3,000,000! So Excel displays the #### symbols instead. So no, it’s not broken.

Secondly, widening the width of the column immediately displays all those values and makes the #### symbols go away. Which is of course what you will want to do straight away.

But don’t start changing the column width manually, repeatedly guessing at how wide to go. Instead there’s a very easy and quick way to display all those values.

Excel’s AUTOFIT feature is the solution.

Autofit allows you to automatically adjust the width of a column to match the contents of the widest cell in that column.

To use Autofit, double-click the right edge (see below) of the column header of the column you wish to autofit (the column header is the identifying letter at the top of each column, eg, A, B, etc). The column width then changes to match the widest cell content in that column.

Done!

 

 

 


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 orlet me know.

You’ll find more learning at Learning and Development.

Indent Non-Consecutive Paragraphs

Last Tech Tip we selected non-consecutive paragraphs and formatted them. This time we will indent them.

This applies to text in Microsoft Word and in Outlook Email.

To indent an entire paragraph or multiple paragraphs:

  1. Select the paragraph or paragraphs
  2. Press the Tab key (or Ctrl+M)

The paragraphs you selected indent.

Note: to reverse the indent, select the paragraph(s) and press Shift+Tab or Shift+Ctrl+M


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.

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.