Excel send for printing page 1 automatically

[serpico75]

Hello everyone!
Please, I would like your help to the following issue.

On Excel 365, I have a working sheet that is composed of 6 pages.

On the past, an old colleague of mine, that now I cannot communicate with to help me, had done the following with printing:

When you give print to the file, it only opens the prview window of Excel and on the bottom it displays"

Page 1 of 1

and not

Page 1 of 6,

and when you click on “Print” button, only page 1 will be printed.

What I want to do is to know how only first page is being sent for printing, and not all 6 pages of the working sheet. I have tried a lot with printing options, and with combination of printing options and printer options, but cannot make it.

The only thing I achieve (and is not what I want), is to make all six pages shrink to one.

I would like when printing, only first page to be sent for printing. I know that option are:

“Select current page”

or

“Print pages from 1 to 1”

but I would like to achieve this not with one of these ways.

Could you please help me?

Thank you for your time!

[Rod-IT]

Try

Going to the Page Layout tab.
Click Print Area → Clear Print Area (just to reset).

Your colleague may have set a print area

Option 2

File → Print.
Under Settings, make sure:
Print Active Sheets is selected.
Print Entire Workbook is not selected.

[serpico75]

Thank you for your answer.

With:

Print Area → Clear Print Area (just to reset)

if there are many print areas defined on a worksheet, clearing the print area will remove all of them. On the worksheet I am now (of my colleague’s one), things are working fine, and maybe, with reset, will lose them. The one I want is find out how I can make it on a new worksheet.

And with Option 2 I couldn’t make it.

[serpico75]

Completed.

Essentially, you gave me the solution.

To see how it works:

-Create a new file with many data (e.g. 4 pages).

-Just mark the cells that are included on page 1 (or any page that you want e.g. mark page 3 data or some specific cells you are interested in for printing only these).

• On the

“Page Layout” tab, in the “Page Setup” group, click “Print Area” , and then click “Set Print Area”.

What my colleague had done was not to chose somewhere an option about whole page 1 for printing, but had chosen data/cells of page 1, to create the printing area. It is a kind of same thing with:

Whole Page 1

and

Manually choose all cells of page one.

A very interesting Microsoft page on specific issue is following:

Set or clear a print area on a worksheet - Microsoft Support

Thanks a lot for your help !!