Forum Discussion
Savdin96
Sep 08, 2023Copper Contributor
Text Appearing on Seperatae Worksheets
I am creating a new spreadsheet, with multiple worksheets.
For some reason when type 3 lines of text in one worksheet, it will appear in 3 out of 5 of the other worksheets. Interesting to note, the text appears in the same cells (B3) on the 3 out of 5 other worksheets.
- Detlef_LewinSilver Contributor
Your worksheets are grouped.
https://support.microsoft.com/en-us/office/group-worksheets-4e1f7747-3d63-4fd7-8a36-838b05adc0f0
- Savdin96Copper ContributorI tried this solution, and it appears the worksheets are not grouped. When I right-click on any worksheet, the only option is to select all worksheets.
- JosephDelliGattiBrass Contributor
Savdin96 If only one tab at the bottom of your workbook is highlighted/selected, you'll only see the "Select All Sheets" option. If that's the only option you see, then typing in a cell won't put it in the same cells on other worksheets.
If you see the option to "Ungroup Sheets", then you've got more than one tab highlighted.
- Savdin96Copper ContributorThank you Detlef, for your response.
I will give that a try and let you know if it works.