Excel worksheet dpi

Question

Hi, could anyone tell me why different worksheets in a spreadsheet are set at different dpi.

Some are set at 300dpi and others at 600dpi.

I use an HP 7220 printer.

Answer 1

Hello, I’m Mite, here to help.

Different worksheets can show different DPI settings because Excel saves the print quality setting separately for each worksheet, rather than applying one DPI setting to the whole workbook automatically. So one sheet may be set to 300 dpi, while another may be set to 600 dpi.

You can try the following:

1. Open the Excel file and go to the worksheet you want to check.
2. Go to Page Layout > Page Setup > Page.
3. Look for Print quality and set it to the DPI you want, such as 600 dpi.
4. To change multiple worksheets at once, right-click a worksheet tab and choose Select All Sheets, then change the Print quality setting.
5. After changing it, right-click a worksheet tab again and choose Ungroup Sheets, so you do not accidentally edit all sheets later.
6. If the DPI options still look wrong or are missing, try updating or reinstalling the HP 7220 printer driver.