Thread: Printing a spread sheet and skipping rows.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Printing a spread sheet and skipping rows.
F5SpecialFormulas. Uncheck all but "Errors" and hit OK.

FormatRowsHide.

Now print the sheet.

When done, unhide the rows.


Gord Dibben MS Excel MVP

On Wed, 26 Jul 2006 13:54:02 -0700, WAVIS
wrote:

I want to print a spread sheet but skip all rows that have #n/a in any cell
in that row.

Reply With QuoteReply With Quote