We know the Microsoft Excel is an example of spreadsheet program and we can store different types of data in the tabular format by using the MS Excel (A spreadsheet program) but by default MS Excel does not print the gridlines in the printouts and without gridlines data looks like simple text printed information.

So if you want to learn that how to print gridlines in the MS Excel, then this tutorial is for you.

Steps to Print Gridlines in MS Excel

  • Select the worksheets which gridlines, you want to take (print) in the printouts.

Note: We can select single worksheet by simply single left click on the worksheet and to select the multiple worksheets, we have to hold down the “Ctrl” key and left click on the number of worksheet that we want to select.

  • Click on the “Page Layout” Menu.
  • Check the box “Print” of gridlines option under “Sheet options”
  • After it, we can check the gridlines by “Print Preview” window.
  • Note: Use the “Ctrl + F2” shortcut key to show print preview window.
  • After seen the gridlines in the print preview window, we can give the print command.

Steps to Print Gridlines:

  • Open the workbook, in which you want to print Gridlines.
  • Then Go to
    Page Layout > Sheet Options > Gridlines > Select Print Option.
  • Go to print, or use Ctrl+P, to execute the command.  It will appear something like this.


  • If you want to print gridlines on the whole page, even on the portion kept blanked, then you will have to use cell border option.
  • It is recommended to use Print Preview before printing gridlines.
  • Sometimes, even after following the above step, gridlines will not be printed. For this you have to follow the following steps:
  • Go to Page Layout > Sheet Options
  • It will open a dialog box like this:
  • Just Check the box of Draft Quality and Gridlines will print.

How do I print the gridlines in Excel 2013?

How to Print Gridlines in Excel 2013
  1. Open your spreadsheet.
  2. Click Page Layout.
  3. Check Print under Gridlines.

How do I print evenly in Excel?

Follow these steps:
  1. Click the Page Layout tab on the ribbon.
  2. In the Scale to Fit group, in the Width box, select 1 page, and in the Height box, select Automatic.
  3. To print your worksheet, press CTRL+P to open the Print dialog box, and then click OK.

How do I change the print lines in Excel?

How to change a print area in Excel? To define the print area, you need to set and fix the page layout boundaries that will separate all areas. To do this, click on the blue dotted line in the Page Break Preview view, and move it to the necessary position, holding down the left mouse button.

How do I make lines in Excel?

To show gridlines: On the Layout tab, under View, select the Gridlines check box. Note: Gridlines cannot be customized. To change the width, color, or other attributes of the lines around cells, use border formatting. To hide gridlines: On the Layout tab, under View, clear the Gridlines check box.

What are the dotted lines in Excel?

What is a dotted line?

In Page Break Preview, dashed lines are page breaks Excel automatically added. Solid lines are page breaks that were added manually.

How do I get rid of the lines in Excel?

1 : a line that is made up of a series of dots. 2 : a line on a document that marks where one should sign Sign your name on the dotted line.

How do I hide page break lines in Excel?

How to Remove Excel Gridlines. The easiest way to remove gridlines in Excel is to use the Page Layout tab. Click the Page Layout tab to expand the page layout commands and then go to the Gridlines section. Below Gridlines, uncheck the view box.

Why page break is not working in Excel?

Hide all page breaks in active worksheet in Excel
  1. Click File (or Office Button) > Options.
  2. In the opening Excel Options dialog box, please click the Advanced category at left side, and then uncheck the Show page breaks option in the Display options for this worksheet section. See screenshot:
  3. Click the OK button.

How do I remove page breaks?

This problem may occur when the Allow cell drag and drop check box on the Edit tab of the Options dialog box is cleared. To locate the Enable fill handle and cell drag-and-drop check box, click the Microsoft Office Button, click Excel Options, and then click the Advanced tab.

How do I remove page breaks in Word 2010?

On the Home tab, in the Paragraph group, click Show/Hide to show all formatting marks including page breaks. Double-click the page break to select it, then press Delete. Click Show/Hide again to hide the remaining formatting marks in the document.

Why can’t I delete a page break in Word?

Summary – How to remove page breaks in Word

Click the Home tab at the top of the window. Click the Show/Hide button in the Paragraph section of the ribbon. Select the Page Break formatting mark. Press the Delete (or Backspace) key on your keyboard.

Why is Insert Page Break not working?

Sometimes, Word won’t let you delete a page break. The fix is usually simple — although the cause might surprise you. If you need to delete a page break, you must turn off Track Changes, delete the break (make sure you’re in Normal view), and enable Track Changes when you’re done.

How do I insert a page break between columns in Excel?

If manual page breaks that you add don’t work, you may have the Fit To scaling option selected (Page Layout tab -> Page Setup group -> click Dialog Box Launcher Button image -> Page). Change the scaling to Adjust to instead.

How do I remove page number from page break?

Insert a horizontal or vertical manual page break

Select the column that is to the right of the column where you want the page to break. On the Layout tab, under Page Setup, click Breaks, and then click Insert Page Break.

Why do we insert page break in Excel?

If you just want to hide the page number watermark, you only need to switch Page Break Preview to Normal View. Click View > Normal, and then the page number watermark is hidden.

What is page layout in Excel?

Answer: Page breaks are dividers that break a worksheet into separate pages for printing. Microsoft Excel inserts automatic page breaks based on the paper size, margin settings, scale options, and the positions of any manual page breaks that you insert.