[ Pobierz całość w formacie PDF ]
.You can change the way objects behave in relation to changes in the worksheet using theoptions on the Properties tab of the Format AutoShape dialog box.The default ObjectPositioning option is Move And Size With Cells, meaning that if you do anything tochange the size or shape of the underlying cells, the object adjusts accordingly.An underly-ing cell is any cell whose right or bottom border is between the upper left corner and thelower right corner of the object.Here are some things you need to know about the ObjectPositioning options:�% If you insert columns or rows to the left of an object formatted with the Move And SizeWith Cells option, the object moves accordingly.�% If you insert columns or rows between the first and last cells underlying an object for-matted with the Move And Size With Cells option, the object stretches to accommo-date the insertion.�% If you select the Move But Don t Size With Cells option and then insert or delete col-umns or rows, the object moves but retains its shape and proportion.�% If you select the Don t Move Or Size With Cells option, the object floats above theworksheet and isn t affected by any changes you make to the underlying cells.�% The Print Object option is normally turned on.If you turn it off, the selected objectisn t printed when you print the worksheet.Tip Cut, copy, and sort objects with cellsIn addition to moving and sizing objects with cells, Excel allows you to control what happenswhen you cut, copy, or sort cells to which objects are attached.Choose Tools, Options, clickthe Edit tab, and then select or clear the Cut, Copy, And Sort Objects With Cells option.306Part 4: Adding Graphics and PrintingChapter 10Part 3: Formatting and Editing WorksheetsCreating Spiffy GraphicsTools to Help You Position Objects on the WorksheetIt s great to be able to create cool graphics with Excel, but the free-floating nature of graphicobjects sometimes makes it hard to maintain a semblance of order on your worksheet.TheDraw menu contains several menus and tear-off palettes you can use to straighten things up.Here are some key points to remember about using these object positioning commands:�% To Grid, on the Snap submenu, uses the columns and rows of the worksheet to alignobjects.Pre-existing Objects don t line up with the grid when you choose this com-mand, but as soon as you create or drag an object, it snaps to the nearest column androw borders.�% To Shape, on the Snap submenu, turns on the To Grid command when you choose it,activating its functionality.It adds to the spreadsheet grid virtual gridlines tangent tothe edges of any existing objects, making it easy to align objects to one other.If youturn off the To Grid command, the To Shape command is turned off as well.�% Both the To Grid and To Shape commands, on the Snap submenu, are toggles that is,you click once to turn them on and click again to turn them off.�% If you select an object and click any of the tools on the Nudge submenu, the objectmoves one pixel at a time in the direction you want.�% The Align Or Distribute submenu contains commands that operate only when two ormore objects are selected, arranging the selected objects relative to each other.Tip Nudge with the keyboardYou can also use the arrow keys on your keyboard the functional equivalent of the Nudgebuttons to nudge objects one pixel at a time.If the To Grid command is turned on, press-ing an arrow key moves the selected object to the next gridline in that direction.The Align Or Distribute submenu can be a great help when you are working with multipleobjects.Suppose you have a number of objects that you want to be evenly spaced.You couldstart by using the Align Top command to line up one row of objects, and then choose Distrib-ute Horizontally to space them evenly.Then use the following Align Or Distribute com-mands to align objects.�% Align Left/Align Right.Lines up the left edges of all selected objects with the leftedge of the leftmost object selected.Align Right works identically, but in the oppositedirection.�% Align Center/Align Middle.Lines up the centers of objects along a vertical or middleaxis and finds the average common centerline of all selected objects.�% Align Top/Align Bottom.Lines up the top edges of objects along a horizontal axiswith the top edge of the topmost object.Align Bottom works identically with the bot-tom edges of selected objects.�% Distribute Horizontally and Distribute Vertically.Calculates the total amount ofspace between the selected objects and divides the space as equally as possible amongthem.The first and last objects (leftmost and rightmost, or top and bottom) do notmove all the objects in between are adjusted as necessary.307Part 4: Adding Graphics and PrintingChapter 10Microsoft Office Excel 2003 Inside OutProtecting ObjectsYou can prevent objects from being selected, moved, formatted, or sized by choosing Format,AutoShape, clicking the Protection tab, and selecting the Locked option.You can also use theLock Text option, which is visible only when a text box is selected, to protect the text contentsof a text box.Newly drawn objects are assigned Locked protection [ Pobierz całość w formacie PDF ]