Monday, July 20, 2015

Using Shortcut Keys to Select A Range

I have moved all my blogs to my new website:  https://helpfulofficetips.com/2015/07/20/using-shortcut-keys-to-select-a-range/ From now on, all updates will be at the new site, and all links will take you directly to that site.  Please check it out!

Microsoft has developed several standard ways to select bits of text, objects, or files in most of their products.  The methods below are specific to text but apply to other objects as well.  After getting used to them in MS Office, try using them out to rearrange your desktop, or move multiple files from one folder to another.

  1. Drag:  Drag by clicking on the first part, then holding the mouse button down as you drag to the end of your selection.
  2. Double-click:  Double-click a word to select the word.  Sometimes a double-clicking an item, such as tab on the ruler or a menu icon, will open a new window with more formatting choices.  In Windows Explorer, double-clicking opens a folder or file.  
  3. Triple-click:  Triple-clicking a word will select the entire line of text or paragraph, whatever words fall between pressing "Enter" and pressing it again.
  4. Shift Click:  Hold down your shift button.  Start at the top of your range and click. Click again at the bottom of your range.  This also works bottom to top - it is simply telling the computer select everything between my two clicks.
  5. Shift Click with Cursor:  This is variation, if you don't want to use your mouse to drag.  It's especially handy in MS Excel.  Hold down Shift.  Click at the top.  Use the cursors or arrows on the right of your keyboard to move through your document.  Release shift when you have selected your range.
  6. Ctrl Click:  Select multiple items one at a time, with Ctrl click.  If you get one item by mistake, Ctrl click again to deselect.
  7. Select All:  Select everything in your document in most MS Office products from the Home tab>Select section>click the drop-down arrow next to Select.  On the Select menu, click Select All.  You may also Ctrl A for “All.” 


Thursday, June 11, 2015

PowerPoint Photo Album Shortcut

I have moved all my blogs to my new website: https://helpfulofficetips.wordpress.com/2015/06/12/powerpoint-photo-album-shortcut/From now on, all updates will be at the new site, and all links will take you directly to that site.  Please check it out!

An office was putting on a spur of the moment open house and wanted the computer screens to show photos from the previous year.  By spur of the moment, I mean 15 minutes from now.  A problem?  Not with PowerPoint’s built-in Photo Album shortcut.

To prep, get all your photos in one folder – I don’t think there is a limit.  The office I mentioned had over one hundred.  Also, pick some music if you have any mp3 files handy.  That’s all you need.  Oh, and a PC.  This shortcut is not available on Macintosh.

Open PowerPoint and save your document as Year in Review Photos or other appropriate name.

On the Insert tab>Images section>click on the Photo Album dropdown arrow.  Then select New Photo Album. 

 
The Photo Album window will appear. 
Click on the File>Disk button, and go to your photos.  Select all of them in the folder using one of these methods:

·         Dragging through them all
·         Ctrl-click each one
·         Click on the first one.  Hold down Shift and click on the last one.  This will select the entire range.
·         Ctrl-A to select all.

Now click Insert and PowerPoint will place the photos in the Pictures in Album section.  You may click on the photo you want to change and use the buttons to change the order, the orientation, the brightness or contrast.

Your photos are set, so In the Album Layout section, select how many photos per page.  If you want one photo per page and for the photo to fill up the page, select Fit to slide.  Frame shape is another option, although I usually use the default Rectangle.  In the Theme box, click browse and pick any theme.  You can change this easily later, so just pick the first one that catches your eye.

Now click Create and PowerPoint does all the tedious work for you.  You may need to add some text to the first slide.  Also, if you don’t like the Design, go to the Design tab and pick one you do like.

Every slide show needs a transition from slide to slide, so pick one.  I usually use “Fade” because it is professional and doesn’t draw attention to itself.  Depending on your slides, you may want to take this opportunity to use one of the obnoxious, er, I mean Dynamic Content transitions like Orbit.  To get to the unusual transitions, click the down arrow in the Transition to This Slide section.
We will not be sitting at the computer for this show, so we want the slides to advance automatically.  From the Transitions tab>Timing section, enter 5 seconds in the After box.  (Leave the On Mouse Click button checked in case you want to advance the slides before the automatic timing.)

The secret weapon in the Transitions tab is the Apply to All button.  Apply to All  - ALWAYS DO THIS LAST AND ALWAYS DO IT AFTER MAKING ANY CHANGES!  This applies your transition and timing to every slide.  Remember, you want people to look at your slides not your PowerPoint transitions.  Uniformity is good in this case.
  
Your Slide Show is complete now if you do not want to add any music.  Click on Slide Show tab>From Beginning to see your masterpiece!

Is it a little bland without background music?  One more simple step will fix that. 

Go to the first slide.  From the Insert tab>Media section, click on the arrow below Audio.  Select Audio on my PC.  Pick a song that sets the appropriate mood. Remember, earlier you saved your music in the same folder as your presentation.  Click insert and a speaker icon will appear on your slide and it should be selected (if not, select it). 

The Audio Tools tab will appear with the Playback tab.  In the Audio Styles section select Play in Background.  This will automatically change the settings to:
·        Start automatically with the current slide
·         Play Across Slides
·         Loop until Stopped
·        Hide the icon during the slide show


Review your Slide Show again by clicking Slide Show tab>Start Slide Show section>From Beginning.  You can always end the show with a right click.
 
Once you have done this a few times, you should be able to create a one hundred photo show in about five minutes.

Oh, and the office I mentioned, visitors loved the show and thought we spent hours on it.


Tuesday, June 3, 2014

Setting Excel's Default Date Format to Two-Digit, aka, mm/dd/yy


I have moved all my blogs to my new website: https://helpfulofficetips.wordpress.com/2014/06/03/setting-excels-default-date-format-to-two-digit-aka-mm-dd-yy/ From now on, all updates will be at the new site, and all links will take you directly to that site.  Please check it out!

I like using two-digit date formats on all my spreadsheets.  This way all the dates in columns will line up, more or less.  If you use a fixed font (like Courier) instead of a proportional font (like Arial), they will line up exactly but look ugly.  Your choice.

Let’s use a visual.  Let’s put January 1, 2014, and October 5, 2014,  and December 12, 2014, in some columns using different styles of date format.  Date format is defined by a placeholder in most programs.  “M” is month, “d” is day, and “y” is year.  (“h” is hour, and small “m” is minute, but that’s getting too detailed.)  The top row shows the format as you explain it to your computer:

Date
M/d/yy
M/d/yyyy
MM/dd/yyyy
MM/dd/yy
January 1, 2014
1/1/14
1/1/2014
01/01/2014
01/01/14
October 5, 2014
10/5/14
10/5/2014
10/05/2014
10/05/14
December 12, 2014
12/12/14
12/12/2014
12/12/2014
12/12/14
(I’ve left aligned the “Date” column, and right-aligned the others to make it look nice.)

Which date formats line up?

MM/dd/yyyy and MM/dd/yy

Which date formats give you the information you want in the least amount of space?

M/d/yy and MM/dd/yy

Which date format is lines up and takes up the least amount of space?

MM/dd/yy

You can set the format to this style in each Workbook, but clicking the range you want to format, then  select the more choices arrow in the Home tab>Number section.


In the Format Cells window>Category section, click on Date.  In the Type choice, select the appropriate format, as a reference Microsoft uses “03/14/12.”  Notice there is a small “Sample” window where it shows the “mm/dd/yy” format.  (Usually your computer just knows if you mean “m” month or “m” minute, so M and m are interchangeable in most programs, but not all.  Hmmm…. M&Ms sound good right now.)

This works great for individual spreadsheets, but I want to set up Excel so it will always default to this format on my computer.  (Warning:  when you customize the default format on YOUR computer, it only changes the default format on YOUR computer.  When you open the spreadsheet on another computer, it will use that computer’s default format.  The formatting is not saved in the spreadsheet.)

For this, you need to change the default date format for all Microsoft software, not just Excel.  And, of course, why would Microsoft make this easy and put in the Options for one of the programs?  Because they are Microsoft.  You must go to the Control Panel (Start menu>Control Panel in Windows 7 or hold down the Windows key and X>Control Panel in Windows 8.1).  Now click on Clock, Language, and Region>Region>Change date, time, or number formats.  (I bet that was the first thing you tried, right?)


You will now have the Region window>Formats tab showing.  Click on the drop-down arrow for short date and select “MM/dd/yy” and then click Apply.  Now whenever you open a spreadsheet on THIS computer, the default short date format is two-digit month, two-digit day, two-digit year.

Aren’t you glad you only have to do it once?  That is, unless you start using another computer.  In fact, I am writing this blog because I just got a new computer and I forgot how to do it.  If I forget next time, I'll just look it up here.

Tuesday, November 26, 2013

Use Excel and Word's Mail Merge to Print Mailing Labels

I have moved all my blogs to my new website: https://helpfulofficetips.wordpress.com/2013/11/27/use-excel-and-words-mail-merge-to-print-mailing-labels/ From now on, all updates will be at the new site, and all links will take you directly to that site.  Please check it out!

First, create a basic mailing list in Excel of your friends and family.  You must include the headers for each column.  Here is an example:

Last First Address City ST Zip
Bennet Elizabeth 123 Pier Street Santa Monica CA 90401
Bennet Jane 2345 Colorado Avenue Santa Monica CA 90401
Bingley Charles 900 Wilshire Boulevard Westwood CA 90024
Darcy Fitzwilliam 601 N. Rodeo Drive Beverly Hills CA 90210






Save it and name it Mailing Labels.

Now open a new Word document  In the Mailings tab, click Start Mail Merge and select Labels. Have your box of labels handy and find the code.  Avery 5160 is the norm - that's the one with 30 labels per sheet.

To see your labels outlines, go to the Table Tools>Design tab that appeared in Word.  Click the Table Tools tab which appeared and select View Gridlines.

   
Now enter your "Merge Fields."  Put your cursor in the label.  Still on the Mailings tab, in the Write & Insert Fields section, select Insert Merge Field.  Click for the pull-down menu.  Select the merge fields and add the appropriate spacing.  (You can also add the spaces in later.)

<<First>> space <Last>>
<<Address>>
<<City>> comma space <<ST>> space space <<Zip>>

Your labels will look like this


Click Mailings tab>Write & Insert Fields section>Update Labels.


Now your labels will look like this:


To see your friends’ names, click Mailings tab>Preview Results section>Preview Results

You may adjust font, size, and spacing, use the first label only, then click Update Labels and your formatting will be copied to all labels.


Print one label on regular paper first, so you don’t waste the labels.  Most printers will have a little graphic that explains which side up or down, top or bottom.

Monday, November 11, 2013

MS Word: Resetting the Page Number in the Middle of your Document

I have moved all my blogs to my new website: https://helpfulofficetips.wordpress.com/2013/11/11/ms-word-and-resetting-the-page-number-in-the-middle-of-your-document/ From now on, all updates will be at the new site, and all links will take you directly to that site.  Please check it out!

A co-worker was struggling with starting the first page of Chapter 1 of a document being page 1.  The title page and table of contents were not supposed to be numbered.  What to do?  Word has the most annoying outline and page numbering systems ever invented IMHO.

Use a normal footer on your first page to start, even if that page is your title page or lists your contents.  It will default to page 1, of course.

Now, put your cursor at the end of your last non-numbered page, let's say the table of contents.  DO NOT put it at the beginning of Chapter 1 or you will end up with an extra (and blank) page 1 after these steps. 

Click on the Page Layout tab>Page Setup section>click on Breaks’ drop-down arrow.
 







Then click Next Page.














Now, you can select the page number on the next page and change its format.  Drag through the page number and right click.  Select “Format Page Numbers.”  In the Page Number Format window, select the “Start at:”  and “1” and OK.


Now go back to your page number on the title page and/or Table of Contents and delete or change the formatting to “i, ii, iii” for those sections.  (Everyone will be very impressed if you use little Roman numerals - just don't tell anyone you can't find the Roman numerals on your keyboard.)

Monday, September 16, 2013

Window(s) to My Documents - Moving Shortcuts into My Documents Folder

I have moved all my blogs to my new website: https://helpfulofficetips.wordpress.com/2013/09/16/a-windows-to-my-documents-moving-shortcuts-into-my-documents-folder/ From now on, all updates will be at the new site, and all links will take you directly to that site.  Please check it out!

In a previous post "Windows: Creating Shortcuts on your Desktop," I showed you how to move documents and folders to your Desktop.  That way, in the Explorer Window you could just click Desktop in Favorites and see your "favorites" - at least see a shortcut to them.

The problem is that leads to a very cluttered Desktop.  I only keep a few programs and shortcuts to my very, very favorite folders there.  I'd rather keep my real desk cluttered, not my virtual desk, right?

That why the Documents folder in Libraries is so helpful.  As I mentioned previously, DO NOT put your actual documents there - just a shortcut.  Otherwise, you'll end up with multiple versions of the same document, and who wants that?

In Explorer, right-click your folder or document - I only use this for folders.

Select Create shortcut.  This will create a shortcut in the same folder.  Drag the new shortcut folder - NOT the original, the one that says "shortcut" into your Documents folder in Libraries.  You don't have to change to a new window; you may drag from right where you are.

Now click on Documents.  You will see your shortcut.  Now you may rename it and remove the word shortcut if you'd like.



The little shortcut arrow will be there to remind you.

MS Word - Adding File Name, Path, Revision Date to your Document

We are in a reorganize mode at work and trying to print out every current document that we use both internally and hand out to clients.  We realized that merely printing the documents wouldn't help if we couldn't go back and find the document.  So...  how do you show where the document is on your huge network drive?

For this example, let's put all the information in the footer.

Open the document.Double click on the Footer or Footer area.
Go to spot where you want your new information, probably above any existing footer.

File Name and Path
where to find the document on your computer



  • On the Insert tab>Text section>Quick Parts drop down, select Field
  • In the Categories drop down menu, select Document Information.
  • Then select FileName.  Format: None.
  • In the Field Options section, select “Add path to filename” and click OK.




This will add the path and file name to the document, as shown at the bottom of this blog.

Revised Date
the date of the last time the document was saved

Now, we don't want to have the date it was last printed which would always show today's date.  We want the last date the document was saved, usually when changes were made, in other words the last time "Revised."

  • Go to the spot in your footer where you want this date.
  • Type “Revised” and press space.
  • On the Insert tab>Text section>Quick Parts drop down, select Field
  • In the Field Window, pull down the Categories menu to Date and Time.
  • Select SaveDate (the last time the document was saved or revised).
  • For Date formats, select your favorite or your company's approved format.  For my company, that means “Mmm. d, yy” format.  For example, Dec. 25, 2013.


The last date saved in inserted in the document as the revised date.

Make all your formatting corrections to your new footer, and there you go.
My current footer looks something like this:


c:\AdminAssistTips\MS Word\Adding File Name Path Revision Date to Your Document.docx Revised Sep. 16, 13