I there a way to not print a cell(s)?
in [Functions]
|
From: nick on 5 Mar 2010 18:19 I would also like to know, is there no way of just not printing a few cells, I think that I have tried everything, but setting print areas do not work. Is there really no way so information is accessible on the computer screen but not when printed? "Khamul" wrote: > >>Set a print area that doesn't include those cells.<< > > But when you do that it counts each area as its own page how do you get it > to prin on one page only????
From: Don Guillett on 5 Mar 2010 18:32 hide the rows/columns desired>print>unhide -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "nick" <nick(a)discussions.microsoft.com> wrote in message news:F136C74A-33D5-4292-A99C-74590D5484DD(a)microsoft.com... >I would also like to know, is there no way of just not printing a few >cells, > I think that I have tried everything, but setting print areas do not work. > Is there really no way so information is accessible on the computer screen > but not when printed? > > "Khamul" wrote: > >> >>Set a print area that doesn't include those cells.<< >> >> But when you do that it counts each area as its own page how do you get >> it >> to prin on one page only????
From: Gord Dibben on 5 Mar 2010 18:43 Very difficult to print non-contiguous areas of a sheet. You can hide entire rows and columns but to hide individual cells you must change the font color to same as background color. Or copy/paste non-contiguous areas to a single contiguous range. Gord Dibben MS Excel MVP On Fri, 5 Mar 2010 15:19:34 -0800, nick <nick(a)discussions.microsoft.com> wrote: >I would also like to know, is there no way of just not printing a few cells, >I think that I have tried everything, but setting print areas do not work. >Is there really no way so information is accessible on the computer screen >but not when printed? > >"Khamul" wrote: > >> >>Set a print area that doesn't include those cells.<< >> >> But when you do that it counts each area as its own page how do you get it >> to prin on one page only????
|
Pages: 1 Prev: How to format the phone number Next: Pulling out invoices that do not match |