 Specify what your PivotTable displays in place of empty cells and errors (2000/2002/2003/2007) PivotTables can look incomplete and unprofessional if there are empty cells or error messages. Instead of manually replacing the error values you don’t want to see or placing zeros into blank cells, you can set a quick preference that does the [...] Move an entire row or column in Excel without displacing your data (2000/2002/2003/2007) When you’re shuffling around rows or columns of data, you probably do a lot of copying and pasting. This method is fine in many cases, but here’s a quicker alternative. You can move an entire row or column of data to [...] You’ll occasionally find that seemingly simple entries cause problems because Excel tries to interpret numeric values as a date. For instance, say that you have a column of product codes with values like 9-12, 10-22, and 8-2099, or you have data labels that describe the age ranges 1-3, 4-6, 7-9, and 10-12. Excel automatically converts [...] (Excel 2000/2001/2002/2003/2007) When you’re working fast, you’re bound to make mistakes. You’ll often catch your errors right away, but it’s easy to make accidental changes to a workbook’s existing data and not notice until it’s too late. If you’ve ever felt the nausea that accompanies the realization that you’ve just saved workbook changes that unintentionally [...] When you work with a large Excel worksheet, it’s often difficult to remember exactly what kind of data columns or rows contain once you begin scrolling around the sheet and lose sight of the column and row labels. Fortunately, you can freeze rows and columns that contain headings so you always know what data you’re [...] When you insert a worksheet using the Insert | Worksheet menu command, Excel automatically bases the new sheet on the default template. However, you may not want to insert just a blank worksheet. For instance, say your company uses a special Project Tracking template. A workbook is dedicated to each client and there could be [...] Many Excel users are familiar with the shortcut key that allows you to undo an action. By pressing [Ctrl]Z ([command]Z in v. X) it’s easy to eliminate the last action you made. However, what if you realize that you should have kept the action, or the undo was accidental in the first place? Fortunately, you [...] Never type a decimal point again (Excel 2000/2002/2003) If you consistently use the same number of decimal places in your Excel values but typing the decimal point slows down your data entry, there’s an easier way. You can permanently set all of the numbers you enter in your Excel workbooks to include the same number [...] Far too many times, I have been making a bulleted list in Word or PowerPoint and want to hit enter just to wrap a line, but I don’t want a bullet to show and I can’t do it…until now. All you have to do to start a new line without a bullet is hold down [...] |
|
|
Copyright © 2012 Get Schooled at New Horizons - All Rights Reserved |
|
Work around a common error — and keep your comments!
Work around a common error — and keep your comments! (Excel 2000/2002/2003/2007)
If you’ve ever received an error that claims Cannot shift objects off sheet, you should keep reading. The problem occurs when your worksheet contains several objects, such as comments, charts or AutoShapes. When you try to hide or insert columns that might “push” [...]