- #UNABLE TO CHANGE PRINT AREA IN EXCEL 2010 DRIVERS#
- #UNABLE TO CHANGE PRINT AREA IN EXCEL 2010 DRIVER#
I didn't deliberately group anything.as a matter of fact, I didn't know group existed until just now. It won't give me the option to set a print area on any of the sheets, nor will it give me the option to 'ungroup'. Pick a size that is larger than the custom size you would like to use, and then adjust the margins within Excel so that the resulting printable area on the page is the same as you would use on your custom paper size. Now the filename says Group in the title bar.
#UNABLE TO CHANGE PRINT AREA IN EXCEL 2010 DRIVER#
If your printer driver does not allow you to define a custom paper size, the only workaround is to use one of the paper sizes it provides. (Well, you may need to restart Excel or Windows after you create the custom paper size, but that will also depend on your printer driver and how it interacts with Windows.) In those cases where your printer driver allows you to define custom paper sizes and you are successful in defining one (or more), those paper sizes should appear within Excel without your need to do anything else. You can see if your printer driver will allow custom page sizes by displaying the properties dialog box for the printer (normally displayed by clicking Properties in the Print dialog box) and poking around in the various tabs and controls it contains.
Understand, however, that this is not a feature of Excel-it is entirely dependent on the printer driver being used.
#UNABLE TO CHANGE PRINT AREA IN EXCEL 2010 DRIVERS#
That being said, some printer drivers do allow you to define custom page sizes. I know my HP Deskjet 4535 prints in colour as I have copied & printed various documents including my passport Any ideas with previous PCs there has always been an option but not on this one. This is why there is no way to set a custom page size in Excel. When I try to print an excel spreadsheet there is no option to choose between black & white or colour. Unlike Word, which can accept custom page sizes and can bypass the printer driver to force the printer to accept it, Excel gets its list of page sizes from those defined in the printer driver. To set Print Area in Excel spreadsheet, first select (highlight) Cells that we want to set as Print Area, and then navigate to ribbon Page Layout > Print Area > Set Print Area To set Print Area in Excel VBA, we have to use PageSetup.PrintArea Property. He wonders if there is a way that he can specify a custom paper size, different from those listed in the Page Size drop-down list.
New Name: (leaves area blank for you to fill in. Uttam notes that when he looks at the Page Setup dialog box, he can specify a paper size for his worksheet. But when I tried do this under Excel 2010 I'm asking for another name, because 'PrintArea' already exist in target workbook: ( NAME CONFLICT: Name cannot be the same as built-in name.
0 kommentar(er)
