[ Pobierz całość w formacie PDF ]
.Figure 8-23 shows the Border tab in the Format Cellsdialog box, as it appears when more than one cell is selected.If you have more than one cellselected when you open the dialog box, the Border preview area includes tick marks in themiddle and at the corners, as shown in Figure 8-23.Note A solid gray line in the preview area means that the format applies to some, but notall, of the selected cells.f08ie23Figure 8-23.Using the Border tab, you can assign 13 styles of borders in 56 colors.To apply borders, you can either click in the preview area where you want the border toappear or you can click the buttons located around the preview area.An additional presetbutton, Inside, becomes active only when you have more than one cell selected.If you clickthe Outline button, borders are applied to only the outside edge of the entire selection.TheNone preset removes all border formats from the selection.Tip Remove gridlinesBorders often make a greater visual impact on your screen when worksheet gridlines areremoved.Choose Tools, Options, and click the View tab.Clear the Gridlines option toremove gridlines from your worksheet.For more information on gridlines, see Displayedvs.Printed Gridlines on page 84.The default, or Automatic, color for borders is black.To select a line style, click the type ofline you want to use in the Line area, and then click any of the buttons in the Border area toapply that style in the selected location.(The first finely dotted line in the Style area is a solidhairline when printed.) To change a border style, reselect the cell or range and then redisplaythe Format Cells dialog box.To remove a border, click the corresponding button, or the line228Chapter 8 Part 3: Formatting and Editing WorksheetsWorksheet Formatting Techniquesin the preview window, without selecting another style.Figure 8-24 shows some of the bor-der styles that Excel is capable of creating.f08ie24Figure 8-24.This worksheet makes (questionable) use of multiple border styles.Note You can find the sample file used in this example, borders.xls, on thecompanion CD.Applying Border Formats with Toolbar ButtonsYou can apply many combinations of border formats using the Borders button on the Formattingtoolbar.When you click the small arrow on the Borders button, Excel displays a tear-off palettefrom which you can select a border style.(Refer to Figure 8-22 for an example of a tear-off palette.)The options on the Borders palette show, in miniature, the border combinations available.Thelast border option that you selected appears on the face of the Borders button, which you can clickto repeat the last format used, without requiring you to display the palette.To remove all borderformats from a selected cell or range, click the first option in the Borders palette.With the palette open, you can click the arrow and then click the gray bar at the top of the paletteand drag; the Borders palette tears off the toolbar and floats independently of the toolbar, asshown in Figure 8-25.Click the Close button in the upper right corner to dismiss the palette.f08ie25229Figure 8-25.Click the arrow next to the Borders button, and then drag to tear off the palette.Chapter 8 Part 3: Formatting and Editing WorksheetsMicrosoft Office Excel 2003 Inside OutAn Angled Border TrickSometimes you might want to use that pesky cell that generally remains empty in the upperleft corner of a table.You can use an angled border to create dual-label corner cells like theone shown in the following example.g08ie04Here s how to do it:1 Select the cell you want to format and type about 10 space characters.You canadjust this later (there are 20 spaces before the Exam # label in the example).2 Type the label you want to correspond to the column labels across the top of the table.3 Hold down the Alt key and press Enter twice to create two line breaks in the cell.4 Type the second label, which corresponds to the row labels down the left side of thetable, and press Enter.5 With the cell selected, choose Format, Cells, and click the Border tab.6 Select a line style and click the upper left to lower right angled border button.7 Click the Alignment tab, click the Wrap Text option, and then click OK.You will probably need to fine-tune a bit by adjusting the column width and row height andby adding or removing space characters before the first label.In the example, we alsoselected cells B3:F3, and then selected the Top vertical alignment option on the Alignmenttab so that all the labels line up across the top of the table.For more information about alignment, see Aligning Data in Cells on page 219.For more aboutentering line breaks and tabs in cells, see Formula-Bar Formatting on page 364.Note You can find the sample file used in this example, Angled Borders.xls, on thecompanion CD.230Chapter 8 Part 3: Formatting and Editing WorksheetsWorksheet Formatting TechniquesDrawing BordersThe Borders palette on the Formatting toolbar includes the Draw Borders command.Whenyou click this command, the cursor changes to a pencil, and you drag directly on the work-sheet where you want your borders to go.The default or last-used border style is applied.Figure 8-26 shows the process of adding borders to the sheet shown in Figure 8-22.We toreoff the Borders palette for easy access during the task.Notice also that because this particularsheet is displayed without gridlines, the Draw Borders feature adds dots in each cell corner tomake the grid more visible.When gridlines are visible, these dots are not necessary.Note When you click the Draw Borders command, the Borders toolbar might appeardocked at the bottom or the top of the screen.To make the toolbar more apparent and eas-ier to use, we dragged it away for easier viewing.f08ie26Figure 8-26.Use the Draw Borders command on the Borders palette to create bordersdirectly on the worksheet by dragging.Before you drag to draw a border, you can use the Borders toolbar to choose line style andcolor.You can click the Erase Border button on the Borders toolbar and drag over any por-tion of a border to erase it.To exit Border Drawing mode, you can click the Draw Borderscommand on the Borders palette or click the pencil button on the Borders toolbar.Applying Colors and PatternsThe Patterns tab of the Format Cells dialog box offers colors and shading you can apply toselected cells, as shown in Figure 8-27.The main feature of the Patterns tab is a palette dis-playing the current standard palette, as specified on the Color tab of the Options dialog box.Another feature of the Patterns tab is the Pattern drop-down list, as shown in Figure 8-28.231Chapter 8 Part 3: Formatting and Editing WorksheetsMicrosoft Office Excel 2003 Inside OutYou use this drop-down list to not only select different patterns for the cell, but also differentcolors that are applied to those patterns.(The colors at the top of the Patterns tab are for thecell background, whereas those in the Pattern drop-down list are for any pattern you apply.)f08ie27Figure 8-27.Using the Patterns tab, you can select colors and patterns for cell backgrounds
[ Pobierz całość w formacie PDF ]