Cannot print from Excel? Fix Excel printing problems in Windows 11/10

Some customers are experiencing points with Microsoft Excel. Once they attempt to print from Excel, nothing occurs. Whereas, some customers have reported {that a} small window seems and disappears instantly after giving the print command to Excel. For those who can not print from Excel, the solutions supplied in this submit might make it easier to repair printing problems in Microsoft Excel.

Cannot print from Excel

Fix Excel printing problems of Windows 11/10

For those who can not print from Excel however Phrase can or possibly you see a Not sufficient reminiscence error message then listed here are some solutions that will help you repair Excel printing problems. Earlier than you proceed, just remember to are utilizing the newest model of Microsoft Workplace. You may also attempt to replace Workplace manually and see if it fixes the issue. If the issue persists, strive the options supplied under.

1. Attempt to print by way of Microsoft XPS Doc author
2. Replace your printer driver
3. Edit permissions in the Registry Editor
4. Troubleshoot Excel in Protected Mode
5. Take away and add your printer once more
6. Restore Workplace

Let’s see all these options in element.

1] Attempt to print by way of Microsoft XPS Doc Author

Earlier than printing a spreadsheet, Excel exhibits us an choice to pick out the printer. In case you are unable to print from Excel by way of your default printer, attempt to print by way of Microsoft XPS Doc Author. The steps to do that are as follows:

1. Launch Microsoft Excel and open your spreadsheet.
2. Go to “File > Print.”
3. Click on on the Printer drop-down and choose Microsoft XPS Doc Author.
4. This can save your Excel spreadsheet in the XPS format.

Now, open the saved file. You need to be capable of print it.

2] Replace your printer driver

You could be experiencing printing points with Excel as a result of corrupted or outdated printer driver. We advise you replace your printer driver and see what occurs.

You’ve the next decisions in relation to updating the printer driver.

1. Open the Windows Elective Replace web page and replace your printer driver from there (if any replace is out there).
2. Go to the official web site of your printer producer and obtain the newest model of your Printer driver. Now, double-click on the installer file to put in the printer driver manually.

3] Edit permissions in the Registry Editor

Windows Registry is a hierarchical database that shops the Windows settings and configurations. Any mistake whereas modifying the Windows Registry can result in severe injury to the system. Due to this fact, earlier than you proceed, we suggest you create a System Restore Level and backup Windows Registry.

Comply with the directions fastidiously.

Press the Win + R keys. This can open the Run command field. Sort regedit and click on OK. Click on Sure in the UAC immediate.

When the Registry Editor seems in your display, go to the next path. Merely copy the trail given under and paste it into the handle bar of the Registry Editor. After that, press Enter.

ComputerHKEY_CURRENT_USERSoftwareMicrosoftWindows NTCurrentVersionWindows

Proper-click on the Windows key and choose Permissions. The Permissions dialog field will seem. Now, click on on the Enable checkbox subsequent to the Full Management choice. Click on Apply after which click on OK.

4] Troubleshoot Excel in Protected Mode

If the issue nonetheless persists, there could be a problematic add-in. To verify this, launch Excel in Protected Mode and print your spreadsheet. If you’ll be able to print your spreadsheet in the Protected Mode, an add-in is inflicting the issue.

Now, shut Excel and open it once more in the traditional mode. Begin disabling all of the COM add-ins one after the other and print your spreadsheet each time you disable an add-in. This can let you understand which add-in is inflicting the issue. In accordance with the suggestions of affected customers, the Acrobat PDFMaker Workplace Com add-in was inflicting the issue. If in case you have put in such an add-in, disable it after which see if you happen to can print the spreadsheet. If sure, take away that add-in.

The next steps will make it easier to disable COM Add-ins in Excel:

1. Open your spreadsheet in Excel.
2. Go to “File > Options > Add-Ins.”
3. Choose COM Add-ins in the drop-down on the backside and click on GO.
4. The COM Add-ins dialog field will seem. Now, merely uncheck the checkbox to disable a selected add-in.
5. Click on OK.

Learn: Fix Excel retains flickering on Windows 11/10.

5] Take away and add your printer once more

Generally, eradicating and including the printer once more fixes the printer-related points. Utterly take away or uninstall your printer after which add it once more. Verify if this helps. You possibly can utterly take away a printer from your Windows 11/10 machine by way of:

