Working with Multiple Worksheets in MS Excel 2007
by Carol Bratt on May, 16 2007 at 08:05AM EDT
Working with multiply sheets concurrently is how MS Excel power users create and format a complex workbook with the least amount of effort expended.
Follow the steps below to make working with multiple sheet a piece of cake and you will be on your way to becoming a power user!
- Hold down the CTRL key as you click each tab top select multiple worksheets.
- To select a contiguous group of worksheets, click the first one in the group and then hold down the Shift key and click the last one in the group.
- To select all the worksheets in the current workbook, right-click any worksheet tab and choose Select All Sheets from the shortcut menu.
- To quickly make any sheet active, click its index tab; to remove a sheet from a selected group of sheets, hold down CTRL and click its tab.
- To remove the multiple selection and resume working with a single sheet, click any unselected sheet. If you have selected every sheet in the workbook, right-click any worksheet tab and choose Ungroup Sheets.
- If you have selected more than one sheet, you see the word Group in brackets in the title boar, and any data you enter appears in the corresponding cells on each worksheet in the group. So, if you have grouped Sheet1, Sheet2 and Sheet3, entering text in cellA1 on Sheet1 also enters the same text in the corresponding cells on Sheet2 and Sheet3.
- Any choices you make such as applying a number format, affect all the grouped worksheets identically. If you are building a workbook with identically formatted sheets, you can use these techniques to quickly enter category headings, etc. along the top of each sheet.
You cannot use the Clipboard to enter data into multiple sheets concurrently. When you paste data, it only appears in the active sheet and not in any other sheets you have selected.
When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!
Filed under:
Rate this article:
Most popular articles
- Which Processor is Better: Intel or AMD? - Explained
- How to Prevent Ransomware in 2018 - 10 Steps
- 5 Best Anti Ransomware Software Free
- How to Fix: Computer / Network Infected with Ransomware (10 Steps)
- How to Fix: Your Computer is Infected, Call This Number (Scam)
- Scammed by Informatico Experts? Here's What to Do
- Scammed by Smart PC Experts? Here's What to Do
- Scammed by Right PC Experts? Here's What to Do
- Scammed by PC / Web Network Experts? Here's What to Do
- How to Fix: Windows Update Won't Update
- Explained: Do I need a VPN? Are VPNs Safe for Online Banking?
- Explained: VPN vs Proxy; What's the Difference?
- Explained: Difference Between VPN Server and VPN (Service)
- Forgot Password? How to: Reset Any Password: Windows Vista, 7, 8, 10
- How to: Use a Firewall to Block Full Screen Ads on Android
- Explained: Absolute Best way to Limit Data on Android
- Explained: Difference Between Dark Web, Deep Net, Darknet and More
- Explained: If I Reset Windows 10 will it Remove Malware?
Need Help? Ask!
My name is Dennis Faas and I am a senior systems administrator and IT technical analyst specializing in cyber crimes (sextortion / blackmail / tech support scams) with over 30 years experience; I also run this website! If you need technical assistance , I can help. Click here to email me now; optionally, you can review my resume here. You can also read how I can fix your computer over the Internet (also includes user reviews).
My name is Dennis Faas and I am a senior systems administrator and IT technical analyst specializing in cyber crimes (sextortion / blackmail / tech support scams) with over 30 years experience; I also run this website! If you need technical assistance , I can help. Click here to email me now; optionally, you can review my resume here. You can also read how I can fix your computer over the Internet (also includes user reviews).
We are BBB Accredited
We are BBB accredited (A+ rating), celebrating 21 years of excellence! Click to view our rating on the BBB.