How to fix a list with numbers in WORD

Often when we create multiple lists in a word document, and choose to number the multiple lists (versus using bullets) Word sometimes get confused and will use “continued numbers” versus starting each list with a new series of numbers and/or letters.

So instead of each list having it's own independent set of numbers and/or letters, the numbers or letters from the previous list continue with the next new list we create: for example, one list contains items numbered 1-4 or a-e, and then your next independent list starts may start numbering at 5 instead of restarting at 1, or letter f instead of a)

When this happens and you want different numbering for each new list:

1. just right-click inside the second list and choose "Restart Numbering" from the pop-up action menu that appears OR
2. at the end of your first list, go to the your toolbar or ribbon and "turn off" the numbering command

Sorting Data in Excel

Excel makes it very easy to sort data that is entered in multiple columns, by using the SORT buttons (A-Z or Z-A)… So be sure when you are entering your data, to put information in as many individual columns as possible – In my opinion you can never have too many columns to sort data with..

Make sure before you give the command to SORT that you have highlighted the active sheet, so that all information in the columns and rows will then “move” when the information is sorted…

Excel Sort Data by One Column:

• Select all the cells in the list
• Choose Data>Sort
• When the Sort Dialog Box opens, be sure to check off that your list has a “header row” so you will see the data – not the column ID letter
• From the Sort by dropdown, select the column you want to sort. Note: If the dropdown is showing Column letters instead of headings, change the setting for My list has, from No header row to Header row.
• Select to sort in Ascending or Descending order

Excel Sort Data by multiple Columns:

Such as when we are entering data for our contacts to prepare a mailing list – we might want to sort by Last Name, First Name and then Spouses Name which are in 3 three columns. So we will sort it all at once, but giving different levels 1 would be Last Name; 2 would be First Name and then last the Spouses Name…starting with the most important sort.

• Select all the cells in the list.
• Choose Data>Sort
• When the Sort Dialog Box opens, be sure to check off that your list has a “header row” so you will see the data – not the column ID letter
• From the Sort by dropdown, select Last Name.
• From the Then by dropdown, select First Name.
• From the Then by dropdown, select Spouses Name.
• Click OK

Note about Excel 2007 and 2010

• The SORT BUTTON is on the HOME TAB to the far right in the Editing quadron and also in the DATA TAB in the Sort & Filter quadron
• When the Sort Dialog Box Opens you will see one SORT field, but you can add as many levels for sorting as you would like.…

DOWNLOADING PICASA 3

PICASA (a Google product) is a FREE award-winning software used for working with photos, on your PC, from emails, disk, CD-Rom and digital cameras.

**PICASA’S NEW VERSION 3, can only be used with Windows XP, Vista or Windows 7. If you are using an older “Operating System” such as Windows 98, 2000, ME, then you will continue to use Picasa Version 2

Downloading Picasa to your computer is quick and easy and again FREE - Just open your Internet and on the Internet address toolbar, type: http://www.picasa.com/

• Click on the button that says “DOWNLOAD PICASA”
• This brings you to a dialog box where you must choose whether to “RUN” or “Save” the file, Click “RUN”.
• Depending on your Internet service speed, this may take a few minutes
• Another dialog box will appear asking: Do you want to RUN the software? Click RUN
• The software should be installed on your computer. If you’re asked other questions, respond “yes” or “OK”. Picasa 3 will be installed on your PC
• Picasa then will search over your whole computer for pictures or merely look in the “MYPICTURES” directory. I prefer the MYPICTURES directory only, but you can choose whatever option you wish
• The Picasa Icon is now created and on your desktop (and you can add it to your Quick Launch)
• The Picasa Media Detector should be installed on the system tray in the taskbar toolbar. This is necessary so that Picasa 3 can add any new photos that are added to the MyPictures folder.

Picasa software allow you to:

• Create quick & easy photo Slide Shows- with or without music
• Easy to view Photo Library
• Numerous quick & easy photo editing tools including red eye reduction, cropping and changing photos form color to black & white or sepia
• Photos can be sorted by folder or timeline
• Great tools for printing - wallet, 4 x 6 or full page
• You can convert you photos to movies with sound & motion
• You can easily upload your photos to an online web album for easy sharing
• Or identify all "faces" in your photos for easy sorting-called tagging
• and much much more...

Once you have download the free software, like all Google products, there are great tutorials which will help you learn to use the software - or join us in class...

Cut - Copy – Paste

Once you master the skill of copying and pasting, so many things we do on the computer: working with emails, the internet-such as shopping & banking, directions; of course working with word processing - writing letters, recipes, flyers, invitations; saving to flash drives, portable hard drives, moving photos from our digital cameras to folders; burning CD's & DVD's; and much more, becomes so easy. So practice these skills often - and remember there are 5 different ways that you can activate the commands to cut - copy - paste...

TO CUT/COPY & PASTE:

• Select /highlight what you want to Cut or Copy
• Then activate CUT or COPY (any of 5 ways)
• Go to Where you Want what You’ve Cut or Copy to now be placed
  
  (To find your travel or portable hard drive-Open my computer & find the right drive; or open your email or open the software-Word, Excel, Power Point etc.)
• Then activate PASTE (any of 5 ways)

5 WAYS TO CUT, COPY OR PASTE…

1. MENU BAR: Go To Edit, left click on cut, copy or paste
2. ICONS: Use the cut, copy or paste/clipboard icons on your toolbar/ribbon
3. MOUSE: Use RIGHT CLICK-Be sure your mouse is on what you’ve highlighted & RIGHT CLICK; action menu will appear and now you can left click on cut, copy or paste/clipboard
4. KEYBOARD ACTION KEY: Use the Action/function key (bottom row, right of the shift bar before the CTRL key) and choose cut, copy or paste/clipboard
5. KEYBOARD: Use keys on your Keyboard (Copy is CTRL + C; Paste is CTRL + V; Cut is CTRL + X; Print is CTRL +P )