Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Is there a way to undo page breaks on multiple worksheets in Excel?
I have an Excel file with about 100 sheets in it. I previously had set each sheet to print out on two pages however, I no longer want that. Is there a way to reset all my page breaks at once so I don't have to go in and mess with 100 different sheets?
1 Answer
- kezzybearLv 41 decade agoFavorite Answer
Select all of your sheets by clicking the first tab of the first sheet and holding down the shift key click the last tab of the last sheet (this groups the worksheets - whatever you do now it will apply it to all of the sheets selected).
Insert -> Reset Page Breaks.
Voila!
Oh and always remember to undgroup your sheets.
