
This will open the Page Setup dialog box.

Saving the workbook also saves the print area. You can select multiple print areas in a single worksheet, and each area will print on a separate page. When you press Ctrl + P or click the Print button on a sheet that has a defined print area, only that area will be printed. In case you don't want to print the entire spreadsheet, set a print area that includes only your selection. This feature is known as Print Area.Ī print area is a range of cells to be included in the final printout. But what if you don't really need all the content of a huge worksheet on paper? Luckily, Excel provides the ability define the parts for printing. When you hit the Print button in Excel, the entire spreadsheet is printed by default, which often takes multiple pages.

Using an administrator account, run the following command on the target PC toĬhange the hostname of a network installed device:ĭeviceSetup.In this tutorial, you will learn how to select print area in Excel manually and how to set print ranges for multiple sheets by using macros.

The IP address of a network installed device:ĭeviceSetup.exe /serialnumber /changeip Ĭommand Line Tool to Update Hostname of Installed Printer Using an administrator account, run the following command on the target PC to change Officejet Pro and Officejet Printers Series - IT Administrators Install GuideĬommand Line Tool to Update IP Address of Installed Printer Printer installed will need to reinstall it, to compensate for the name

Zak Morton King wrote: "Presumably existing clients who have the See additional input from our consultant: Instead, you can use the command line tool to change IP address or hostname. If you are using an HP printer, it is not necessary to reinstall printers. Hello Morton King, thank you for your post and much appreciation for the helpful input from the other IT Pros.
