Home Page Google Tips Quickbooks Tips Other Tips Peachtree Accounting DDE Tips Peachtree Accounting Tips Microsoft Excel Tips Our Store Site Map Training Recent Projects Our Services Home Page
Accounting Advisors Logo Navigation Bar
 
Quick Links
- Learn How We Can Help
- Read About Recent Projects
- Schedule a Class
- Pay Your Invoice Online
- Request Technical Support

Free Newsletter
You'll receive Peachtree tips, Excel tips, and more!

Newsletter Archives
Privacy Policy
Did you know?
We offer technical support for Peachtree Accounting, Microsoft Excel, and DDE by e-mail, telephone, or remotely.
Double Line Bar   Recommended Books Links VBA Tips Formula Tips Downloads General Tips
Microsoft Excel
General Microsoft Excel Tips (Page 8 of 8)
There are 79 General Microsoft Excel tips available.
View All Microsoft Excel Tips
Small Logo Free Excel Templates
The Microsoft web site contains numerous free Excel templates, including amortization tables for loans and mortagages, college costs calculators, personal budget, and more!
Small Logo Calculation Secrets
Decision Models can help you create more effective spreadsheets by understanding Excel's calculation secrets.
Small Logo Close Multiple Excel Files at Once
To close multiple Excel files at once, hold down the Shift key while you click on File,and then Close All. (Our thanks go to Somasundaram Kannan, who got paid for submitting this tip...learn how!)
Small Logo Freeze Panes
You can lock certain rows or columns in place as you scroll through a worksheet. Position your cursor below any rows and/or to the right of any columns that you wish to freeze in place, then choose Window and Freeze Panes. Unlock the rows/columns by choosing Window, and then Unfreeze Panes.
Small Logo You Can't have a History

Did you know that it's not possible to assign the name History to an Excel worksheet? This is a reserved sheet name that Excel uses in conjunction with the rarely used Track Changes feature that appears on the Tools menu. To work around this limitation, add a period or a space after the word History.

Small Logo Remove All Page Breaks from a Worksheet
Press Ctrl-A to select all cells, and then choose Insert, and Reset All Page Breaks.
Small Logo Excel or Access?
The Microsoft web site offers a helpful article that offers guidance on whether Excel or Access would be best for managing your data.
Small Logo Recovering Damaged Files in Excel 2002
The Microsoft web site includes an article that discusses techniques for recovering damaged spreadsheets. Also, Greg Lovern reports that as a last resort, you may be able to recover a damaged Excel workbook created in Windows by opening the file in the Mac version of Excel.
Small Logo Searching and Replacing Wildcard Characters
In rare instances, you might need to search and replace the * or ? characters with something else. To keep Excel from seeing these as wildcard character, Ture Magnusson reports that you can just precede them with a tilde (~). Thus, if you're replacing question marks with a different character, use ~?.

Page: 1   2   3   4   5   6   7   8  

Accounting Advisors, Inc.
614 Park Avenue SE
Atlanta, Georgia 30312
Telephone: 404-784-0275
Toll Free: 800-724-0315
Fax: 404-420-2175
Privacy Policy


[Home Page] [Our Services] [Recent Projects] [Training] [Support]
Tips: [Excel] [Peachtree] [Quickbooks] [Google] [DDE] [Other]
[Pay Your Invoice] [Driving Directions] [Site Index]

Valid HTML 4.01!
Valid CSS!
About Our Site

Left Footer
Questions? Comments?
E-mail us
or call (404) 784-0275
Our toll free number is (800) 724-0315
© Copyright 2004 by Accounting Advisors
Web site designed and maintained by Accounting Advisors, Inc.
Right Footer