Q&A
| Q1: | When I selected two decimal places, why did the numbers display with # signs? |
| A1: | If any cell displays number signs (#), you can widen the column to display the numbers. Double-click the column border to the right of the column letter for the column you want to adjust. |
| Q2: | Does Excel have a fast way to display the Format Cells dialog box? |
| A2: | Absolutely. Press Ctrl+1. |
| Q3: | I like using a shortcut menu for making changes to my worksheet. Can I format numbers with a shortcut menu? |
| A3: | Yes. You're in luck! Select the cells you want to format and then click the right mouse button in one of the selected cells. Your shortcut menu should appear. Then choose Format Cells. |
| Q4: | Does Excel have a shortcut for applying the same number format in various places ... |
Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
