×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel custom views

Excel custom views

Excel custom views

(OP)
Can anyone help?
How can i copy a worksheet that contains custom views (Print areas), so that the new worksheet has identical view settings referancing in the new sheet. (when i do this at the moment after copying the worksheet the veiws in the new worksheet default back to the original worksheet)

Thanks in advance for any help.

RE: Excel custom views

paste special / Formats

RE: Excel custom views

(OP)
Thanks for the tip

I am not copying,as in copy and pasting to a new sheet, but making a copy of the sheets on the bottom copy/move sht tab, i am not aware of any format controls for this, or are there some defualt format settings for use when copying.

RE: Excel custom views

No and No.  There are no real formats for tab/sheet copy other than it should (I repeat, should) copy formats and all.

If it isn't, then RMB on the tab and insert new worksheet, then copy the existing worksheet to the new on (paste / paste specical).  You will need to use the paste special function a couple of times to make sure that the columns and the format are correct.

Short of writing some code to do it (unless you do this alot), this is about the only way I know of.

RE: Excel custom views

(OP)
ByDesign Thanks

Really thought this had cracked it, but unfortunatly it still doesn't work for custom views, they remain greyed out throughout the process.

Thanks again for your help

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources