 Balance row and column sizes in 3 clicks Working with tables can mean a lot of tweaking and fine-tuning while you adjust the look and fit of your rows and columns. To balance your table’s appearance, click on the table and then select the rows or columns you want to adjust. Select the Layout tab from [...] GUEST BLOGGER: Steve Chase, Applications Instructor. MOS, MCT
Sparklines are a cool, new charting feature in Excel 2010. Basically they are charts contained within a single cell range. There are three types of sparklines (line, column, and win/loss). Make sure that you have a contiguous series of numerical data before you [...] If you often have to use your mouse or keyboard to scroll though long documents looking for one particular section, then you know how tedious it can be to continuously move your document’s scroll bar up and down, or to page up and down using the keyboard’s arrow keys. However, if you have a mouse [...] I can understand this frustration. Excel remembers which cell was active when you were last working in a worksheet, and so when you return, the same cell is active. However, the cell isn’t ready for immediate editing. You need to either type all new data in the cell, or double-click on it to activate the [...] Although Excel’s 3-D charts do a pretty good job of simulating 3-D objects on a 2-D screen, it can sometimes be difficult to visually line up a data point with its corresponding position on the chart’s category axis. This is especially true when working with area or line charts. The task can be even more [...] Show percentages with a little color (Excel 2007) Percentages interpret your data as smaller parts of a larger piece. This is why pie charts are often a popular way to demonstrate percentages. However, if you want to conserve space and still present an attractive, effective visual of your percentage data, Excel 2007 offers [...] Display a cheat sheet for your function right in the formula bar (Excel 2000/2002/2003/2004/2007) You’ve probably seen the ToolTip that appears when you begin to type a formula. Once you enter the opening parenthesis, the arguments for that function appear below the Formula bar or active cell. But, many power users find these ToolTips more [...] Move an entire row or column without displacing your data (Excel 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 a new position [...] 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 job [...] |
|
|
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” [...]