This Excel tutorial explains how to set dynamic print area. You may also want to read: Excel dynamic Data Validation list Excel dynamic data range Excel graph dynamic data range Excel Print Area Print Area is a function to define the worksheet Range you want to print. To set a Print Area, select a Range, say A1:B6, then click on Set Print Area   Click on FORMULA tab > Name Manager You will find Range A1:B6 is named as Print_Area, which is the reserved name f...