Sunday, March 30, 2014

Windows 8.1 Tips

Here are a few tips which will help in using Windows 8.1:
  • If you can't find an application, from the Start Tile screen, just start typing what you want.  The Search bar appears on the right side of the screen with items matching your search request.  Click on the appropriate item.
  • To close a window do ONE of the following:
    • If you have a touch screen, drag your finger from the top of the window to the bottom of the window.  You should see the window get smaller and then disappear.
    • If you don't have a touch screen, place your mouse pointer at the top of the window (it will change to a hand icon).  Drag the mouse from the top to the bottom of the screen and release the mouse. You should see the window get smaller and then disappear.
  • To view your Desktop from the Start Tile screen, press the Windows key + the letter d (on your keyboard).  To return to the tiles screen, press the Windows key (on the Taskbar or keyboard) 
    Windows key
  • To jump between all OPEN programs, hold ALT key and press TAB.  Keep pressing the TAB key while still holding ALT to choose a different program.  When you release the ALT key, the program you selected displays. NOTE: This also works in earlier operating systems.
  • To shut down your computer: 
  1. Press Windows key + c
  2. Click Settings.
  3. Click Power.
  4. Click Shut Down.
OR 
Use this SHORTCUT: Windows key + X, press U, press U.

Saturday, March 1, 2014

Copy Formatting Using the Format Painter

 





The Format Painter,  in Microsoft Office programs will save you lots of time when it comes to copying formats of text, cells, or objects to  other text, cells, or objects. 

 For example, you have text that is already formatted with one or more formatting options, like font size, color or style and you have other text that is not currently formatted, but you'd like to format the text exactly like the other.  


Your document contains this: example text 1 and this: example text 2.  You want example text 2 to look like example text 1.

  1. First select the text of the format you want to keep: example text 1
  2. Double-click on the format painter (on the HOME tab of the ribbon). If you single click on the format painter you will only be able to paint one selection.
  3. The paint brush is now attached to your mouse pointer.  Drag the paintbrush across all the text, cells, or objects that you want to format exactly like the originally selected text.
  4. When you have "painted" all the text, cells, or objects that you want to have the same format, turn off the Format Painter by clicking the Format Painter again.

ADVANCED:  For those of you who use Conditional Formatting in Excel, the Format Painter will also copy existing Conditional Formats onto the cells you paint.