Im trying to use Numbers to do my book-keeping for my accountant. I have created a spreadsheet with neat bold headings and I have formatted each column so for 'Dates' it recognises I am going to enter a date, and have neat drop down menus for the column 'Purchases' etc etc. After doing my first months accounts and thinking I have found the answer to simple book-keeping I have run into a problem...
When I click 'duplicate' on the sheet tab at the top, it duplicates the entire spreadsheet including all of my content. Obviously this duplication will be my next months work of accounts so I have gone ahead and highlighted & deleted all of the content ready to enter the next months data. UNFORTUNATELY this means that all of the perfectly formatted columns are no longer formatted, thus rendering my whole operation useless....
If anybody can understand my problem and provide a solution I'll be forever grateful!
Thanks for looking.
Why not duplicate the sheet and delete the content in the second (new) sheet, rather than deleting your original sheet?
It seems a no-brained, though I might not truly understand your dilemma.