NOAA Workforce Management Office - Helpful Hints

NOAA Collage Top Banner

Quick Navigation

• WFMO Contacts

• About WFMO

• A - Z Index

• NOAA Locator

• Emerg Dismissal

• Emerg Relief Info

• Careers (NOAA)

• NOAA Vacancies

• Mgrs Hiring Guide

• Supvy Res. Guide

• Forms

• eLearning@NOAA

• eOPF at NOAA

• NFC Personal Page

• WorkLife Center

• WebTA

• New Employee Info

• Separation Info

Workforce Management Office (WFMO)
Serving NOAA's Most Valuable Asset - People

Here are some "Helpful Hints" we have found useful.

Have one you'd like to share? Please send a Word or PDF file and a link to the source to the HR Webmaster: hrwebmaster@noaa.gov

Word

Miscellaneous

**Microsoft Excel**
Separating info in one column to two	If you need to split a list of names into two columns, you don’t have to do it manually.
Convert Excel calculations to literal values	Copying Excel data to a different location can send your calculations into a tailspin. Avoid problems by using Paste Special to copy values rather than formulas.
Import/convert web text to columns	Bring web table data into a worksheet in a format you can use.
Drop-down boxes	How to create drop-down boxes in Excel
Move data within a workbook	Quickly move data to another workbook without copy and paste.
Displaying key data	Let Excel’s Indirect function keep data at your fingertips.
Animating your presentation	You can make your presentations far more engaging with a little animation sleight of hand.
Excel’s Conditional Formatting	Let Excel alert you when an entry needs attention.
Excel’s range	Use an Excel range to save time and prevent errors.
Word to Excel	Import Word table info to your Excel worksheet.
Transpose columns/rows	Transpose Excel data from rows to columns, or vice versa.
Hiding worksheets	Users can unhide worksheets, but here's a way to securely hide them.
3 Easy Tricks	Excel has efficiency-boosting keyboard tricks, here are three of them.

**Microsoft Outlook**
Using Outlook to send e-mail to a cell phone	Send phone numbers, contacts, reminders to a cell phone.

**Microsoft PowerPoint**
7 keyboard shortcuts	Learn just a few shortcuts and you can focus on your audience and your message instead.

**Microsoft Word**
Easy parallel columns	Parallel columns are read left to right, whereas Columns are read top to bottom.
Spell check for links	Eliminate the Spell Checker from stopping at every Link within your Word file.
Table AutoFormat	Word’s Table AutoFormat feature offers an assortment of prefab styles you can use to jazz up your tables.
How to Repair a Word document	Get a message your file is corrupt? Here's how to repair the file.
Word shortcuts	Shortcuts to help with formatting text.
10 Annoying Word features	Here are some common stunts that Word tries to pull on unwary users, along with a cure for each one.
Word's automatic formatting	How to remove that annoying border generated by Word.
Selecting top to bottom	Every once in a while, you may need to select a portion of text from top to bottom instead of from left to right.
Line numbering	Easy steps to add line numbers to your Word document.

**Miscellaneous**
Out of office email notification	Steps to set up your away message in Thunderbird.
Setting up your eMail Signature	Steps to set up your eMail signature block in Thunderbird.

Page last edited: November 04, 2009


US Dept of Commerce National Oceanic and Atmospheric Administration 1305 East West Highway Silver Spring, MD 20910 Page Author: NOAA WFMO IT Services	About WFMO WFMO Directory NOAA Directory NOAA Search NOAA World	Disclaimer Freedom of Information Act (FOIA) Information Quality Privacy Policy USA.gov