Jun 17, 2019 · To select adjacent sheets, click on the first sheet tab, press Shift, and click on the last tab. To select non-adjacent sheets , click on the first sheet tab, press Ctrl , and click the other tabs one by one.

Jun 29, 2017 · Step 2.Click on the Office Button icon at the top left corner of the Excel screen. Step 3.A drop down menu will appear, click on “New” from there and choose “Workbook” followed after it. Step 4.On clicking a “Workbook”, a new workbook will be opened for you. Step 5.Prepare a copy of data within the current worksheet. Thank you for the response, but the checkboxes on that tab were already unchecked so that didn't help solve the issue. I did find another posting that stated that if all cells are locked (on a protected sheet), then the TAB key won't work (it only works between unlocked cells). Unless they are wrong, I guess I'll just have to tell my people to Nov 16, 2016 · Then click and drag it to the right. You’ll instantly start seeing more of your worksheet tabs displayed. 3. Grouping Your Worksheets Together. In Excel, working with your worksheets as a single group is a quicker way for applying formulas and formatting across worksheets with the same formatting.