![]() ![]() Excel also adds the word to the title bar to indicate you have a group of worksheets selected. A range of worksheets should now be selected. Hold down the Shift key as you click on the tab for the last worksheet in the series you want to edit.Select the first workbook in the series that you want to edit.If your worksheets are very similar to each other, Excel provides a very easy way to modify the contents of a particular cell on each workbook, all at the same time. ![]() The only thing that may be different is the heading on each worksheet-along with the raw data for each month, of course. Each worksheet contains the same rows, the same columns, and the same formulas. Each worksheet in the workbook is devoted to a different month of the year. For instance, you might have a workbook that contains your annual budget data. It is not unusual for all the worksheets in a particular workbook to be very much the same as each other.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |