Question

What is the advantage of using a named range

Answer 1

Answer: Advantages to Naming Cells and Ranges. Using names for cells and ranges offers the following advantages: A meaningful range name (such as Income) is much easier to remember than a range address (such as A1:A21). After you select a named cell or range, its name appears in the name box.

Answer 2

Explanation:

If you want to remove a vertical page break, select the any cell of the column which is right to the page break you want to remove, and click Page Layout > Breaks > Remove Page Break.