Forum Discussion

Demetrius219's avatar
Demetrius219
Copper Contributor
Dec 23, 2019
Solved

Excel Print Area

I have a workbook with four sheets. In each sheet there are sections that I would like to print. I sent under sheet options > print area: and entered the range there but the entire sheet including th...
excel
  • Branka Bradule's avatar
    Branka Bradule
    Jan 05, 2020

    Demetrius219 have you tried first to set a print area of each sheet and only then choose to print entire Workbook?

     

    The procedure should be as:

    Sheet 1: Select the range -> Set Print Area

    then

    Sheet 2: Select the range -> Set Print Area

    then

    Sheet 3: Select the range -> Set Print Area

    then

    Sheet 4: Select the range -> Set Print Area

     

    As in example below:

     

    Then click Print (cmd+p on mac or ctrl+p on windows) and select to print entire workbook.

    It should work like this.

    I hope this helps.

     

    Best,

    Branka

Branka Bradule's avatar
Branka Bradule
Brass Contributor
Jan 05, 2020

Demetrius219 have you tried first to set a print area of each sheet and only then choose to print entire Workbook?

 

The procedure should be as:

Sheet 1: Select the range -> Set Print Area

then

Sheet 2: Select the range -> Set Print Area

then

Sheet 3: Select the range -> Set Print Area

then

Sheet 4: Select the range -> Set Print Area

 

As in example below:

 

Then click Print (cmd+p on mac or ctrl+p on windows) and select to print entire workbook.

It should work like this.

I hope this helps.

 

Best,

Branka

Resources