
How do I show only the print area in Excel and grey out the rest?
Mar 23, 2016 · I'm trying to replicate an Excel spreadsheet that someone sent me and I can't figure out how. The print area is set, and all cells outside the print area are greyed out. The cells aren't simply …
How to remove the print preview lines in Excel 2010?
Sep 6, 2011 · Somehow or other I have managed to switch on the print margin lines in Excel 2010. I cannot seem to turn them off. I went to Page Layout->Page Setup->Print Area->Clear Print Area but …
My Excel files show some blue dot lines between rows
Oct 13, 2023 · In the page-break view, you can also click and drag the blue dotted lines and blue solid lines to visually set the page- and print-area boundries respectively (the gray areas are non-print).
printing - Excel borders are there but not shown on print preview and ...
Oct 22, 2015 · If you are using Microsoft Excel 2010+ (i.e. a version later than Office 2010), Navigate to the Layout tab. There are 4 sub-sections there namely: Page Setup, View, Print and Window. Under …
How Do I Enable Blue Lines in Excel's Page Break Preview
Also, are you sure there aren't blue lines around the edge of the print area? If the entire document is going to print on a single sheet, there will still be thick blue lines around the exterior border.
printing - Excel automatic reduced print size - all print size change ...
Mar 7, 2024 · Excel automatic reduced print size - all print size change to small, all positions are wrong Ask Question Asked 1 year, 9 months ago Modified 10 months ago
Remove outline/page border in Microsoft Excel - Super User
Oct 19, 2018 · 0 How do I hide the outside grid lines (at the edges of my data header) in Microsoft Excel? I need to have gridlines print/view ON for the rest of the data. I can hide some gridlines in my …
How to prevent cells from printing in Excel - Super User
Oct 20, 2010 · How can I prevent the contents of specific cells (or entire row or column) from printing in Excel, while keeping them visible on the screen when I'm editing the file? Ideally I should be able to …
How we can add background color in EXCEL for printing?
Sep 20, 2015 · 1 How we can add background color in EXCEL for printing? I create a small image with gray color and add it to PAGE LAYOUT-Background Image. When I see the main window of EXCEL …
Why does printing from Excel to pdf not maintain the size/border of …
Feb 14, 2022 · I'm trying to print from Excel to pdf - I've followed advice I've seen online and the print preview looks fine. The printed pdf on the other hand looks totally different, with a large white border.