Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-17-2020, 05:12 PM
Peterson Peterson is offline Sheet.xltx: issues with header/footer formatting Windows 10 Sheet.xltx: issues with header/footer formatting Office 2016
Competent Performer
Sheet.xltx: issues with header/footer formatting
 
Join Date: Jan 2017
Posts: 141
Peterson is on a distinguished road
Default Sheet.xltx: issues with header/footer formatting

I'm trying to incorporate a sheet.xltx template into my XLSTART folder. When I have a workbook open that was created with the default MS formatting (Calibri), when I add a new sheet based on sheet.xltx, in the headers and footers only, the formatting from the existing sheet affects the new sheet's formatting, but inconsistently, as follows:
  • Left header: correct, unaffected by existing sheet
  • Middle header: inherits font from existing sheet, no size change
  • Right header: inherits from existing sheet, no size change
  • Left footer: inherits from existing sheet, font size changed
  • Middle footer: inherits font from existing sheet, NO font size change
  • Right footer: inherits font from existing sheet
Is there a way to protect the formatting I want to use in sheet.xltx when I add a new sheet that uses different formatting?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding text to the header and footer without removing all other content in the header and footer digitalelise Word VBA 2 10-23-2019 02:58 AM
Sheet.xltx: issues with header/footer formatting Include header and footer formatting when using IF conditional includes of separate documents anakaine Mail Merge 3 11-06-2015 09:51 PM
Sheet.xltx: issues with header/footer formatting Can't remove header & footer formatting ... frangipan Word 2 07-11-2014 12:27 PM
Sheet.xltx: issues with header/footer formatting Issues regarding Header and Footer dissapearing word perfect Word 3 03-28-2013 01:10 PM
Issues with header and footer images TheWordApprentice Word 0 08-14-2012 07:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft