Templates with styles that flow to all new sheets

T

Teapotlid

New Member
Joined
Jan 30, 2015
Messages
14
I want to set up a style template (i.e. font style, font size, 'official' color pallet, company logo & security info in the footer etc) such that if I hit the 'New Sheet' button the new sheet also has these properties.
At the moment you have to copy one of the existing sheets to get the official style to appear on the new sheet. Doable but an inelegant solution!
Is there a way of embedding the style elements I'm after so that they will also appear when I use the 'new sheet' button?
I'm in Office 365/Excel 2013.
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
You must log in or register to reply here.

Similar threads

C
  • Question
Use Row Data to Create New Sheet from Template and Reference Data
Replies
0
Views
407
ChrisMas92
C
K
  • Question
Trying to Auto Clear a new template invoice, when I already have an auto clearing invoice on another sheet
Replies
2
Views
381
Kym_beginner_in_VBA
K
C
  • Question
Excel Button and new template
Replies
5
Views
494
Candyman8019
C
S
  • Solved
VBA copy template sheet to new monthly workbook with daily sheets tabname and header A2:J2 named as "dd mm yyyy" + autosave filename predefined
Replies
4
Views
604
mumps
mumps
A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
479
AndyEd
A

Forum statistics

Threads
1,215,760
Messages
6,126,733
Members
449,333
Latest member
Adiadidas

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top