Hello,
Inside a book I have 16 ranges, each range has 52 rows, I have red borders in each range to make it easier to understand what the ranges are.
Is it possible for the 16 ranges, in the yellow areas, which cells do not contain data, to hide the entire row?
(In first cell of each yellow ranges i use formula filter to my book, but not here in example)
After hiding the rows, is it possible to define as a print area as many areas that have data even in a cell in the yellow area?
Is it possible, since the print area is defined by the areas that have data, that the areas with the red borders don't split into two pages when I'm in the print preview?
(the areas with red borders, because each one has 40 cells available, the yellow areas, for entering data, it is certain that they will constantly increase and decrease every time the data changes)
Thanks for your time
Bookmarks