Buzz
Excel is a versatile spreadsheet software that assists users in calculations, creating charts, etc. Despite being a familiar program, not everyone understands its settings thoroughly.
Smart tips for removing submerged text, 'Page 1', 'Page 2' in Excel
Recently, Mytour has observed a growing number of readers curious about how to remove submerged text, 'Page 1', 'Page 2' in Excel. This issue arises when users open Excel files and notice large 'Page' text, printed in the center of the page, which cannot be removed and is aesthetically displeasing.
Handy tip to remove submerged text, 'Page 1', 'Page 2' in Excel 2019
Firstly, it's important to clarify to everyone that submerged text in documents is not an error. On the contrary, it's a feature provided by Excel for users. By default, when you enable Page Break Preview, the 'Page 1', 'Page 2', etc., texts appear to show users how the printed page will look without needing to press Print Preview. Thanks to this feature, you can have a better overview and adjust the content or paper size accordingly.
So if you want to disable or remove submerged text, 'Page 1', 'Page 2' in Excel 2019, what should you do? Follow the steps outlined by Mytour below.
Step 1: Open the Excel file with submerged text. On the Ribbon toolbar, click on the View tab.
Step 2: In the Workbook Views group, you'll see various document display modes in Excel. Currently, you're in Page Break Preview mode. To hide or remove the submerged text, simply switch the document view mode. Mytour recommends selecting Normal.
So, Mytour has successfully guided you on how to remove submerged text, 'Page 1', 'Page 2' in Excel or turn off Page Break Preview mode. Whenever you want to re-enable this feature, just follow the steps above and select Page Break Preview mode. Wish you success. If you're using Excel 2013, refer to the article on Inserting watermark in Excel 2013 here.
