Why is my Excel sheet blank when I try to print?

The answer is that Excel merely prints out the cells shown in print preview mode, and if you’re printing blank pages, you’ve selected too many cells, or kept them too wide and forced Excel to print the range specified.

How do I force Excel to print?

To force Excel to print your spreadsheet on one page do this:

1. Whilst you have the spreadsheet open click the (File) tab.
2. Now click the Print button (in the left hand menu)
3. Click on the No Scaling option (last one in the list)

Can print in word but not in Excel?

Printer prints in Word but not Printing in Excel Files. First of all, navigate to the control panel and then Printers and Faxes. Then under Printer Tasks on the left click on Add a Printer and then click Next on the welcome screen. Now select the local printer attached to this computer and then click on Next.

How do you unlock the print area in Excel?

Clear a print area

1. Click anywhere on the worksheet for which you want to clear the print area.
2. On the Page Layout tab, in the Page Setup group, click Clear Print Area.

How do I get rid of blank pages in Excel?

Right-click the tab that displays the title of an existing worksheet and choose “Delete Sheet.” If you prefer to use the controls in the Excel ribbon to delete extra worksheets, switch to the sheet you want to delete and navigate to the ribbon’s “Home” tab.

When I open Excel file its blank?

Microsoft Excel opens saved Excel file as blank workbook

• Open Microsoft Excel.
• In the Ribbon, click the File tab and click Options in the left navigation pane.
• Click Advanced, then locate the General section.
• Uncheck the box next to Ignore other applications that use Dynamic Data Exchange (DDE).
• Click OK.

How do I fix no printer in Excel?

To install a printer click the File tab, and then click Print. Click No Printers Installed, and then click Add Printer. Follow the instructions in the Add Printer dialog box’

How do you remove protection from an Excel cell?

On the Home tab, click the Format Cell Font popup launcher. You can also press Ctrl+Shift+F or Ctrl+1. In the Format Cells popup, in the Protection tab, uncheck the Locked box and then click OK.

How do you unlock only certain cells in Excel?

Excel 2016: How to Lock or Unlock Cells

1. Select the cells you wish to modify.
2. Choose the “Home” tab.
3. In the “Cells” area, select “Format” > “Format Cells“.
4. Select the “Protection” tab.
5. Uncheck the box for “Locked” to unlock the cells. Check the box to lock them. Select “OK“.