Sep 6, 2011 · 99 I have Excel 2007 so I'm giving the instructions to hide page break lines for Excel 2007, but it should be applicable to Excel 2010 as well: Click on the Office button in the top left …

Oct 13, 2023 · For some reason when I open a certain file in Excel, it shows some ugly dotted blue lines between rows. I kind of eliminate them using the menu [View] -> Workbook Views and changing …

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 …

Jul 3, 2021 · The line between D and E is dotted. Why? How can I change it to normal (eg. the line between E and F)? I am using Excel 2019.

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 …

Mar 2, 2017 · Use Excel's Custom Scaling option to make your printed page just large enough to fill and eliminate the unwanted white border as follows: On Excel's ribbon click the File tab then choose Print.

1 When in Page Break Preview there are no blue lines to adjust. Where do I find the blue lines or how can I get them back? I haven't tried anything because I don't even know where to begin. I've been …

Aug 30, 2018 · 0 Just click on print option on page set up go to sheet and click black and white. This will solve the cell lines from not printing.

0 I have an Excel work book that has 20 columns and 700 rows. In the very first row, I have Title and in the 3rd row I have Sub-Title. When I so a print preview, it shows correctly for page 1 but in page 2 …

Mar 23, 2016 · 11 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 …