More Excel Tips with Gail Perry


More Excel Tips!
Presented by: Gail Perry, CPA,
Managing Editor of AccountingWEB and author of Excel 2000 Answers!
January 11, 2001

Visit the AccountingWEB Workshop Calendar for upcoming workshop sessions.


Summary

Here are some of the tips discussed in Gail's Excel workshop on January 12, 2001. Look for more of these tips in future stories on AccountingWEB. You can view a complete library of AccountingWEB's Excel tips at:
http://www.accountingweb.com/expertguides/excelzoneit.html

Excel's complimentary buttons

Some toolbar buttons work in reverse if you hold down the Shift key.

For example, The Print button acts as a Print Preview button when Shift is depressed, and Print Preview turns into the Print button with the help of Shift. The alignment buttons are complimentary too. Left turns into Right when you hold down Shift, and Right turns into Left. Center turns into Merge and Center, and vice versa.

The A-Z and Z-A sort buttons are reversible. My personal favorite is the Increase and Decrease Decimal buttons - I'm forever clicking the wrong one and it's just quicker to hold down Shift and click the same button instead of switching over to the other button. The Open File and Save File buttons are interchangeable as well.

But the real advantage to having complimentary buttons is that you can remove the opposing buttons from your toolbar and make room for other buttons, or even condense the toolbar buttons on the formatting and standard toolbar so perhaps you only need one toolbar and can increase your viewable worksheet area.

If you only use the A-Z and Z-A sort buttons occasionally, why not remove one and use the other as a complimentary button with the Shift key? (By the way, you can remove a button by choosing View, Toolbars, Customize, then dragging the unwanted button off the toolbar. If you later decide to go back to the standard, you can click the Toolbars tab of the Customize window, click the name of the toolbar you want to restore, and click the Reset button.)

Improve Scroll Speed

Scroll REALLY quickly through your worksheet when you hold down the Shift key while dragging either the vertical or horizontal scroll box.

Underlining cells

If there are several cells to which you want to apply a format, such as underlining, bold, border, background shading, or number format, select all the cells first. Even if the cells aren't adjacent, you can select many cells by holding down the Ctrl key while you make your selection. Then you only have to apply the formatting once.

Quick-Draw tips

Don't forget the Shift key when using the drawing tools. If you hold down the Shift key while drawing a line, ellipse, or rectangle, you will get a straight line that falls on exact 10 degree angles, a perfect circle, or a perfect square.


Session sponsored by National Payment Corporation


Biography

Gail A. Perry
Managing Editor, AccountingWEB

Gail Perry is a CPA, tax specialist, author, speaker and instructor. Her weekly newspaper column, "Fun With Taxes," which appears in the Indianapolis Star, provides readers with practical tax insights and advice presented in plain English with a touch of humor.

Perry is a former senior tax consultant with the international firm of Deloitte and Touche, where she provided tax planning services and advice to individuals and small businesses. An accomplished free-lance writer, Perry is the author of over a dozen books, including "The Complete Idiot's Guide to Doing Your Income Taxes," "Using QuickBooks," "Excel 2000 Answers!" and "TurboTax for Dummies." In addition, she has written several computer training books and is co-author of a book for trainers, "The Computer Trainer's Personal Training Guide."

Perry is a regular guest on America Online's Money Whiz Q&A program, and she has been featured on Fox television's "Good Morning New York," Bloomberg Business News's "Bloomberg Forum," WOR Radio's syndicated program, "Manage Your Money with the Dolans," as well as dozens of radio shows across the country.


You may like these other stories...

Event Date: August 28, 2014, 2 pm ET Excel spreadsheets are often akin to the American Wild West, where users can input anything they want into any worksheet cell. Excel's Data Validation feature allows you to...
When you’re running an accounting office, it's easy to become inundated with paper, forms, and email attachments, especially when tax season rolls around. To prevent your office from becoming completely overwhelmed...
It's not a reality—yet—but accounting software is poised to eliminate accountants. We are at a tipping point for many similar professions: online education replacing professors, legal software replacing...

Upcoming CPE Webinars

Aug 5
This webcast will focus on accounting and disclosure policies for various types of consolidations and business combinations.
Aug 20
In this session we'll review best practices for how to generate interest in your firm’s services.
Aug 21
Meet budgets and client expectations using project management skills geared toward the unique challenges faced by CPAs. Kristen Rampe will share how knowing the keys to structuring and executing a successful project can make the difference between success and repeated failures.
Aug 28
Excel spreadsheets are often akin to the American Wild West, where users can input anything they want into any worksheet cell. Excel's Data Validation feature allows you to restrict user inputs to selected choices, but there are many nuances to the feature that often trip users up.