Auto filter on blank lines

[Allana McDonald]

I have auto filter turned on and when I filter on something there are no
longer any blank lines at the bottom of the document (it's grey). I'm not
sure what I did to get rid of them but I'd like to have them back.

Thanks!

 

[Yanick]

I have auto filter turned on and when I filter on something there are no
longer any blank lines at the bottom of the document (it's grey). I'm not
sure what I did to get rid of them but I'd like to have them back.

Thanks!

Try to change the view. Menu View then Select "Normal". It sound like
you currently use "Page break preview".