Considerations for Excel Templates
Keep the following best practices in mind when creating Excel templates.
Custom Cell Styles and Table Styles will be available to any workbooks based on the template. So, be sure that custom styles are Theme-ready if you want to allow Theme-switching. Also, consider details to simplify working with styles, such as setting your preferred default table style.
Watch for potential user complications in workbooks saved as templates. For example, avoid hidden rows, columns, or sheets in your template unless they’re intentional, to avoid leaving unwanted content in the workbooks created from the template. Also, remove any print area settings or frozen panes, unless they’re intuitive and would be applicable to any use ...
Get Advanced Microsoft® Office Documents 2007 Edition Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
