When printing Excel work sheets, do you get blank pages? — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

When printing Excel work sheets, do you get blank pages?

Get PDF file

by on
in Excel Training,Office Technology

When printing Excel work sheets, do you get blank pages? There may be a few reasons for this. One frequently occurring reason is formulas, which result in blank cell values.

Press the Ctrl+` (unshifted ~, look left of the 1 key on the QWERTY keyboard) or click the Show formulas button on the Formu­­las tab. This reveals all formulas and allows you to see, for example, an IF statement, which checks for data in A1 before performing a calculation, =IF(A1=””,””,A1*B1). That would result in a blank value and appear as a blank row, unless you activated Show Formulas.

Leave a Comment

 

Previous post:

Next post: