Now when you give the print command, only the set print area will be printed. You also can change the name of the Print Area as required.This option would set the selected range of cells or area as Print Area and also gives the name of that area under Name Box.Click on the Set Print Area option as shown in the below screenshot.It will open a drop-down list of options.Click on the Print Area option under the Page Setup section, as shown in the below screenshot.Select the range of cells that you want to print or set as the print area in that worksheet.We have given some employee data, and we want to print the whole data, excluding the Salary of the employee.įor setting up the print area in the Excel worksheet, follow the below steps: You can download this Print Area Excel Template here – Print Area Excel Template Example #1 TEXT and String Functions in Excel (26+).Lookup Reference Functions in Excel (34+).Excel Conditional Formatting Based on Another Cell Value.SUMPRODUCT Function with Multiple Criteria. Compare Two Columns in Excel for Matches.
0 Comments
Leave a Reply. |