Our Sister Publication

Do you know about the sister publication to ExcelTips, called WordTips? The WordTips newsletter includes great tips and techniques for using Microsoft Word. Regardless of how comfortable you are with Word, you can always pick up some new ideas to enhance how you use the program.

Subscriptions to WordTips are free, just like ExcelTips. You can find full information at the right side of any page on this site:

http://wordribbon.tips.net

Check it out!

—Allen
     

ExcelTips (menu) for 25 March 2017

Formulas
Relative References to Cells in Other Workbooks

When you construct a formula and click on a cell in a different workbook, an absolute reference to that cell is placed in the formula. There is no way to tell Excel you want the references to be relative, but there are some things you can try to change the references.

Read this tip »

 
Powerful spreadsheets
Forcing Stubborn Recalculation

Have you ever recalculated a worksheet, only to notice that not everything calculated as it should? Here's a way you can force a complete recalc, along with some ideas on why you might not be seeing the results that you expect.

Read this tip »

 
PivotTables Make You Feel Faint?

Do you get weak in the knees when asked to deal with huge amounts of data? Forget feeling faint ever again when you are asked to deal with PivotTables. Learn much more than the basics with PivotTables for the Faint of Heart, now available in three great versions.

 
Printing
Selecting a Paper Size

Excel can print your worksheet on just about any paper size you can imagine. How you select the paper size you want used depends on your printer's capabilities and what Windows allows you to do.

Read this tip »

 
Powerful spreadsheets
Changing the Percent Symbol

Some symbols can be easily changed in Excel or in Windows, such as the symbols used for currency and to separate thousands in numbers. Other symbols are more difficult to change. It is this latter group into which the percent symbol falls, as illustrated in this tip.

Read this tip »

(Thanks to Barry Dysert, Brian Miller, Ian Daniel, Doug Horton, David Laminack, and Dave Pettit for contributing to this tip.)

ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 1187  •  Mountain View, WY  82939  •  307-200-0450