Copying formatting of entire sheet

  • Thread starter Thread starter Diamontina Cocktail
  • Start date Start date
D

Diamontina Cocktail

I made an Excel 2007 workbook which includes my monthly business income,
parts bought, a logbook for car mileage dividing into personal and work and
finally a financial end of year total constantly updated by the income or
parts bought over the financial year.

What I would like to know, please, is how to copy the entire logbook (12
sheets, 1 per month then 1 for end of financial year totals and 1 for car
miles) FORMATTING so that I can have it all ready for the next financial
year. I live in Australia and our financial year ends Jun 30 and starts the
new one July 1. What I would like to end up with is all those months and
other sheets ready but blank so far and all the formatting in place ready to
go rather than try to have to remember how I made it all up in the first
place (most is easy, some I cant remember but could find eventually).

Any help very much appreciated. Thanks.
 
Hi,

Do a 'save as' and rename your workbook Blank Master Copy
or whatever.
Then start at Sheet1, Tap the F5 key to bring up
the Go To Dialog box, click special check constants, OK
and then hit delete.
Repeat the process for all the other sheets.
Once that's done click Save.
Then close the workbook.

Go into Windows Explorer, find your Blank Master right
click on it and go to Properties and check the Read Only
box and OK.

Double click on the file to reopen it and do a 'Save as'
and call it 2007-2008.

HTH
Martin
 
Why don't you just make a copy of the workbook and clear out the data that
was entered (F5>special>constants and then I presume you would check
numbers, then just clear by hitting delete). You can group all sheets,
by selecting the first, holding down shift and select the last, now all
changes made in one sheet will occur in all the other sheets as well. Do all
necessary editing and then right click a sheet and select ungroup. When you
are certain everything is fine save the workbook as a template *.xlt. Then
next time you want to use it do file>new and select templates and your
workbook, that way the next time it opens a copy of the workbook and adds 1
to it, just save it as *.xls with a new name and you'll be alright mate and
the original workbook will always be there unaltered
 
Thanks for that.

It ALMOST works but doesn't QUITE work. It actually deletes all column
headings, unfortunately. However, that can be retyped I guess. I just wanted
to get rid of data and make the rest of the sheet work as is without
stuffing about. I guess there is no easy way of doing that.
 
Hi,

There is a way to do that which Peo mentioned and I forgot to mention.
When you check Constants, just below that you can uncheck Text,
Logicals and Errors, leave numbers checked and then OK out.

Does that work better?
Martin
 
Thanks, Martin but no, not really. My monthly work sheet starts with the
date, then the customer/company name and contact in the next cell, address
in the next, phone number(s) in the next, email address in the next, amount
charged next, parts bought in next then the next cell is one for a reason
why I was called in the first place and the next is what I found and did.

However, I just had a thought as I was typing. There IS a way around it. I
did a selection of the entire worksheet from B1 to the last cell in the
sheet then did as you said after that and it works. By selecting from B1
onwards, it did that search for constants in the selected area only, thus I
preserve my headings which never change.

Thanks for all the help. Also had another thought. All I have to do, now, is
apply all that to one work sheet only and copy that same sheet inside the
same workbook (just have to figure out how to copy it in that fashion) 11
times and I am done. My formatting in some almost year old sheets isn't
fabulous due to it being a direct copy of the sheet from Word into Excel. It
works when you do that, clumsily.

Gotta say I do love Office 2007. It seems to be much better in a lot of ways
but strangely, Vista voice recognition and the new way Office is with the
strip don't seem to get on that well. Such is life.
 
Back
Top