Excel Tip: Ten Tips for Working With Multiple Sheets | AccountingWEB

Excel Tip: Ten Tips for Working With Multiple Sheets

There are several tricks and shortcuts you can employ when you want to use multiple sheets within one workbook. Here are a few of our favorites - feel free to add a comment and share your own tricks with the crowd!

  1. Insert new sheets.

    Are you unhappy because only three sheet tabs appear at the bottom of your screen? Choose Insert, Worksheet from the menu and add another (and another, and another…). To speed things up a bit, click on Sheet1, hold down Shift, click on Sheet3 and three sheets are selected. Choose Insert, Worksheet and you'll insert three sheets.

  2. Rename your sheets

    Sheet1, Sheet2, Sheet3 - rather boring don't you think? Double-click right on the sheet tab and enter your own descriptive name.

  3. Rearrange your sheets

    You can change the order of the sheets quickly by dragging a sheet tab to the right or left, dropping it off whenever you're satisfied with the new location.

  4. Switch from one sheet to another

    Click on the tab of the sheet you want to view. Prefer the keyboard approach? Ctrl PageUp and Ctrl PageDown move you from one sheet to another and you never have to touch the mouse.

  5. View more sheet tabs

    You may have opened 12 sheets, but only a few tabs are visible at the bottom of the screen. That horizontal scroll bar is hogging all the room. Place your mouse over the left edge of the horizontal scrollbar and drag to the right. More sheet tabs will appear.

  6. Choose sheets for a group

    Having a party and want to invite all (or some) of the sheets? Click the tab of the first sheet to be included. Select adjacent sheets by holding down the Shift key and clicking the tab of the last adjacent sheet. All sheets from first to last will be selected. Select non-adjacent sheets by holding down the Ctrl key while you click on each sheet that goes with the group.

  7. Turn off the group selection

    You're finished treating the selected sheets as a group and want to break up the gang. Click once on any sheet other than the top (active) sheet, and only that sheet will be selected. If it's the top sheet you wanted to click on, hold down the Shift key while you click on that top sheet, and that will deselect the others.

  8. View multiple sheets simultaneously

    It's a drag, so to speak, having to click back and forth from one tab to another. View additional sheets by first opening a new window for each sheet you want to view (choose Window, New Window, for each additional sheet you want to view). Then, choose Window, Arrange, and select from the viewing options of Tiled, Horizontal, Vertical, Cascade. Click OK and each window you created will be visible; you can click on a different sheet tab in each window.

  9. Remove unwanted sheets

    If you were a bit too enthusiastic with inserting new sheets, and find you have more than you need, you can quickly remove a sheet by right-clicking on the unwanted sheet, choosing Delete, and confirming with OK.

  10. Sum numbers across multiple sheets

    Take advantage of having data on multiple sheets by combining numbers across all the sheets in your formulas. Refer to a previous AccountingWEB Excel tip for detailed steps.

Wait, there's more!
There's always more at AccountingWEB. We're an active community of financial professionals and journalists who strive to bring you valuable content every day. If you'd like, let us know your interests and we'll send you a few articles every week either in taxation, practice excellence, or just our most popular stories from that week. It's free to sign up and to be a part of our community.
Premium content is currently locked

Editor's Choice

As part of our continued effort to provide valuable resources and insight to our subscribers, we're conducting this brief survey to learn more about your personal experiences in the accounting profession. We will be giving away five $50 Amazon gift cards, and a $250 Amazon gift card to one lucky participant.
This is strictly for internal use and data will not be sold
or shared with any third parties.