g Text Version
Beauty & Self
Books & Music
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
News & Politics
Religion & Spirituality
Travel & Culture
TV & Movies

Bored? Games!
Take a Quiz
Rate My Photo

Natural Living
Folklore and Mythology
Distance Learning

All times in EST

Full Schedule
g Desktop Publishing / Ebooks Site

BellaOnline's Desktop Publishing / Ebooks Editor


5 Unique Techniques for Excel

Guest Author - Chris Curtis

Automatic Word Wrap in a Cell
To wrap text in a cell you must set the wrap text control on the alignment page of the format cells dialog box. You can also set the wrap text control automatically by entering a hard carriage return in the cell while entering or editing data. To enter a hard carriage return, press ALT + Enter at the point where you want the cell to wrap.

Navigating Between Worksheets
Three shortcut methods for moving between worksheets in your workbook
1. Press CTRL + Page Down to activate the adjacent worksheet to the right of the current worksheet
2. Press CTRL + Page Up to activate the adjacent worksheet to the left of the current worksheet
3. Select the exact worksheet to activate from a list of worksheets displayed when you right click on the Worksheet navigation arrows

Quick Charting
Instead of using the chart wizard to create your chart, select the range of data you want to chart and press F11 on your keyboard. Don’t forget to include the column and row labels in your selection to define your categories and series legend. This technique produces a standard bar chart on a separate chart sheet. Once the chart is produced, you can modify the chart as you see fit using the commands found on the chart menu and chart toolbar.

Viewing Formulas in a Cell
Worksheet cells display the results of formula calculations. To see the underlying formula, you click on the cell and the formula is displayed in the formula bar. There are times when you might need to see more than one formula at a time. You can change the worksheet view to display the formulas directly in the cell by pressing the CTRL + ` (accent) keys together. The accent key is located directly above the tab key on the left side of your keyboard. This keystroke combination is a toggle and you can use it to toggle between the formula view and the results view. You can also set the formula view by selecting or deselecting the Formula option on the view page of the Options dialog box.

Pick from List when Entering Data
Entering data in a worksheet is tedious at best. Most people appreciate features that save typing and tedious data entry. One such magical Excel feature is AutoComplete. AutoComplete activates when you begin to type data in a cell and your entry closely matches a pervious entry in the same column. Excel displays a tool tip suggesting the possible entry. Press Enter to accept the suggestion or continue to type if it is not a correct entry.

Even better, you can select from a drop down selection consisting of the unique entries in the column. To display the list, press the ALT + Down Arrow keys together; then click on the correct entry from the displayed list. Excel will insert your choice in the cell. You can also right click on the cell and choose Pick from List to display the list of unique entries in the column.

Be sure to also visit our sister site PC Advice at Bella. You will find a myriad of links and articles about Internet Issues, Personal Computing and Desktop Management.

Please contact your host with any questions. Please also feel free to make any suggestions or contribute a “Unique Technique.” Suggestions should be accompanied by your name and title so that I may give the contributor credit.

Want to improve your MS Office skills, click here to find out how Elusive Creations can help you with your learning needs.

There is a wide selection of Excel reference books at Half Price Computer Books at a reasonable price. You cannot find a more reputable e-retailer. Click below and search for Excel to view their selection of books.

Half Price Computer Books

© Elusive Creations 2002
Add 5+Unique+Techniques+for+Excel to Twitter Add 5+Unique+Techniques+for+Excel to Facebook Add 5+Unique+Techniques+for+Excel to MySpace Add 5+Unique+Techniques+for+Excel to Digg 5+Unique+Techniques+for+Excel Add 5+Unique+Techniques+for+Excel to Yahoo My Web Add 5+Unique+Techniques+for+Excel to Google Bookmarks Add 5+Unique+Techniques+for+Excel to Stumbleupon Add 5+Unique+Techniques+for+Excel to Reddit

PC Advice
Excel Formulas and Functions Class
Excel - Working with Worksheet Tabs
Editor's Picks Articles
Top Ten Articles
Previous Features
Site Map

For FREE email updates, subscribe to the Desktop Publishing / Ebooks Newsletter

Past Issues

Printer Friendly
tell friend
Tell a Friend
Email Editor

Content copyright © 2018 by Chris Curtis. All rights reserved.
This content was written by Chris Curtis. If you wish to use this content in any manner, you need written permission. Contact Laura Nunn for details.


g features
Becoming a Fiction Editor

Making a Background Transparent Using Photoshop

Merging Letters in Word 2007

Archives | Site Map


Past Issues

Note: BellaOnline uses cookies to help provide a consistent user experience. Our advertisers may use cookies to help customize ads. Please contact us with any question about our cookie use.

Summertime Foods
Corn on the Cob
Burgers on the Grill
Apple Pie


| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2018 Minerva WebWorks LLC. All rights reserved.

BellaOnline Editor