Why can I not select print area in Excel?

On the worksheet, select the cells that you want to define as the print area. Tip: To set multiple print areas, hold down the Ctrl key and click the areas you want to print. Each print area prints on its own page. On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

How do I enable print selection?

Just select the desired text on the current page and press CTRL+P. This will bring up the Print dialog, where you can simply select the “Selection” option there. This will print out only the selected text. I just did this on my Firefox 30.0 and it worked perfectly.

How do I fix the print problem in Excel?

Open Excel. Go to File > Print > Page Setup. Choose the Sheet tab and find the Print section. Place a check in the Gridlines box….Open the workbook using Repair:

  1. Open Excel.
  2. Go to File > Open and highlight the workbook you want to Repair.
  3. Use the dropdown on the Open button and select Open and Repair…

Why is only part of my Excel spreadsheet printing?

One common issue that can arise is when you are trying to print your spreadsheet, but only part of the sheet is printing. This occurs because the last editor set a print area, which changes the data that Excel thinks you want to print.

Why is print selection greyed out?

The problem may be that the original message is generated by a non-email program, the one that records the transactions. You could try File/Save As (Ctrl+S) and select Save as type: HTML or Text, then open the saved file in a browser or text editor, then print.

How do I print a selection in Windows 10?

Printing only a selection in Chrome

  1. Highlight text you wish to print.
  2. Go to “File” and “Print”
  3. Scroll down the print dialog screen and check “Print Selection”

Why does only part of my Excel spreadsheet print?

The reason that only part of your spreadsheet is printing in Excel 2013 is due to something called a Print Area. This is a setting for a spreadsheet where you can choose to only print part of the data that is included in the sheet.