Excel Print Five Rows Per Page - Episode 2370

У вашего броузера проблема в совместимости с HTML5

How to add page breaks so you print five rows per page of a 5000 page report? Shoaib wants to do this without VBA! There are four methods in this video, three of which do not use VBA.

Table of Contents
(0:00) Problem is how to print five rows per page without VBA
(0:22) Solution 1: Change bottom margins
(1:18) Solution 2: VBA Macro
(1:47) Selecting top row of every page with Go To Special and a formula
(2:10) Solution 3: Insert one page break, then Tab / F4 998 times
(2:46) Solution 4: Use Subtotals in hidden columns
(5:25) Wrap-up