[ Pobierz całość w formacie PDF ]
.TipTo edit the worksheet name rather than replace it completely, it s usually easiest todouble-click the sheet tab and then click within the name where you want tomake a change.Sheet names can be up to 31 characters, and spaces are allowed.However, youcan t use the following characters in sheet names:: colon/ slash\ backslash? question mark* asteriskKeep in mind that a longer worksheet name results in a wider tab, which takes upmore space on-screen.Therefore, if you use lengthy sheet names, you won t be ableto see very many sheet tabs without having to scroll the tab list.Changing a sheet tab s colorExcel allows you to change the color of one or more of your worksheet tabs.Forexample, you may prefer to color-code the sheet tabs to make it easier to identifythe worksheet s contents.To change the color of a sheet tab, right-click the tab and choose Tab Color.Thenselect the color in the Format Tab Color dialog box.Rearranging your worksheetsYou may want to rearrange the order of worksheets in a workbook.If you have aseparate worksheet for each sales region, for example, arranging the worksheets inalphabetical order or by total sales might be helpful.You may want to move a work-sheet from one workbook to another.(To move a worksheet to a different work-book, both workbooks must be open.) You can also create copies of worksheets. 05 539671 ch03.qxd 8/28/03 9:59 AM Page 50Part I &' Getting Started with Excel50You can move or copy a worksheet in the following ways:&' Select the Edit ª' Move or Copy Sheet command to display the Move or Copydialog box.&' Right-click the sheet tab and select the Move or Copy command.(This alsodisplays the same Move or Copy dialog box.)&' To move a worksheet, click the worksheet tab and drag it to its desired loca-tion (either in the same workbook or in a different workbook) to move theworksheet.When you drag, the mouse pointer changes to a small sheet, anda small arrow guides you.&' To copy a worksheet, click the worksheet tab, press Ctrl, and drag the tab toits desired location (either in the same workbook or in a different workbook).When you drag, the mouse pointer changes to a small sheet with a plus signon it.TipYou can move or copy multiple sheets simultaneously.First select the sheets byclicking their sheet tabs while holding down the Ctrl key.Then you can move orcopy the set of sheets by using the methods just described.Dragging is usually the easiest method, but if the workbook has many sheets, youmay prefer to use the Move or Copy dialog box.This dialog box is shown in Figure3-4, and it enables you to select the workbook and the new location.Figure 3-4: Use the Move or Copy dialog box to moveor copy worksheets in the same or another workbook.If you move or copy a worksheet to a workbook that already has a sheet with thesame name, Excel changes the name to make it unique.For example, Sheet1becomes Sheet1(2).NoteWhen you move or copy a worksheet to a different workbook, any defined namesand custom formats also get copied to the new workbook. 05 539671 ch03.qxd 8/28/03 9:59 AM Page 51Chapter 3 &' Essential Worksheet Operations51Hiding and unhiding a worksheetIn some situations, you may want to hide one or more worksheets.Hiding a sheetmay be useful if you don t want others to see it, or if you just want to get it out ofthe way.When a sheet is hidden, its sheet tab is also hidden.At least one sheetmust remain visible.(You can t hide all the sheets in a workbook.)To hide a worksheet, choose Format ª' Sheet ª' Hide.The active worksheet (orselected worksheets) will be hidden from view.Making a Sheet Very HiddenIt s also possible to make a sheet very hidden. A sheet that is very hidden does not appearin the Unhide dialog box.To make a sheet very hidden:1.Activate the worksheet.2.Select View ª' Toolbars ª' Control Toolbox.This displays the Control Toolbox toolbar.3.Click the Properties button on the Control Toolbox toolbar.This displays theProperties box, shown in the following figure.4.In the Properties box, select the Visible option, and choose 2 - xlSheetVeryHidden.After performing these steps, the worksheet will be hidden, and it will not appear in theUnhide dialog box.Be careful.After you make a sheet very hidden, you can t use the Properties box to unhideit because you won t be able to select the sheet! In fact, the only way to unhide such asheet is to use a VBA macro.(See Part VI for more information about VBA.) This VBA state-ment will unhide Sheet1 in the active workbook:ActiveWorkbook.Worksheets( Sheet1 ).Visible = True 05 539671 ch03.qxd 8/28/03 9:59 AM Page 52Part I &' Getting Started with Excel52To unhide a hidden worksheet, choose Format ª' Sheet ª' Unhide.Excel opens itsUnhide dialog box that lists all hidden sheets.Choose the sheet that you want toredisplay and click OK.You can t select multiple sheets from this dialog box, soyou need to repeat the command for each sheet that you want to redisplay.TipTo more fully protect a workbook from unauthorized changes, use the Tools ª'Protection menu commands.These commands give you several options in decid-ing how much access other users will have to the worksheets in your workbooks.Be aware that this is a very weak security measure.It is relatively easy to crackExcel s protection features [ Pobierz caÅ‚ość w formacie PDF ]
zanotowane.pl doc.pisz.pl pdf.pisz.pl odbijak.htw.pl
.TipTo edit the worksheet name rather than replace it completely, it s usually easiest todouble-click the sheet tab and then click within the name where you want tomake a change.Sheet names can be up to 31 characters, and spaces are allowed.However, youcan t use the following characters in sheet names:: colon/ slash\ backslash? question mark* asteriskKeep in mind that a longer worksheet name results in a wider tab, which takes upmore space on-screen.Therefore, if you use lengthy sheet names, you won t be ableto see very many sheet tabs without having to scroll the tab list.Changing a sheet tab s colorExcel allows you to change the color of one or more of your worksheet tabs.Forexample, you may prefer to color-code the sheet tabs to make it easier to identifythe worksheet s contents.To change the color of a sheet tab, right-click the tab and choose Tab Color.Thenselect the color in the Format Tab Color dialog box.Rearranging your worksheetsYou may want to rearrange the order of worksheets in a workbook.If you have aseparate worksheet for each sales region, for example, arranging the worksheets inalphabetical order or by total sales might be helpful.You may want to move a work-sheet from one workbook to another.(To move a worksheet to a different work-book, both workbooks must be open.) You can also create copies of worksheets. 05 539671 ch03.qxd 8/28/03 9:59 AM Page 50Part I &' Getting Started with Excel50You can move or copy a worksheet in the following ways:&' Select the Edit ª' Move or Copy Sheet command to display the Move or Copydialog box.&' Right-click the sheet tab and select the Move or Copy command.(This alsodisplays the same Move or Copy dialog box.)&' To move a worksheet, click the worksheet tab and drag it to its desired loca-tion (either in the same workbook or in a different workbook) to move theworksheet.When you drag, the mouse pointer changes to a small sheet, anda small arrow guides you.&' To copy a worksheet, click the worksheet tab, press Ctrl, and drag the tab toits desired location (either in the same workbook or in a different workbook).When you drag, the mouse pointer changes to a small sheet with a plus signon it.TipYou can move or copy multiple sheets simultaneously.First select the sheets byclicking their sheet tabs while holding down the Ctrl key.Then you can move orcopy the set of sheets by using the methods just described.Dragging is usually the easiest method, but if the workbook has many sheets, youmay prefer to use the Move or Copy dialog box.This dialog box is shown in Figure3-4, and it enables you to select the workbook and the new location.Figure 3-4: Use the Move or Copy dialog box to moveor copy worksheets in the same or another workbook.If you move or copy a worksheet to a workbook that already has a sheet with thesame name, Excel changes the name to make it unique.For example, Sheet1becomes Sheet1(2).NoteWhen you move or copy a worksheet to a different workbook, any defined namesand custom formats also get copied to the new workbook. 05 539671 ch03.qxd 8/28/03 9:59 AM Page 51Chapter 3 &' Essential Worksheet Operations51Hiding and unhiding a worksheetIn some situations, you may want to hide one or more worksheets.Hiding a sheetmay be useful if you don t want others to see it, or if you just want to get it out ofthe way.When a sheet is hidden, its sheet tab is also hidden.At least one sheetmust remain visible.(You can t hide all the sheets in a workbook.)To hide a worksheet, choose Format ª' Sheet ª' Hide.The active worksheet (orselected worksheets) will be hidden from view.Making a Sheet Very HiddenIt s also possible to make a sheet very hidden. A sheet that is very hidden does not appearin the Unhide dialog box.To make a sheet very hidden:1.Activate the worksheet.2.Select View ª' Toolbars ª' Control Toolbox.This displays the Control Toolbox toolbar.3.Click the Properties button on the Control Toolbox toolbar.This displays theProperties box, shown in the following figure.4.In the Properties box, select the Visible option, and choose 2 - xlSheetVeryHidden.After performing these steps, the worksheet will be hidden, and it will not appear in theUnhide dialog box.Be careful.After you make a sheet very hidden, you can t use the Properties box to unhideit because you won t be able to select the sheet! In fact, the only way to unhide such asheet is to use a VBA macro.(See Part VI for more information about VBA.) This VBA state-ment will unhide Sheet1 in the active workbook:ActiveWorkbook.Worksheets( Sheet1 ).Visible = True 05 539671 ch03.qxd 8/28/03 9:59 AM Page 52Part I &' Getting Started with Excel52To unhide a hidden worksheet, choose Format ª' Sheet ª' Unhide.Excel opens itsUnhide dialog box that lists all hidden sheets.Choose the sheet that you want toredisplay and click OK.You can t select multiple sheets from this dialog box, soyou need to repeat the command for each sheet that you want to redisplay.TipTo more fully protect a workbook from unauthorized changes, use the Tools ª'Protection menu commands.These commands give you several options in decid-ing how much access other users will have to the worksheets in your workbooks.Be aware that this is a very weak security measure.It is relatively easy to crackExcel s protection features [ Pobierz caÅ‚ość w formacie PDF ]