Group Tabs Together To Perform A Task Across The Group

You have three worksheets that will have the same column headings and/or the same row headings/labels. The only thing that will change are the numbers. So make it easy for yourself. Make the column headings and row labels of all three worksheets at the same time.

Open Excel. The three worksheets are displayed and labeled as Sheet1, Sheet2, and Sheet3. The active worksheet is Sheet1. Inactive worksheets are displayed as tan-colored tabs. Hold down the Ctrl key and click on Sheet2 and Sheet3.

In column A, type the numbers 1 through 5 in each cell of that column. In cells B2, C2, D3, E3, and F3, type the first 5 letters of the alphabet (A B C D E). Now, click on Sheet2 and Sheet3. You’ve typed into three different worksheets at the same time, with the same information.

Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.

Post Footer automatically generated by Add Post Footer Plugin for wordpress.

Originally posted 2011-02-02 07:29:35. Republished by Blog Post Promoter