MS Excel Extra Blank Pages Printing Problem

[khubaib74]

i have a problem

=IFNA(INDEX(tblFiltrList[Name],MATCH(B9,tblFiltrList[Roll No],0)),"") After applying this formula, blank cells are blank shows but are leading to extra pages in print. After deleting this formula from the blank cells, this print problem is fixed
plz help how to fix it

 

[Alex Blakenburg]

Your best bet is going to be to either use a Table or a dynamic print area.
For details on setting up a dynamic print area see:

Excel Factor 5 Dynamic Print Area

The following Excel Factor entry was sent in by Daniel Ferry, founder of Excel enthusiast blog, Excel Hero. Often an Excel model needs a dynamic print area, as data that we wish to print may change over time. Watch how the print area for the table below (depicted by the dashed line around the...

www.myonlinetraininghub.com

You will end up with a Print_Area named range that uses a formula that looks something like this:

=OFFSET($A$1,0,0,COUNTA($A$1:$A$200),COUNTA($A$1:$Z$1))

Note: CountA counts non-blank cells, so don't use the column that is returning "" since those lines will be counted.
Use a column that you can rely on to always be populated.
If you have empty rows above the column that you are using to count the rows, you will need to add them to the CountA result in the 2nd last position of the formula being the CountA of the rows.