The short cut key to set up the print area is ALT + P + R + S. After selecting the data range, go to PAGE LAYOUT > Print Area > Set Print Area. For example, look at the below data in a worksheet.įirst, select the print area, i.e., data range from A1:N32. The first thing we need to do while printing is to set the print area.
