Text Box: Contents • Using One Note for Screen Shots • Real Questions • Excel: Zero Padding Numbers • Word Tips • Outlook: Creating Group Schedules • Excel: Adding Notes to Formulas • Windows XP: Grouping or Ungrouping Taskbar Items

 

Using Microsoft One Note for Screen Shots

Microsoft’s One Note can be use to capture screen shots on your computer.  This method has an advantage over “Alt+PrintScreen” – One Note allows you to capture just a portion of the screen, while “Alt+PrintScreen” captures the entire screen.  In addition, there is no need to remember the “Alt+PrintScreen” keystrokes, as all you need to do is right click the One Note icon in the status bar and select “Create Screen Clipping”. Click here for details

 

Real Questions!

I have an Excel worksheet that contains dollar amounts.  Cells that exceed a certain dollar amount ($3000) need to be highlighted one color, and cells that DO NOT exceed a certain dollar amount ($2000) need to be highlighted with a different color.  How can I do this?

This is very easy to accomplish using Excel’s Conditional Formatting Feature.  Click here for details.

 

How can I sort My Favorites in alphabetical order?

Display your Favorites, then right click on the list and select “Sort by Name”

 

Can I add bullets to items in an Excel worksheet?

While Excel does not have a Bullet feature like Word, you can create bullets in a worksheet using either of these methods:

Method 1:  Your font must be set to Arial. Hold down the ALT key and press 0149 on the numeric keypad.  This results in a small bullet.

Method 2:  Designate a separate column to hold the bullets.  Select Insert, Symbol from the Excel menu, and change the font to Wingdings or Wingdings2.  Select an appropriate bullet symbol and click Insert, then click Close. This method allows some flexibility.  The column can re resized, the bullet can be copied down using Autofill, and the size of the bullet can be changed using the Format, Cells command.

 

How can I type a copyright symbol in a Word document (or Excel worksheet)?

To insert the Copyright symbol, type:  (c)                      ©

Text Box: February Quick Tip To toggle between your on screen application and the computer desktop, hold down the Windows key and press D. NOTE: The Windows Key is the key on the keyboard that has the Windows icon on it – the second key from the left, bottom row of the keyboard. To insert the Trademark symbol, type (tm)                    ™

To insert the Registered symbol, type (r)                       ®

To insert a Section symbol, hold down the ALT key and type 0167 using the numeric keypad      §

Note:  If this does not work, select Tools, Autocorrect Options from the Word/Excel menu and, on the Autocorrect tab, make sure that “Replace Text as you Type” is selected.  (In Excel, if you make a change to the Autocorrect tab, you must close, then re-open Excel for the change to take effect.)

 

Excel:  Zero Padding Numbers

When exporting an Excel worksheet to a text file, it is sometimes necessary that a numerical string contain a fixed amount of characters, requiring that the string be padded with zeroes.  For example:  You might have a dollar amount that needs to contain 8 characters, so that 90000 would need to be converted to 00090000.  Excel has a custom number format that easily accomplishes this. Click here for details.

 

Word Tips

  • Text Box: Windows XP: Taskbar Groups Application Icons By default, Windows XP groups related items on the taskbar. For example – if you have minimized 3 Outlook items, only one Outlook icon displays on the taskbar and you click that icon, then select the item you want to work with. If you would rather your items not be grouped, right click on a blank area of the taskbar and select Properties from the shortcut menu. On the “Taskbar” tab, deselect “Group similar taskbar buttons”, click Apply, then click OK. To quickly access the Bullets and Numbering dialog box, double click on any number in a numbered list, or double click on any bullet in a bulleted list.
  • To quickly move an entire paragraph, click anywhere in the paragraph, then while holding down the ALT+SHIFT key, press either the Up or Down arrow key to move the paragraph. 
  • Right click on a word in your document and select Synonyms from the shortcut menu to display a list of synonyms for the selected word.
  • To quickly remove formatting from text:  To remove paragraph formatting, such as line spacing, indentation, etc., click in the paragraph and press CTRL+Q.  To remove character formatting, such as bold, italic, etc., click in the formatted word and press CTRL+Spacebar.
  • Aligning Numbered Lists on the period:  When you use the Bullets and Numbering feature to automatically number lists, if the list has more than 9 items, your numbers will not align on the period.  To correct this,  select the list, right click and select Bullets and Numbering from the shortcut menu that displays. In the Bullets and Numbering dialog box, select the Numbered tab, then click Customize.  In the Number Position box, select Right, then click OK.  If you want, instead of selecting the list, you can click anywhere in the list and select Format, Bullets and Numbering from the Word menu.

 

Outlook – Creating and Using Group Schedules

One of the most overlooked features in Outlook is the ability to create group schedules., which allows you to easily and quickly arrange meetings with groups of individuals and compare their calendars.    Click here for details.

 

Excel:  Adding Notes to Formulas

Because formulas can be lengthy and complicated, Excel offers you the option of adding a message to a formula so that you can be reminded of what exactly the formula does and why you are using it.  The message is entered after the formula.

 

 

The worksheet below contains a message in a formula

 

 

To add a message to a formula:

 

  1. Click in the cell that contains the formula. 
  2. In the Formula Bar, click after the very last character in the formula and press F2.
  3. Type:  +N(“
  4. Type your message
  5. Type:  “)
  6. Press Enter.

 

NOTES:

v      Messages added to formulas should be brief. Cell notes and text boxes can be placed in a worksheet for lengthy messages.

v      Be sure your cursor is positioned at the end of the formula

v      Be sure to press F2…and press Enter when you are done.

 

 

Questions or comments?  Please email jtfreed@email.uncc.edu