• Settings
• The Management Panel
• Print Server Properties
• The Command Immediate
• The Registry Editor

6] Restore Workplace

If nothing helps you, restore Microsoft Workplace. Generally, the issue happens as a result of corrupted Workplace recordsdata. If that is so with you, repairing Microsoft Workplace will repair the issue. First, run a Fast Restore. If this doesn’t repair the issue, run an On-line Workplace Restore.

Learn: Microsoft Excel shows Excessive CPU utilization.

Fix Excel printing problems in Windows 11/10

Above, we have now seen the options to repair the issue when Excel doesn’t print on receiving the print command from the consumer. Now, let’s see some frequent printing problems that you could be expertise in Microsoft Excel. Generally, after we print a spreadsheet from Excel, we don’t get the specified printout. A few of you may need skilled such an issue. Such kinds of problems happen when the print settings are incorrectly configured earlier than printing a spreadsheet.

Listed here are some tweaks that you are able to do to keep away from some frequent printing problems in Microsoft Excel.

1. Suit your spreadsheet on one web page
2. Set the print space in Excel
3. Configure print settings earlier than printing the spreadsheet

1] Suit your spreadsheet on one web page

A few of you may need skilled that regardless of configuring the proper web page settings, Excel prints a spreadsheet on a couple of web page. This downside might be mounted by altering the scaling in Excel. If you wish to print all of the rows or columns on one web page in Excel, you need to change the No Scaling choice in Excel to Match all rows on one web page and Match all columns on one web page choice respectively.

2] Set the print space in Excel

If you wish to print chosen cells in your spreadsheet, you possibly can set the print space for a similar. The steps to set the print space are as follows:

1. Open Excel.
2. Open your worksheet in Excel.
3. Choose the vary of cells that you simply need to print.
4. Go to “Print Layout > Print Area > Set Print Area.”

Now, if you give the print command to Excel, it would print solely the chosen cells on a web page. You possibly can prolong the print space by including extra cells to it. If the cells that you simply need to add are adjoining to the prevailing print space, Excel will print them on the identical web page (if house is out there). If the chosen cells that you simply need to add usually are not adjoining to the prevailing print space, Excel will print them on one other web page, irrespective of whether or not the house is out there on the prevailing print space or not.

So as to add cells to the prevailing print space, observe the steps under:

1. Choose the vary of cells that you simply need to add to the prevailing print space.
2. Go to “Page Layout > Print Area > Add to Print Area.”

To clear the print space, go to “Page Layout > Print Area > Clear Print Area.”

3] Configure print settings earlier than printing the spreadsheet

You possibly can configure the print settings earlier than printing your spreadsheet. To take action, go to “File > Print” or just press the Ctrl + P keys. There you will notice totally different print settings. You possibly can change the web page orientation (panorama or portrait), choose your paper dimension equivalent to Letter, Authorized, A4, A3, and so on., change web page margins, and so on. Each time you make a change to the print settings, Excel will present you the print preview in the preview window.

Why can I print from Phrase however not from Excel?

If you’ll be able to print from Phrase however not from Excel, there could be a problematic add-in in Excel. You possibly can verify this by opening Excel in the Protected Mode. If it is possible for you to to print in the Protected Mode, one of many add-ins is the offender. Now, disable add-ins put in in Excel one after the other. Print your spreadsheet each time you disable an add-in. This can make it easier to determine the problematic add-in.

Different options that you would be able to strive are eradicating and including the printer once more, updating your printer driver, and so on.

Why received’t Excel print all of the columns?

To print all of the columns on one web page in Excel, you need to configure the web page settings earlier than printing your spreadsheet. The steps for a similar are as follows:

1. Open your spreadsheet in Excel.
2. Go to “File > Print.”
3. By default, the web page setup is about to No Scaling. It’s important to change this selection. Click on on it and choose Match all columns on one web page.

After that, it is possible for you to to print all of the columns on one web page in Excel.

Print preview is just not obtainable as a result of Microsoft Excel couldn’t hook up with the chosen printer

For those who see the “Print preview is not available because Microsoft Excel could not connect to the selected printer” error message whereas printing a spreadsheet from Excel, be sure that your pc is working on the newest model of the Windows working system. Open Windows 11/10 Settings and examine for updates. If updates can be found, obtain and set up them.

We additionally counsel you replace Microsoft Workplace manually and see if it helps. If the issue persists, restore Microsoft Workplace.

