However, any properties set on the group layer override its sublayers. Items that are in a group layer maintain most of their original properties. Sublayers are moved to the parent group layer, if it exists, and stand-alone tables are returned to the Standalone Tables section of the Contents pane. To ungroup a group layer, right-click the group layer in the Contents pane and click Ungroup. You can add or remove layers and tables at any time. This is because it allows you to perform your desired tasks on multiple worksheets simultaneously In this article, we'll outline all the things you can do with grouped spreadsheets and show you step-by-step how to group and ungroup your workbook for seamless editing. Tables always appear at the bottom of the drawing order, since they are not drawn. Excel's ability to group spreadsheets together is one of its best features. Layers in a group layer can be in any order, but the drawing order still applies. A box surrounding the group layer's name appears, indicating that the item will be added to the group layer.Īlternatively, you can right-click a selection of one or more items and choose Group to make the selection into a new group layer. If the group layer is not expanded, you can hover the pointer over the group layer when dragging another item.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |