Forem

Long Nguyễn Xuân
Long Nguyễn Xuân

Posted on

change default excel template

  1. tạo 1 file excel mới tên "book" hoặc tên "Gi_cung_duoc", mỗi tội sau này mỗi lần mở excel nó sẽ tạo file mới tên "Gi_cung_duoc1"
  2. config font, màu, table, các thứ cần thiết.
  3. save ở dạng template (xltx)
  4. nó sẽ tự động vào trong ...\Documents\Custom Office Templates
  5. mở Excel/File/Options/General, uncheck, cái "Show the Start screen when this application starts"
  6. qua bên Excel/File/Options/Advanced, kéo xuống chỗ General, thêm cái đường dẫn tới folder Custom Office Templates kia vào text box "At startup, open all files in"
  7. OK, tắt Excel mở lại để thấy cái file mới nó sẽ nhận các font / màu / alignment theo cái mình mới set

credit: https://exceljet.net/articles/how-to-set-a-default-template-in-excel#:~:text=Excel%20has%20the%20ability%20to%20use%20a%20custom

Top comments (0)

Image of Docusign

🛠️ Bring your solution into Docusign. Reach over 1.6M customers.

Docusign is now extensible. Overcome challenges with disconnected products and inaccessible data by bringing your solutions into Docusign and publishing to 1.6M customers in the App Center.

Learn more

👋 Kindness is contagious

Dive into an ocean of knowledge with this thought-provoking post, revered deeply within the supportive DEV Community. Developers of all levels are welcome to join and enhance our collective intelligence.

Saying a simple "thank you" can brighten someone's day. Share your gratitude in the comments below!

On DEV, sharing ideas eases our path and fortifies our community connections. Found this helpful? Sending a quick thanks to the author can be profoundly valued.

Okay