Excel 2010 part 15

pdf
Số trang Excel 2010 part 15 10 Cỡ tệp Excel 2010 part 15 934 KB Lượt tải Excel 2010 part 15 0 Lượt đọc Excel 2010 part 15 0
Đánh giá Excel 2010 part 15
4 ( 3 lượt)
Nhấn vào bên dưới để tải tài liệu
Để tải xuống xem đầy đủ hãy nhấn vào bên trên
Chủ đề liên quan

Nội dung

Delete a Worksheet If you have a worksheet that you no longer need, you can delete it from the workbook. This reduces the size of the workbook, reduces clutter in the worksheet tabs, and makes the workbook easier to navigate. It is important to note that you cannot undo a worksheet deletion. Therefore, it is always a good practice to check the worksheet contents carefully before proceeding with the deletion. If the worksheet contains any data you need but you still want to remove the worksheet, cut or copy the data and paste it into another worksheet. Delete a Worksheet 1 Click the tab of the worksheet you want to delete. 1 2 Click the Home tab. 3 Click the Delete . 4 Click Delete Sheet. • You can also right-click the tab and then click Delete Sheet. 2 3 4 140 09_577639-ch07.indd 140 3/15/10 2:44 PM 7 CHAPTER Manipulating Excel Worksheets If the worksheet contains data, Excel asks you to confirm that you want to delete the worksheet. 5 5 Click Delete. • Excel removes the worksheet. I have several worksheets I need to delete. Do I have to delete them individually? No. You can select all the sheets you want to remove and then run the deletion. To select multiple worksheets, click the tab of one of the worksheets, hold down , and then click the tabs of the other worksheets. If your workbook has many worksheets and you want to delete most of them, an easy way to select the sheets is to right-click any worksheet tab and then click Select All Sheets. Hold down , and then click the tabs of the worksheets that you do not want to delete. After you have selected your worksheets, follow Steps 3 to 5 to delete all the selected worksheets at once. 141 09_577639-ch07.indd 141 3/15/10 2:44 PM Change the Gridline Color You can add some visual interest to your worksheet by changing the color that Excel uses to display the gridlines. The default color is blank, but Excel offers a palette of 56 colors that you can choose from. Changing the gridline color also has practical value because it enables you to differentiate between the gridlines and the borders that you add to a range or a table. Change the Gridline Color 1 Click the tab of the worksheet 2 you want to customize. 2 Click the File tab. 1 3 Click Options. 3 142 09_577639-ch07.indd 142 3/15/10 2:44 PM 7 CHAPTER Manipulating Excel Worksheets 5 The Excel Options dialog box appears. 4 4 Click Advanced. 5 Scroll down to the Display 6 options for this worksheet section. 7 8 6 Click the Gridline color . 7 Click the color you want to use. 8 Click OK. • Excel displays the gridlines using the color you selected. Can I change the gridline color for all the sheets in my workbook? Yes. One method would be to follow the steps in this section for each worksheet in your workbook. However, an easier method is to first select all the sheets in the workbook. To do this, right-click any worksheet tab and then click Select All Sheets. You can now follow Steps 2 to 8 to apply the new gridline color to all your worksheets. Once you have done that, right-click any worksheet tab and then click Ungroup Sheets to collapse the grouping. 143 09_577639-ch07.indd 143 3/15/10 2:44 PM Toggle Worksheet Gridlines On and Off You can make your worksheet look cleaner and make the worksheet text easier to read by turning off the sheet gridlines. When you do this, Excel displays the worksheet with a plain white background, which often makes the worksheet easier to read. If you find you have trouble selecting ranges with the gridlines turned off, you can easily turn them back on again. Toggle Worksheet Gridlines On and Off 2 Turn Gridlines Off 1 Click the tab of the worksheet you want to work with. 3 2 Click the View tab. 3 Click Gridlines ( changes to ). 1 • Excel turns off the gridline display. Turn Gridlines On • To turn the gridlines back on, click Gridlines ( changes to ). 144 09_577639-ch07.indd 144 3/15/10 2:44 PM 7 CHAPTER Toggle Worksheet Headings On and Off You can give yourself a bit more room to work by turning off the worksheet’s row headings — the numbers 1, 2, and so on to the left of the worksheet — and column headings — the letters A, B, and so on above the worksheet. If you find you have trouble reading your worksheet or building formulas with the headings turned off, you can easily turn them back on again. Toggle Worksheet Headings On and Off 2 3 Turn Headings Off 1 Click the tab of the worksheet you want to work with. 2 Click the View tab. 3 Click Headings ( changes to ). 1 • • Excel turns off the headings. Turn Headings On To turn the headings back on, click Headings ( changes to ). 145 09_577639-ch07.indd 145 3/15/10 2:44 PM Chapter 8 Dealing with Excel Workbooks Everything you do in Excel takes place within a workbook, which is the standard Excel file. This chapter shows you how to get more out of workbooks by creating new workbooks, either blank or from a template; saving and opening workbooks; arranging workbooks within the Excel window; and finding and replacing text within a workbook. 10_577639-ch08.indd 146 3/15/10 2:45 PM Create a New Blank Workbook . . . . . . . . . . . . . . . . . . . 148 Create a New Workbook from a Template . . . . . . . . . . . 150 Save a Workbook . . . . . . . . . . . . . . . . . . . . . . . . . . . . 152 Open a Workbook . . . . . . . . . . . . . . . . . . . . . . . . . . . 153 Arrange Workbook Windows . . . . . . . . . . . . . . . . . . . . 154 Find Text in a Workbook . . . . . . . . . . . . . . . . . . . . . . . 156 Replace Text in a Workbook . . . . . . . . . . . . . . . . . . . . . 158 10_577639-ch08.indd 147 3/15/10 2:45 PM Create a New Blank Workbook To perform new work in Excel, you need to first create a new, blank Excel workbook. Excel automatically creates a blank workbook each time you start the program, but for subsequent files you must create a new workbook yourself. If you prefer to create a workbook based on one of Excel’s templates, see “Create a New Workbook from a Template.” Create a New Blank Workbook 1 Click the File tab. 1 2 Click New. 2 148 10_577639-ch08.indd 148 3/15/10 2:45 PM 8 CHAPTER Dealing with Excel Workbooks 3 Click Blank Workbook. 4 Click Create. 3 4 • Is there a faster method I can use to create a new workbook? Yes. Excel offers a keyboard shortcut for faster workbook creation. From the keyboard, press + . Excel creates the blank workbook and displays it in the Excel window. When I start Excel and then open an existing workbook, Excel often removes the new, blank workbook that it opened automatically. How can I prevent this? Excel assumes that you want to use a fresh workbook when you start the program, so it opens a blank workbook for you automatically. However, if you do not make any changes to the blank workbook and then open an existing file, Excel assumes you do not want to use the new workbook, so it closes it. To prevent this from happening, make a change to the blank workbook before opening any existing file. 149 10_577639-ch08.indd 149 3/15/10 2:45 PM
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.