Grouping and ungrouping worksheets in any version of Microsoft Excel


If you are going to want similar information in several worksheets in an Excel workbook, you can group the worksheets together, then any typing of labels, formatting and entering of formulas will be applied to all the grouped worksheets at once. To group worksheets together, click on the first sheet tab to be included in your group, then either press Ctrl and the other worksheet tabs to be included in the group, or press Shift and click on the worksheet tab of the last sheet to be included in the group. After the name to the workbook in the Title bar, you will see the word Group. When you have finished working with the worksheets as a group, you will want to ungroup them to work with each one individually and enter data specific to each worksheet. To ungroup, right-click on a grouped worksheet tab, then click Ungroup…

View original post 25 more words


About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 (or 150 Aussie dollars)for every time someone says "If only I'd known that." ....
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s