Sep 6, 2011 · 98 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 …

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 …

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 …

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 …

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.

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. …

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 …

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 i...

Oct 27, 2021 · I know that we could turn on or off gridlines for a given sheet here: Does anyone know how to set this option by default for every newly created worksheet?

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 …