Wiley 978-0-471-77318-4 Datasheet

Chapter Spreadsheet BasicsIn This Chapter◆ Learning things about spreadsheets you don’t typically find in manuals andclasses◆ Fixing up odd behavior i

Figure 1-12: Adjusting your Security Level setting to MediumHere is what this accomplishes. Anytime you open a spreadsheet that contains macro code,Ex

While we’re at it, let’s get the terminology straight. When a spreadsheet file in Excel isbeing opened or referred to, it is called a workbook. Within

Part I: Escape in Under 30 Seconds14continuedExcel templates are well suited for finely tuned spreadsheets that you will userepeatedly. A good example

Chapter 1: Spreadsheet BasicsPart I15Thankfully, you don’t have to search for the directory in which to save the templates.Excel takes care of that fo

Toolbars and Toolbar Icons“My toolbar is missing some icons that it used to have! What happened?”Just underneath your Excel menu is a series of icons

A third solution is available. It entails customizing your toolbars to contain only the iconsyou need. This is likely to be your best approach, but it

Figure 1-17: Give your custom toolbar a name.The name can be any descriptive name of your choosing. For now, you can call it Group1. Iuse the Group1 t

sign (+) in it. While you have your mouse button held down, drag the icon onto your emptyGroup1 toolbar. When you drag the icon onto the Group1 toolba

Sometimes you will want specific toolbar icons even though you can access the featurethrough one of the space-saving icons. The Paste Values and Paste

Chapter 1: Spreadsheet BasicsPart I21Figure 1-21: After you click the Freeze Pane icon, the confusing split-pane is gone and thespreadsheet scrolls na

Figure 1-1: Spreadsheet cells with individually formatted wordsHere is how you do it. Select the spreadsheet cell containing the text you want to form

two rows. They can be shoved onto the second row, but there is not quite enough space tosimultaneously display all of them on a straight horizontal li

Figure 1-3: Format the selected word as you would regularly format a spreadsheet cell.My Spreadsheets Have Gone Haywire — Help!!Every now and then, it

Figure 1-4: Disable (uncheck) the “Fixed decimal” setting.Figure 1-5: Uncheck the “R1C1 reference style” to get back the A1 style.NOTEThere is a sprea

Chapter 1: Spreadsheet BasicsPart I7There are two ways to represent rows and columns in Excel spreadsheets. One ofthese is to label them with row and

Figure 1-6: This spreadsheet is reversed (column labels all go in the wrong order and rows appearon the right instead of the left side).So, how does t

Figure 1-7: You can adjust settings to go from right to left or from left to right.Excel allows you to set options that tell the software how it shoul

Figure 1-9: Options for New WorkbookAfter you have a spreadsheet or workbook open, you should have no problem changing theoptions. Try it.If you are n

Macro Security“Excel won’t let me run any spreadsheets that have macros. What can I do?”Figure 1-11 shows the kind of warning error you will get if yo