[Excel utilization] Super easy! Automatic date change! Electronic seal ✨

🎁 in the 4-choice mini-game "Shotoka Dojo" gift in Instagram!

Other posts from here 💁‍♀️

@ yui _ exel _ work

Enter the date of the seal manually every time, 🔖

─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─

◆ How to make an electronic seal that changes the date automatically ◆

① Input three vertically in an empty cell

Above: Department name (e.g. General Affairs Department)

Middle: = TODAY () (function that displays today's date)

Below: Name

② All three characters are red, bold, and center ☺️

③ Ctrl + 1 → "User-defined" date cell

yy.mm .dd

(It will be displayed like 26.10.15!)

④ Draw a red border under the department and date

⑤ Uncheck "Display" - > "Scale Line"

(So that thin lines are not reflected in the figure)

⑥ Select three cells and press Ctrl + C → Seal

"Home" → "Paste" ▼ → "Linked Diagram"

⑦ Insert → Figure → Ellipse,

Hold Shift and drag to make a perfect circle

→ No fill ・ Make the line red and overlap

⑧ While holding down Shift, select both the figure and the circle,

Right click → "Group"

→ The size and position can be changed freely together!

The TODAY function changes to the date of the day every time you open a file!

Please check the company rules before using it to see if it can be used for internal documents 😜

─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─

🎁 "Yui no Shotoka Dojo" present on Instagram 🥋

While playing with 4-choice quiz,

It is a game that Shotka can remember ✨

If you want it, comment "Dojo" on Instagram reel!

Dm to you 📩

When you can't find the DM

(See also "Message request")

─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─

Please "Like ❤️" and "Save 🔖" if you like!

Excel technique to make work a little easier 📊

Follow here → @ yui _ exel _ work

# excel # Excel # excel _ time # excel _ beginner # shortcut key