Excel
Excel
Excel
- You may start by enabling the Microsoft Print to PDF feature.
- Running the printer troubleshooter will fix any underlying problems that cause this printer issue.
- If the issue is caused by outdated or corrupt drivers, uninstalling and reinstalling the printer should work.
Fix 1: Ensure Print to PDF Is Enabled in Windows Features
Microsoft Print to PDF integrates into the Print dialog box on your PC. Sometimes, the feature no longer appears when you open the Print dialog box for a certain file. Whatever the reason, you can ensure the feature is enabled with the following steps.
Step 1: Click the Start button, type Windows Features , and click the first result .
Step 2: Find and check the box for Microsoft Print to PDF .
Note : If it’s already enabled, disable it and wait a few seconds. Then, repeat the steps to open Windows Features and enable the feature again.
Step 3: After that, click on OK .
If you need to install it, follow the on-screen instructions and proceed. Reboot your PC and open the Print dialog once again. You should see the Print to PDF option back.
Now, you can save images and perform other functions using Microsoft Print as PDF.
Fix 2: Run the Print Troubleshooter
Using the built-in print troubleshooter would resolve most problems and is a good fix when Microsoft Print to PDF is not working on Windows 11.
Step 1: Click the Start button, type Control Panel , and press Ente r to open the Control Panel on your Windows 11 PC.
Step 2: Click on View devices and printers under Hardware and Sound.
Step 3: Click Printer & scanners .
Step 4: Click Microsoft Print to PDF .
Step 5: Click on Run the troubleshooter and follow the wizard to complete the process.
Step 6: Click Next and follow the wizard to complete the troubleshooting.
Fix 3: Uninstall and Reinstall Print to PDF Drivers
Your PC comes with Microsoft Print to PDF drivers pre-installed by default. If you haven’t updated these drivers recently, they could have become obsolete, preventing the feature from functioning. Uninstall the drivers and reinstall them using the steps below.
Step 1: Click the Start button, type Control Panel , and press Ente r to open the Control Panel on your Windows 11 PC.
Step 2: Click on View devices and printers under Hardware and Sound.
Step 3: Click Printer & scanners > Microsoft Print to PDF .
Step 4: Lastly, click on Remove .
Now, you may reinstall it by following the steps below.
Step 5: Click the Windows button, type Windows PowerShell , and select Run as Administrator from the right pane.
Step 6: Type the following command and hit Enter :
Enable-WindowsOptionalFeature -online -FeatureName Printing-PrintToPDFServices-Features -All
Step 7: You should see the text True next to Online. This confirms that the feature has been re-enabled.
Step 8: Finally, restart your computer and check if Print to PDF works as intended.
Fix 4: Set Print to PDF as Your Default Printer
Print to PDF is essentially a software feature that emulates the presence of an actual printer. Hence, setting it as your default printer might be a good option. This way, giving the print command on any document should automatically trigger Print to PDF. Here’s how to set it as your default printer on Windows 11.
Step 1: Click the Start button, type Control Panel , and press Ente r to open the Control Panel on your Windows 11 PC.
Step 2: Click on View devices and printers under Hardware and Sound.
Step 3: Click Printer & scanners .
Step 4: Disable Let Windows manage my default printer .
Step 5: Click Microsoft Print to PDF .
Step 6: Lastly, click Set as default .
Was this helpful?
- Corrupted Excel files, faulty add-ins, and outdated printer drivers are some of the most common causes of this issue.
- Try printing another Excel file to ensure the issue is not limited to a specific spreadsheet.
- You can try running the Microsoft Office repair tool if nothing else works.
Fix 1: Save Your Excel File in XPS Format and Try Again
If Excel can’t respond to print requests, save your file in the XPS format and try again. Several users on Microsoft Community post reported fixing the issue with this simple workaround. So, if you’re in a rush, try this method.
Step 1: Open the Excel file you wish to print and click the File menu at the top left corner.
Step 2: Navigate to the Print tab and use the drop-down menu under Printer to select Microsoft XPS Document Writer . Then, click the Print button.
Step 3: When the Save Print Output As dialog appears, save your Excel file in the XPS format. It should print without issues.
Fix 2: Open Excel in Safe Mode
You can try printing an Excel file in safe mode to see if one of the third-party add-ins is causing the problem. For that, press the Windows key + R to open the Run dialog. Type excel -safe in the box and press Enter .
Check to see if Excel prints your file in safe mode. If it does, one of the third-party add-ins is to blame. You can disable all add-ins and re-enable them individually to isolate the culprit.
Step 1: Open Microsoft Excel and go to File > Options .
Step 2: In the Excel Options window, switch to the Add-ins tab from the left column. Select COM Add-ins in the Manage drop-down menu and click the Go button.
Step 3: Uncheck all the Add-ins and click OK .
After this, restart Excel and enable your add-ins one at a time. Print a test page after enabling each add-in to identify the one causing the issue.
Fix 3: Update Printer Driver
Issues with your printer driver can affect Excel’s ability to print spreadsheets and lead to problems. To avoid this, you should ensure that your printer driver is up to date and functioning properly.
Step 1: Right-click on the Start icon and select Device Manager from the menu that appears.
Step 2: Double-click on Print queues to expand it. Right-click on your printer and select Update driver .
Follow the on-screen prompts to finish updating the printer drivers. After that, try printing your file again.
Fix 4: Remove and Reinstall Your Printer
If Microsoft Excel still can’t print, try removing your printer and re-adding it on Windows. Here’s how to do it.
Step 1: Press the Windows key + I to open the Settings app.
Step 2: Select Bluetooth & devices from the left sidebar and go to Printers & scanners .
Step 3: Select your printer from the list.
Step 4: Click the Remove button at the top to delete your printer.
Step 5: After that, return to the Printers & scanners menu and click on Add device . Then, follow the on-screen prompts to add your printer again.
Fix 5: Repair Microsoft Office
Microsoft Office offers a handy repair tool for any issues with Office apps. If nothing else works, consider repairing Microsoft Office by following the steps below.
Step 1: Right-click on the Start icon and select Installed apps from the list.
Step 2: Scroll down to locate the Microsoft Office product on the list. Click the three-dot menu icon next to it and select Modify .
Step 3: Select Online Repair and hit Repair .
Was this helpful?
- You can’t directly save emails as PDFs in Outlook or Gmail apps for iOS.
- Use the Print function and redirect it to create a PDF.
- Select Save to Files and choose a location to save the PDF.
Print Emails to PDF in Outlook for iOS
Step 1: Open the email you want to convert.
Step 2 : Once it loads, tap the three-dot icon and follow up by tapping Print Conversation .
Step 3 : Perform a Zoom Out gesture over any generated thumbnails within the Printer Options screen. That will convert the email to PDF format immediately.
Step 4: Share the PDF with a third-party app or save it locally using the Save to Files option.
How to Print Emails to PDF in Gmail for iOS
Step 1: Open the email you want to save as a PDF file.
Step 2 : Next, tap the three-dot icon next to the Reply icon. On the menu that shows up, tap Print .
Step 3: Tap AirPrint to continue. On the Printer Options screen, perform a Zoom Out gesture over any listed thumbnails to convert the email to PDF format.
Step 3: Tap the Share option on the PDF preview screen and share the converted email to a third-party app or save it to the Files app.
Converting emails to PDF format while using Outlook for iOS or Gmail for iOS is easy. You can also do the same on any other email client, be it Spark, Airmail, or Edison Mail, using the same Print gesture within the Printer Options screen as long as you can find the Print option.
Was this helpful?
- Add a header to print your company name, address, logo, etc., on every page.
- Use Freeze panes to lock the 1st row and 1st column of an Excel sheet.
- Uncheck Headings (View > Show pane) to hide Column name and Row numbers.
Print the First Row or Column on Every Excel Page
Step 1: On your workbook, select the desired sheet and navigate to the Page Layout tab on the ribbon.
Step 2: Then, click on the icon for Page Titles under the Page Setup section.
Step 3: In the Page Setup modal window, switch to the Sheet tab and spot the section for Print titles . It includes row and column options.
Note: Though we focus on the header row, the setting can also be applied to columns.
Step 4: To set up printing of the top row on each page, click on the Arrow up button in front of ‘Rows to repeat at top’ text box. For columns, take the second one.
Step 5: That will take you to the Excel sheet along with a dialog box. Click row number 1 (on the sheet) and press the arrow-down button in front of it.
Here, you can select multiple rows on each page if you wish to repeat them. Generally, you would want the top row and, in rare circumstances, the leftmost column.
Step 6: Back in the Page Setup modal window, you will see the text boxes populated with the row/column values to repeat on each page. You can choose Print Preview to ensure the print includes a header or columns on all pages.
In the print preview, check whether the settings work. Note that the settings are sheet-specific and do not apply to the workbook.
If you cannot print, check out the guide on Excel printing fixes .
How Do You Print Row and Column Numbers When Printing in Excel?
Sometimes, you also want to print row headings 1, 2, . . . and column headings A, B, . . . To achieve this, navigate to Page Layout > Sheet Options and check the Row and column headings box in the Print section.
Why Is Print Titles Button Greyed Out?
If you cannot access the Print Titles button, it might be because you are editing a cell or have a chart selected. Similarly, if you cannot use the Rows to repeat at the top spreadsheet icon, it could be because you have selected multiple worksheets within your workbook.
Was this helpful?
- In most cases, running the printer troubleshooter or configuring the “Print Spooler Service” should resolve the error.
- Deleting old printer devices and print spooler files can also help fix the issue.
- If nothing works, you may need to delete corrupted print spooler registry entries.
Fix 1: Run Printer Troubleshooter
Windows comes with a dedicated printer troubleshooter that can automatically diagnose and fix any printing issues on your PC. It checks all of your printer configurations and corrects any inconsistencies. Here’s how to run it.
Step 1: Press the Windows key + I to launch the Settings app and head to System > Troubleshoot .
Step 2: Go to Other troubleshooters .
Step 3: Click the Run button next to Printer to begin troubleshooting.
From there, follow the on-screen prompts to finish the troubleshooting process.
Fix 2: Check Print Spooler Service
If the Windows troubleshooter fails to identify any issues, you can check the Print Spooler service on Windows to see if it is properly configured. Here’s how.
Step 1: Press the Windows key + R to open the Run dialog. Type services.msc in the box next to the Open field and press Enter .
Step 2: In the Services window, scroll down to locate Print Spooler . Right-click on it and select Properties .
Step 3: Set the Startup type to Automatic from the drop-down, if it isn’t set already.
Step 4: On the Recovery tab, use the drop-down menus next to First failure, Second failure, and Subsequent failures to select Restart the Service . Then, click on Apply followed by OK .
Restart your PC and check if the print spooler stops again.
Fix 3: Remove Old Printers
Sometimes, the print spooler service may also stop working if several printers are connected to your PC. You can try deleting some of your old printer devices to see if that helps.
Step 1: Click on the search icon on the taskbar, type in printers & scanners and press Enter .
Step 2: Select the printer you want to remove.
Step 3: Click on the Remove button in the top right corner. Repeat this process to remove unwanted printers and try using the printing services again.
Fix 4: Delete Old Print Spooler Files
Existing print spooler cache data can also interfere with the service and cause it to crash repeatedly when corrupted. In that case, you can delete those old print spooler files to fix the issue.
Step 1: Press the Windows key + S to open Windows Search. Type services in the box and select the first result that appears.
Step 2: Right-click on Print Spooler and select Stop .
Step 3: Press the Windows key + E to launch File Explorer on your PC and navigate to the following folder:
C:\Windows\System32\spool\PRINTERS
Step 4: Select all folders and click on the trash icon at the top to delete them.
Restart your PC after you delete the files. The print spooler service should start automatically upon reboot.
Fix 5: Update Printer Drivers
Issues with your current printer drivers can also cause the print spooler to stop abruptly. If the printer drivers on your PC are outdated or corrupted, then updating them should help more often than not.
To update printer drivers, download the most recent drivers from the respective manufacturer’s website. Then, open the downloaded file to begin the installation.
Fix 6: Delete Print Spooler Registry Keys
If none of the above solutions work, you can try deleting a few registry keys associated with the print spooler. Here’s how:
Step 1: Press the Windows key + R to launch the Run dialog box. Type regedit in the box and press Enter .
Step 2: Paste the following path in the address bar at the top to navigate to Print Processors:
Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Print\Environments\Windows x64\Print Processors
If you’re using a 32-bit version of Windows, use the following path:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Print\Environments\Windows NT x86\Print Processors
Step 3: Delete all keys inside Print Processors except winprint . To delete a key, right-click on it and select Delete . Click on Yes on the prompt.
Was this helpful?
Have you been told to take a screenshot using the Print Screen key on your Windows 10 computer? And now you are left wondering where the Print Screen button is? Even if you found the button and pressed it, nothing would have happened. So you are more confused now. Don’t worry. We are here to help. By the end of the post, you will be a champ in using the Print Screen button to take screenshots on Windows 10.
Questions like where is the Print Screen button, how to enable Print screen, and how to use the Print screen button are answered in this post. We have also covered how to take a screenshot in Windows 10 without the Print screen button.
Let’s get started on discovering the superpowers of the Print Screen button in Windows 10.
Where Is the Print Screen Button
The Print Screen button is usually present at the upper right side of your keyboard. You will see one of the text labels on the key:
- Prt sc
- PrtSc
- PrtScn
- PrntScrn
If something else is mentioned along with the print screen button, then you will have to trigger it with the function key (fn) on your keyboard. That is, hold the fn key and the Print screen buttons together to take a screenshot.
Tip : If your keyboard doesn’t have the Print Screen button , use the Function (fn) + Windows key + Spacebar to take a screenshot. In case the Print screen isn’t working , check out various ways to fix it.
How to Use Print Screen Button to Take Screenshot in Windows
There are several ways to take a screenshot using the Print screen button on Windows 10. Let’s check them out.
Method 1: Capture Entire Screen With Print Screen
This is the simplest method to take a screenshot on Windows 10. Pressing the Print Screen key on your keyboard copies the entire (active) screen to your clipboard . Even though a screenshot is technically captured, it’s not saved anywhere on your computer.
The screenshot resides in your computer’s clipboard for a temporary period till you copy something else. You need to paste the copied content (the screenshot) in a supported app such as MS Paint, Paint 3D, etc. Use Ctrl+V keyboard shortcut to paste the image. Once pasted, save the image using the app’s save button. It’s not necessary to paste the screenshot in photo-editing apps, you can even paste it in Microsoft Word or Google Docs .
Note: Use fn + Print screen combination if nothing is copied to the clipboard.
Typically, when you take a screenshot on your mobile phone, the screen will dim for a second, which indicates that a screenshot is taken. However, nothing will happen to the screen using this method. The screen won’t dim when you simply press the Print Screen button. So don’t get scared, just open any supported app and paste the copied screenshot.
Tip: If you use OneDrive, your captured screenshots will automatically be saved in your OneDrive folder. In case you are notified that screenshots are saved in OneDrive, find out how to turn off that notification and how to disable storing of screenshots in OneDrive .
Method 2: Capture and Save Entire Screen Using Print Screen
The above method doesn’t save the screenshot directly to your computer. To save screenshots on your PC without pasting them first, press the Windows key + Print screen button simultaneously. The screen will dim for a second, indicating that a screenshot has been taken. In this method, the entire screen is captured.
You will find the captured screenshots in the Pictures > Screenshots folder. If you don’t find that, follow this path C:\Users\username\Pictures\Screenshots.
Method 3: Capture Active Window With Print Screen
Instead of capturing the entire screen, this method will help you take a screenshot of an active window. Let’s say you want to take a screenshot of the minimized Word screen. You can do it by using the Alt + Print screen keyboard shortcut. Press both buttons simultaneously to take a screenshot of your active window.
Similar to method 1, the screenshot will not be saved directly. You will need to paste it into a supported app such as MS Paint and then save it.
Method 4: Assign the Snipping Tool to Print Screen Key
If the above methods do not meet your requirements, you can assign the Windows 10 Snipping tool to the Print screen key. When you do so, the Snipping tool will get activated when you press the Print screen key on your keyboard.
With the Snipping tool, you can take custom screenshots. You can choose the area whose screenshot you want to take, capture the selected window, and perform other advanced tricks. The screenshots will open in the Snipping Tool where you can annotate and draw on them. Finally, save the screenshot. Check out various tips and tricks related to the Windows 10 Snipping Tool .
To assign the Snipping tool to the Print screen key, follow these steps:
Step 1: Open Settings on your Windows 10 PC from Start Menu. Alternatively, use Windows + I keyboard shortcut to open settings. Go to Ease of Access.
Step 2: From the left sidebar in Ease of access, scroll down and click on Keyboard. On the right side, you will find Keyboard settings. Scroll down and enable the toggle for Print Screen shortcut.
Bonus: How to Take Screenshot Without Print Screen on Windows 10
If you don’t want to remap the Print screen key to the Snipping tool or use Print screen to take a screenshot, you can still open the Snipping tool using the Windows key + Shift + S keyboard shortcut. Alternatively, open the Snipping tool from the Start Menu. You can also use the Snip and Sketch tool of Windows to take a screenshot without the Print screen button. Find out what’s the difference between the Snipping Tool and Snip and Sketch on Windows 10.
The Best Method
Methods 2 and 4 are convenient for taking and saving screenshots both. I mostly settle for Method 4 on my computer where I use the Snipping tool with the help of the Print screen button. It lets me take a screenshot with the ability to draw on them.
Next up: If for some reason, you are unable to take screenshots on your Windows 10 PC, check out 4 ways to fix it from the next link.
Was this helpful?
Loved your instructions, I tried the first three instructions (which were easy to follow) and solution number 4 worked!!!! Thank you, thank you!
