Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-30-2024, 10:06 AM
SnakeDoctor's Avatar
SnakeDoctor SnakeDoctor is offline Auto-Titles for New Files from Excel Templates / How to set default 'Color Palette' theme Windows 11 Auto-Titles for New Files from Excel Templates / How to set default 'Color Palette' theme Office 2021
Novice
Auto-Titles for New Files from Excel Templates / How to set default 'Color Palette' theme
 
Join Date: Jul 2023
Location: Ft. Worth, TX
Posts: 7
SnakeDoctor is on a distinguished road
Default Auto-Titles for New Files from Excel Templates / How to set default 'Color Palette' theme

I need an Excel 365 god for these...



1.) New Files Created by Opening an Excel Template

When a user opens a MS Word Template file (.dotx), a file named 'Document1.docx' will open.

However, when opening a MS Excel Template file (.xltx), the file that opens is named the same as the template, with an added '1' and as (.xlsx).

Is there a way to make a MS Excel Template open with a different file name - without re-naming the template?

2.) Changing the Default Color Palette Theme

So, MS recently pushed an update we are calling 'Aptos.' It added the 'Aptos' font, but also forced a new default color palette theme named 'Office' to replace the previous 'Office 2017-2023(?)' default template.

How do I change the Default Color Palette in Excel?

Thank you in advance!
Attached Images
File Type: png ExcelTemplate.png (28.4 KB, 10 views)
File Type: png ExcelDefaultColorPalette.png (37.7 KB, 10 views)
Reply With Quote
  #2  
Old 03-15-2024, 10:13 AM
TessaMurillo TessaMurillo is offline Auto-Titles for New Files from Excel Templates / How to set default 'Color Palette' theme Windows Vista Auto-Titles for New Files from Excel Templates / How to set default 'Color Palette' theme Office 2010
Advanced Beginner
 
Join Date: Mar 2024
Posts: 33
TessaMurillo has a little shameless behaviour in the past
Default

Hi,

To merge cells in Excel without losing data, you can use a simple workaround. Instead of merging cells directly, you can use the "Center Across Selection" option to achieve a similar visual effect.

Here's how to do it:

Select the range of cells that you want to merge.
Right-click on the selected cells and choose "Format Cells" from the context menu.
In the Format Cells dialog box, go to the Alignment tab.
In the Horizontal dropdown menu, select "Center Across Selection."
Click OK to apply the changes.
This will center the contents of the selected cells across them without actually merging them. Your data will remain intact, and you'll achieve the desired visual layout.
Reply With Quote
Reply

Tags
default settings, templates



Similar Threads
Thread Thread Starter Forum Replies Last Post
Master Color Palette BDS PowerPoint 0 08-31-2017 10:15 AM
Auto-Titles for New Files from Excel Templates / How to set default 'Color Palette' theme Using a color palette that is not a theme ChrisBrewster Visio 2 03-31-2016 11:36 AM
Auto-Titles for New Files from Excel Templates / How to set default 'Color Palette' theme Select color palette using vba Catty Word VBA 3 10-08-2015 09:32 PM
Macro to select a custom color palette Catty Word VBA 0 05-06-2015 05:12 AM
Office (PowerPoint & Excel) 2003 color palette available in 2010 version? anofficedummy PowerPoint 1 01-27-2012 11:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:11 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