Any Answers (back to index)

Secretary for Board Support

I have a Workbook with sixteen worksheets.  When making a change on any one of the worksheets the change happens on all the other worksheets too.  I am unable to copy and paste the individual worksheets to a new file .  Please help! 

Ungroup sheets?

Try right clicking on a tab with the sheet title and select 'Ungroup'

I'm making the assumption they've been grouped to start with.

Thank you the Ungroup option worked.

Create your free account

  • Access all articles in full
  • View multimedia
  • Receive email bulletins
  • Private messaging
Register now

Login

Forgotten your password?

Any Answers theme of the month

Latest questions on
Preparing for 2010/11
- payroll & tax planning advice:

Overseas director and PAYE / NIC

Directors and NIC

P46(Car) - what are the rules?

No PAYE scheme but P11d may be needed

IT Zone today

Apple iPhoneGadget blog
Latest news from CES

Snow strategy:
Work remotely

SA songs
Listen to our Spotify list!
 

Download library

Free downloads
Check out our library of podcasts and tutorials.