Ask Your Question
0

when using print preview in spreadsheet why do I get "NO DATA" in window?

asked 2016-04-03 21:34:32 +0100

paolo1938 gravatar image

updated 2016-04-04 15:04:03 +0100

pierre-yves samyn gravatar image

Attempted to use a print preview and was unable to see the image of the spreadsheet. This happens sometimes, not always. The only way I can print the page is to select the cells, and print "selected cells".

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-04-04 15:03:18 +0100

pierre-yves samyn gravatar image

Hi

A print area has probably been set on an empty range in the sheet.

To check: FormatPrint RangesEdit

Once a print range is defined, it is that which is printed (preview) by default.

The solution would therefore be to delete the print area (FormatPrint RangesClear), or to adapt to it to cells to print.

Regards

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-04-03 21:34:32 +0100

Seen: 4,124 times

Last updated: Apr 04 '16