excel printing

  • Thread starter Thread starter Jeff Bango
  • Start date Start date
J

Jeff Bango

In Lotus 1-2-3 if you put a pipe sign in the leftmost
cell of a column and include that column in your
printrange then that row will NOT print.

This has been very handy but I don't seem to be able to
find a similar function in excel.

Does anyone know if there is one?
 
Hi Jeff

No you don't have this in Excel

You can format the cell like this but then you never see the value
Format>Cells>Custom. Enter ;;;(3 semi-colons).

I have try to put some example code on a page about this
Maybe you can use it
http://www.rondebruin.nl/print.htm
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Set non-continuous PrintArea via Function / Name 0
Excel VBA - Problem with Closing Print Preview 0
Does Excel have a @grandtotal function like Lotus 123 2
Lotus Organizer 6.1 0
Hide columns based on row values 2
Need an Excell function that can lookup vertical AND horizontal 3
EXCEL macro that will vary when copied 1

Back
Top