Oct 30 2023 08:35 AM
Oct 30 2023 08:35 AM
When I try and print cell borders it doesnt work, but print preview shows borders. and it woks on old laptop, but not new one. any help apreciated.
Oct 30 2023 08:42 AM - last edited on Oct 30 2023 10:58 AM by Eric Starker
If you're experiencing issues with printing cell borders in Excel, but the Print Preview shows the borders correctly, it might be due to the printer settings, driver, or system-specific settings on your new laptop. Here are some steps to troubleshoot and resolve the issue:
1. **Check Printer Settings:**
- Ensure that your printer settings are correctly configured for your desired page layout, paper size, and orientation.
- Make sure that the "Draft Quality" or "Quick Print" options are not enabled in the printer settings, as they may skip certain formatting elements.
2. **Update Printer Driver:**
- Outdated or incompatible printer drivers can cause printing issues. Make sure that your printer drivers are up to date by visiting the manufacturer's website and downloading the latest drivers for your printer model.
3. **Check Page Setup:**
- Verify that the page setup settings (margins, orientation, and paper size) in Excel match your intended printing preferences. These settings can affect how the document is printed.
4. **Adjust Scaling Options:**
- In the Page Setup dialog, check the "Scaling" options. Ensure that the worksheet is set to "Fit to" 1 page wide by 1 page tall. This can help ensure that cell borders are not omitted due to scaling.
5. **Print Using a Different Printer:**
- To test if the issue is specific to the printer or driver, try printing the document using a different printer, if available. This can help determine whether the issue is with the printer or Excel settings.
6. **Try a Different Excel Document:**
- Create a simple Excel document with cell borders and try to print it. This can help determine if the issue is document-specific or applies to all Excel files.
7. **Check Printer Preferences:**
- In the printer properties/preferences dialog, check for any specific settings related to border printing, scaling, or document formatting. Adjust these settings as needed.
8. **Test on a Different Computer:**
- If possible, try opening the same Excel file on a different computer with a different printer to see if the issue persists. This can help isolate whether the problem is with your new laptop or the Excel file.
9. **Windows Updates:**
- Ensure that your Windows operating system is up to date by installing any pending updates. Sometimes, updates can address compatibility issues.
If issue still persist, pls let us know.
Please consider giving it a 'thumbs up' if it was helpful for you. (external links removed by moderator)