![]() ![]() Select the worksheet (or worksheets) to which you want to copy the formatting.This copies everything on the worksheet to the Clipboard. ![]() Select all the cells in that worksheet by pressing Ctrl+A.You can also, if desired, easily copy formatting (and only formatting) from one worksheet to another. The only potential "gotcha" is that you need to be careful if you start entering information in cells because entering data in one sheet will also cause it to be entered in the same place in other sheets in the group. Once your selection set is established, then any formatting you do to one of the sheets is also done to the other sheets in the group. You can also hold down the Ctrl key as you click on various tabs to add or remove worksheets from the group. Now, all worksheets between the first and last are part of the selection set. You can, however, create "on-the-fly" worksheet groups, most often referred to as a "selection set" of worksheets.Ĭreating such a set is simple-just select the first worksheet you want in the group, then hold down the Shift key as you click the tab for the last sheet. There is no way to create persistent worksheet groups in Excel. He wondered if anyone had any suggestions for this capability in Excel. This was extremely useful, but Bill has yet to discover the same capability in Excel. In Lotus you were able to create a "grouped worksheet." Each worksheet in a group assumed the same formatting automatically. Prior to switching over to Excel, Lotus 1-2-3 was the spreadsheet program of choice where Bill worked. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |