How to remove the inscription “Page 1” in Excel: the simplest method

Many users of Excel spreadsheets are sometimes perplexed about the appearance of labels on the sheet with text indicating page numbers. Most users do not know how to remove the inscription “Page 1” in Excel, trying to get rid of it with the help of the main menu commands. Meanwhile, there is nothing complicated about this. Further, two simple methods are proposed for consideration, which are essentially identical to each other in essence.

Why does the inscription “Page 1” appear?

First, let us dwell on the reason for the appearance of such inscriptions. This is due only to the fact that Excel uses page mode to view a book (document). To remove the inscription "Page 1" in this display option can be quite simple, but, apparently, this mode was accidentally or intentionally turned on by the user. This is the so-called flipping.

how in excel to remove the inscription page 1

Thus, the essence of the question of how to remove the inscription “Page 1” in Excel or display the subsequent numbering is reduced to switching to a different type of displaying the contents of the document than the page one. There are two simple solutions for this.

How to remove the inscription "Page 1" in Excel: method one

So, first of all, pay attention to the status bar located at the bottom of the main program window. To the left of the zoom slider are three small buttons that are responsible for switching between modes (these buttons are available for any program that is part of Microsoft office suites, but are responsible for various visualization of documents).

excel page mode remove the inscription page 1

To turn off the visualization of displaying page numbers, simply click one of the buttons that is responsible for the normal viewing mode or display page layout. Thus, after pressing one of them, the numbers disappear.

How to remove the inscription "Page 1" in Excel: method two

In principle, the second method is not much different from the first, only similar actions are performed not by switching the modes with buttons, but using the tools and menus of the top panel.

how to remove the inscription page 1 in excel

How to remove the inscription “Page 1” in Excel in this case? Very simple. First you need to enter the view menu and on the panel that appears, find the block that is responsible for viewing the document. As a rule, it is located directly in the appeared tape on the very left edge. In the same way as in the previous case, here you can use the buttons to enable the layout mode or normal viewing. As already clear, after such actions the numbering disappears.

A few words to summarize

Immediately I want to disappoint all users: in addition to the two methods presented, there are no more options for disabling numbering. If you are in the page display mode of the document, any attempts to find solutions will be futile.

But somewhat distracting from the topic, you can ask a completely natural question about whether the numbering really hinders the appearance? In some cases, it helps to navigate the document data, especially if the book contains many sheets and pages. However, this is already a personal matter for each user.

If you summarize the choice of the switching method, it seems that using the buttons on the status bar looks much simpler than using the view menu, although both methods are absolutely identical to each other. In general, to whom it is more convenient. In addition, it should be noted that in different versions of the office suite the toolbars can vary quite a lot, so sometimes you have to look for the right content. But the above examples work equally well in modifications starting from 2007 and above (the 2003 package is not considered due to the fact that almost nobody uses it today, although it looks very convenient in terms of the location of the tools and controls).

Source: https://habr.com/ru/post/C43855/


All Articles