Forum Discussion

P Tedesco's avatar
P Tedesco
Copper Contributor
Aug 24, 2018

Excel - Printing non-continuus areas in a spreadsheet

Good morning.

 

I am looking for help in printing non-continuous areas in a spreadsheet. I have attached a spreadsheet and I am looking to see if a solution can be found to print only the area highlighted in pink.

 

I am new to this forum so if  my request is through the wrong channels please let me know how I should proceed.

 

I appreciate any help and guidance.

 

Thank you

 

excel
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Aug 24, 2018
    - Select columns C to N
    - from the Data tab, choose Group, Group
    - Repeat same for rows 28 to 30
    Now if you need to print, simply collapse by clicking the little minus boxes or by clicking both 1's. SHow everything again by clicking the 2's.

Resources