Cannot print from Excel, Not sufficient reminiscence

A few of you may need seen the “Not enough memory” error message whereas printing a spreadsheet in Microsoft Excel. The error message is self-explanatory. When the printer from which you’re printing the roles doesn’t have sufficient reminiscence, you will notice this error. Nevertheless, there are different causes too that set off this error. To repair this problem, you possibly can strive the next fixes.

1. Copy the information from your spreadsheet to a brand new spreadsheet
2. Change your default printer
3. Replace your printer driver
4. Print in Draft Mode
5. Save your Excel file in ODS format
6. Reset your printer reminiscence
7. Clear print spooler
8. Restore Workplace

Let’s see all these fixes in element.

1] Copy the information from your spreadsheet to a brand new spreadsheet

This methodology has mounted the problem of some customers. You may also do that. Copy the information from your spreadsheet to a brand new spreadsheet and see if it helps.

2] Change your default printer

If the issue nonetheless persists, change your default printer. You possibly can set any digital printer as a default printer, equivalent to Microsoft Print to PDF, Microsoft XPS Doc Author, and so on.

3] Replace your printer driver

Generally the issue persists as a result of outdated or malfunctioned printer driver. If that is so with you, updating the printer driver will resolve your downside. To take action, observe the steps written under:

1. Open the System Supervisor.
2. Develop the Print queues node.
3. Proper-click in your printer driver and choose Replace driver.
4. Choose the “Search automatically for drivers” choice. Let Windows set up the newest model of your printer driver.

If this doesn’t work, go to the official web site of your printer producer and obtain the newest model of your printer driver from there. Now, run the installer file to put in the newest model of your printer driver manually.

4] Print in Draft Mode

For some customers, printing the spreadsheet in the Draft mode mounted their downside. You may also do that and see if it helps. To take action, you need to change the Quick mode to Draft mode. By default, the print high quality is about to Quick mode. Open your print high quality settings and alter the Quick mode to Draft mode.

5] Save your Excel file in ODS format

One other efficient answer to repair this downside is to avoid wasting the Excel spreadsheet in ODS (OpenDocument Spreadsheet) format. The steps to do that are as follows:

1. Launch Microsoft Excel and open your spreadsheet.
2. Go to “File > Save As.”
3. Click on on the Save as sort drop-down menu and choose OpenDocument Spreadsheet.
4. Click on Save.

Now, open the ODS file and print it. The issue mustn’t seem this time.

6] Reset your printer reminiscence

In case your printer is working low on reminiscence, resetting its reminiscence will assist repair the problem. Resetting the printer reminiscence will clear the print jobs in the queue. To take action, observe the steps given under:

1. Disconnect your printer from your pc.
2. Flip off your printer.
3. Disconnect the ability cable of your printer and watch for a couple of minutes.
4. Join the ability cables once more and switch in your printer.
5. Join your printer to your pc.

If the above methodology didn’t assist, chilly reset your printer. The tactic to chilly reset printers is totally different for the printers of various manufacturers. Due to this fact, you need to check with the consumer handbook of your printer to know the proper strategy to chilly reset your printer.

7] Clear the Print Spooler

In Windows, Print Spooler is a service that shops the printing jobs briefly. If Excel is exhibiting the “Not enough memory” message whereas printing a spreadsheet, clearing the Print Spooler might repair the issue. The steps to clear the Print Spooler are as follows:

1. Press the Win + R keys to launch the Run command field.
2. Sort companies.msc and click on OK. This can launch the Providers Administration window.
3. Scroll down and find the Print Spooler service.
4. As soon as you discover it, right-click on it and choose Cease.
5. Open the File Explorer and go to the “C:WindowsSystem32spool” path. Merely copy this path and paste it into the handle bar of the File Explorer. After that, hit Enter.
6. Open the PRINTERS folder and delete all of the recordsdata inside it. Don’t delete the PRINTERS folder.
7. Return to the Providers Administration window and right-click on the Print Spooler service.
8. Choose Begin.

8] Restore Workplace

Verify if you’re getting the identical error message in different Workplace apps, like Phrase. If not, a few of the Excel recordsdata could also be corrupted. To repair this downside, run a web based restore for Microsoft Workplace.

Hope this helps.

Learn subsequent: Excel freezing, crashing, or not responding.