I want to have the same margins, layout and headers/ footers. I want to do it in one and then automatically have the same for the other 10+ of my spreadsheet.
2006-12-21 03:03:47 · 4 answers · asked by Dimi 1 in Computers & Internet ➔ Programming & Design
Click on the tab of your first worksheet. Hold your shift key down then click on the last tab. It will highlight all the tabs in between. Now you can set your margins, layout and headers/footers. Be careful to right click and ungroup your sheets or click onto a single sheet before you start typing into any of your cells though because when you have all those sheets grouped together what you do in one gets copied to all the others.
2006-12-21 03:08:04 · answer #1 · answered by PRS 6 · 0⤊ 0⤋
Tools/Protection/Protect Workbook, or protect each sheet individually.
2016-05-23 05:13:41 · answer #2 · answered by Anonymous · 0⤊ 0⤋
setup a template on how you want it done then copy that template to each workstation.
2006-12-21 03:12:12 · answer #3 · answered by Carling 7 · 0⤊ 1⤋
you can use copy and paste.very easy.i think.
2006-12-21 03:08:19 · answer #4 · answered by tiger 3 · 0⤊ 1⤋