making excel respond like quattro

• • Reply

  17 years ago

  by orthnerk

  orthnerk

  , United States

  Joined 17 years ago

  Hello everyone,  I'm hoping someone can help me.  I am trying to make excel have some functionality that quattro pro has.
  

  
  I would like to use a custom views to print multiple sheets.  I
  selected a range on a sheet then selected the sheets for this range
  and named it.  Unfortunately, you can't use a 3 dimensional range for a print range.
  

  
  Also, when you have multiple sheets selected you can't set up custom
  views either.  I would like to print the selected sheets using the print
  settings of the custom view.
  

  
  Any ideas?  I'm trying to make this like quattro when you can select
  the range and with that named range comes the print settings.
  

  
  Thanking you in advance.
  

  
  

  Report abuse