Automatically translated.View original post

Make a table head with a diagonal.

2025/8/6 Edited to

... Read moreหลายคนถามกันบ่อยว่า “แบ่งตารางแนวเฉียงใน Excel” ทำยังไงให้หัวตารางดูเป็นทางการ แบบช่องเดียวแต่มี 2 หัวข้อ (เช่น DATE กับ PRODUCT) เราลองทำเองบ่อย ๆ เวลาเตรียมไฟล์สรุปยอดขาย/สต๊อกสินค้า แล้วได้วิธีที่เร็วและเนียนมากตามนี้ค่ะ 1) สร้างเส้นทแยงในเซลหัวตาราง - เลือกเซลที่ต้องการทำหัวตาราง (เช่น A1) - ไปที่ Format Cells (บน Mac กด Cmd+1) > แท็บ Border - เลือกเส้น “Diagonal” (เส้นเฉียงขึ้น/ลงตามแบบที่ต้องการ) และเลือก Line Style/Line Color ให้เข้ากับตาราง - กด OK จะได้เส้นทแยงแบ่งช่องทันที 2) ทำให้เป็น “DATE/PRODUCT อยู่ในเซลเดียว” แบบอ่านง่าย Excel ไม่มีปุ่มให้วางข้อความคนละมุมอัตโนมัติในเซลเดียวแบบสมบูรณ์ 100% แต่ทำได้เนียนด้วยการขึ้นบรรทัด + เว้นวรรค/จัดตำแหน่ง - คลิกที่เซลเดิม แล้วพิมพ์คำแรก เช่น DATE - กดขึ้นบรรทัดใหม่: Windows ใช้ Alt+Enter / Mac หลายเครื่องใช้ Control+Option+Return (หรือ Option+Command+Return แล้วแต่คีย์บอร์ด) - พิมพ์คำที่สอง เช่น PRODUCT 3) จัดข้อความให้ไปคนละมุม (ทริคที่ทำให้ดูโปร) - เปิด Wrap Text เพื่อให้ข้อความอยู่ในเซลได้สวย: Home > Wrap Text - ตั้ง Alignment ของเซลเป็น Top Left ก่อน (ให้ DATE อยู่มุมบนซ้าย) - จากนั้นขยับคำว่า PRODUCT ให้ไปล่างขวาโดยใช้การเว้นวรรค + ขึ้นบรรทัดเพิ่ม 1-2 บรรทัด (วิธีบ้าน ๆ แต่เวิร์กมากเวลาตารางไม่ได้เปลี่ยนขนาดบ่อย) - ถ้าต้องการเนียนและล็อกตำแหน่งกว่านี้: Insert > Text Box แล้ววางกล่องข้อความ 2 อัน (DATE ด้านบนซ้าย, PRODUCT ด้านล่างขวา) จากนั้นตั้งให้ No Fill/No Outline วิธีนี้จะไม่เพี้ยนง่ายเวลาเปลี่ยนความกว้างคอลัมน์ 4) ปรับขอบตารางให้เข้ากัน พอมีเส้นทแยงแล้ว แนะนำให้จัด Border ของหัวตารางให้ชัด: - เลือกช่วงหัวตาราง > Borders > Outside Borders หรือ Thick Box Border - ถ้าตารางแน่น ๆ ใช้ More Borders… แล้วเลือกความหนาเส้นเฉพาะด้านบน/ล่างจะดูอ่านง่ายกว่า 5) ข้อควรระวังเวลาใช้งานจริง - ถ้ามีการปรับความกว้างคอลัมน์บ่อย ๆ วิธี Text Box จะคงรูปสวยกว่าแบบเว้นวรรค - เวลา Print/Export เป็น PDF ควรลองพรีวิวก่อน เพราะเส้นทแยงกับการจัดตำแหน่งข้อความบางฟอนต์อาจเหลื่อมเล็กน้อย สรุป: ถ้าต้องการ “แบ่งตารางแนวเฉียง excel” ให้เร็วที่สุด ให้ใช้ Format Cells > Border > Diagonal แล้วค่อยจัด DATE/PRODUCT ด้วย Wrap Text + ขึ้นบรรทัด หรือใช้ Text Box ถ้าอยากให้เป๊ะและไม่เพี้ยนเวลาแก้ตารางค่ะ

Related posts

A woman stands in profile, showcasing her glutes and quads. Text overlays indicate "Glute & Quad Workouts," with arrows pointing to "Glute Isolation" on her glute and "Quad Isolation" on her thigh, illustrating areas of focus.
Text on a black background details glute anatomy, explaining the Gluteus Maximus, Medius, and Minimus muscles, and a key tip for glute growth through hip extension, abduction, and external rotation.
Text on a black background outlines quad anatomy, describing the Rectus Femoris, Vastus Lateralis, Vastus Medialis, and Vastus Intermedius muscles, with a key tip for developing quads through knee extension.
How to Grow a Dump Truck & Thunder Thighs 🍑🚛🌩️🔥
Anatomy, Best Exercises, and Full Machine/Weight-Based Workouts When you're training for growth or lower-body strength, it pays to focus on your glutes and quads individually and together. That means knowing your anatomy, selecting the right exercises, and mastering your form! My post wil
Chalie_Baker

Chalie_Baker

8587 likes

if you want to make your nose look slimmer…
this quick makeup hack is a game changer for giving the illusion of a smaller nose 👀 - place your contour in a diagonal line from the bridge to the edge of your nose above your nostril - apply brightening concealer above contour and wrap around underneath nostril - blend & set/bake with a
taylor nicole🎀

taylor nicole🎀

97 likes

A first-person view of legs on an exercise mat, with text overlay indicating 'Pilates From Home', '1 Hour', '60 min', 'Calories 450', and '3 levels', suggesting a home Pilates workout with calorie burn and difficulty options.
An infographic titled 'PILATES WORKOUT' displaying various Pilates exercises categorized by 'TOTAL BODY', 'UPPER BODY', 'CORE', and 'LOWER BODY', with illustrations for each movement.
An infographic titled 'YOGA ROUTINE for GLUTES + LEGS', illustrating 15 yoga poses like Fire Hydrant Kick, High Lunge, Warrior II, and Bridge, with instructions for holding and repeating poses.
✨Lose Weight and Tone your Body with Pilates✨
Beginner, Intermediate and Advanced 60 minute workouts below💕 ✨Beginner✨ 💕Warm-Up (10 minutes): 🌸Deep Breathing: Begin with deep breathing exercises, inhaling through your nose and exhaling through your mouth to relax and prepare your body. 🌸Cat-Cow Stretch: Move into gentle cat-cow str
Chalie_Baker

Chalie_Baker

4142 likes

4 🔥🔥 Moves to Fix Hip Dips 💨
Lose Hips Dips Quick with these 4 🔥moves ❤️Best Results✨Do each move 3 sets, 45 secs-1min💪🏾 ✅Elbow Fire Hydrant + Kick ✅Squat Pulses ✅Diagonal Squats ✅Side Plank Leg Lifts #hipdips #buttlifting #workoutathome #lowerbody #bikini #bikinibody #beginnerfriendly #gains
Kamille | Fitsique

Kamille | Fitsique

671 likes

Yoga for a Stiff Neck & Tight Shoulders ❤️
Back in college (around 2014), I started getting cluster headaches so bad I had to see a chiropractor and physical therapist. I was surprised to learn the cause. Horrible posture and constant hunching over my laptop. That’s when I learned how much tension I hold in my neck and shoulders. Even no
Ashlee Sunshine

Ashlee Sunshine

70 likes

HAPPY 41ST BIRTHDAY TO THE HEAD OF THE TABLE
#romanreigns @Roman Reigns
✨💜Řøşę💜✨

✨💜Řøşę💜✨

241 likes

A giant black and white panda statue in Minecraft, surrounded by bamboo and smaller pandas, with the text 'MINECRAFT GIANT PANDA'.
A Minecraft screenshot showing a 7x7 square base made of black concrete blocks on green grass, labeled 'BUILD BASE'.
A Minecraft screenshot showing the initial black concrete body structure with a stair-like pattern on the sides, labeled 'BUILD THE BODY'.
Build A Panda Statue/House in Minecraft
Here’s my attempt at a panda house/statue. 🐼 Start with a 7x7 box of black concrete on the ground. 🐼 Then add 2 rows of black concrete to the front of the starting square, on both sides also add a column of 2 black concrete and then a column of one black concrete. (The sides should look like
🌻ChromaGlitch

🌻ChromaGlitch

205 likes

Add these to your next glute workout for a PUMP
🍑 Glute Max (overall size, thickness, projection) Main driver of growth and “booty pop” Barbell Hip Thrust Smith Machine Hip Thrust Barbell Glute Bridge Romanian Deadlift (barbell or dumbbell) 45° Back Extension (glute-biased) Cable Pull-Through Sumo Deadlift Bulgarian Split Squat (lon
Chalie_Baker

Chalie_Baker

36 likes

Fresh Baked French Bread From Scratch ✨
Homemade bread always tastes better, and this French bread recipe is so simple to make. It comes out soft on the inside with the perfect golden crust and makes 2 loaves, so it’s great for family dinners or just having fresh bread on hand. Ingredients: 2 cups warm water 1 tablespoon sugar 1 ta
QuelleChaos🧘🏽‍♀️🔮☮️

QuelleChaos🧘🏽‍♀️🔮☮️

45 likes

NASA built jet-powered scissors…
The NASA AD-1 looked fake, but the idea behind it was serious. Its wing could rotate in midair: straight for slower flight, diagonal for better high-speed efficiency. The test aircraft itself was small and slow, but Robert T. Jones believed a much larger oblique-wing aircraft could nearly dou
veno

veno

114 likes

A man, appearing to be Roman Reigns, wears a black t-shirt with white text that reads "HEAD OF THE TABLE." Below the text are three stars and a white silhouette of a person. He has a beard, a fade haircut, and a tattoo on his left arm.
HEAD OF THE TABLE ☝🏽
#wweuniverse #roman #fyp #Lemon8 #fypシ
Roman Reigns-

Roman Reigns-

33 likes

🐟🔥 Crispy Pan-Seared Red Snapper No oven, no grill—just a pan! This crispy whole fish is packed with bold seasoning, buttery lemon flavor, and perfectly flaky inside. 🛒 Ingredients * 2 whole red snapper (cleaned & gutted) * 1 tsp paprika * 1 tsp salt * 1 tsp bouillon powder * 1 tsp
Georgia Dismukes

Georgia Dismukes

10 likes

A person with a toned back, wearing a sports bra and patterned leggings, is reflected in a mirror. Text overlays read "YOU ONLY NEED 4 EXERCISES FOR A SNATCHED BACK!" and "SWIPE" with an arrow, indicating a fitness guide.
YOU ONLY NEED 4 EXERCISES FOR A SNATCHED BACK!
You do not need to over complicate your back days, you only need these four workouts to target your whole back and here is why: 1. Lat pull downs - VERTICAL MOVEMENT, TARGETS YOUR UPPER BACK. 2. Seated cable row elbows high - HORIZONTAL (upper) MOVEMENT, TARGETS UPPER BACK AND SHOULDERS.
Maddy 🫧🎧🍵👟

Maddy 🫧🎧🍵👟

38 likes

Follow for more easy and realistic makeup for my gals over 35! I’ve shared this tip many times because it’s so simple but makes such a big difference! If you’re taking your eyeshadow too far down in the outer corners of your eye, it can definitely drag down your eyes. Here is a simple fix…just t
Julia | Makeup & Beauty

Julia | Makeup & Beauty

10 likes

Two male wrestlers, Roman Reigns and Jey Uso, stand in a wrestling ring. Roman, on the left, wears a black t-shirt and pants, with tattoos visible. Jey, on the right, is shirtless, showcasing extensive tattoos, black pants, and a bandana. Both have beards and are looking up, with a crowd in the background.
Head Of Table
#wwe #wrestling #romanreigns #romanreignswwe #Lemon8
Roman Reigns-

Roman Reigns-

22 likes

Two Sheet Pan Shrimp Kebab Wraps are presented on a wooden board. The wraps are filled with grilled shrimp, a fresh sumac salad containing cucumber, tomato, and pomegranate seeds, and drizzled with a white garlic yogurt sauce. The text "Food Crawl" is overlaid on the image.
Sheet Pan Shrimp Kebab Wraps
#springrecipe #lemon8challenge @Lemon8 Food Sheet Pan Shrimp Kebab Wraps with High-Protein Garlic Yogurt Sauce and Fresh Sumac Salad Prep time: 15 minutes | Cook time: 15 minutes | Servings: 6 FOR THE SHRIMP KEBABS: - 2 lbs large shrimp, peeled, deveined and roughly chopped/minced
Mia Hudson

Mia Hudson

50 likes

A man with long dark hair and a beard, wearing a black t-shirt that says 'ACKNOWLEDGE ME', holds a golden trophy. He has tattoos on his left arm and a serious expression.
Head Of The Table
#wweuniverse #wwe #wrestling #roman #fyp
Roman Reigns-

Roman Reigns-

156 likes

Easter series episode 5 and we're making a Braided Almond Croissant Danish 🙌 Here's what you need: For the almond frangipane: 1/2 cup almond flour, 1/4 cup granulated sugar, 1/4 tsp salt, 1/4 cup softened unsalted butter, 1 egg yolk, 1 tsp almond extract, 1/2 tsp vanilla extract For the Danish:
Chahinez

Chahinez

37 likes

Crispy Chicken Wraps
✨ 3‑Ingredient Crispy Chicken Wraps (Under $12!) 🛒 Ingredients (3 Items Only) - Frozen crispy chicken strips - Shredded lettuce (bagged) - Ranch dressing (Everything is grocery‑aisle friendly and budget‑safe.) --- 🍳 How I Made It 1. Air‑fry or bake the chicken strips until sup
Aeboz Studio

Aeboz Studio

525 likes

An illustration of a female body with broad shoulders and narrow hips, labeled 'Inverted Triangle'. Text states: 'Your shoulders OR bust are larger than your hips.' A faint inverted triangle graphic is in the background.
A guide titled 'How to Dress for Your Body Shape: Inverted Triangle Shaped'. It features a woman in a V-neck top and A-line skirt, with sections detailing 'Do's' and 'Don'ts' for tops, bottoms, and shoes to balance the inverted triangle figure.
A graphic titled 'Best Swimwear for the Inverted Triangle Body Shape' showing five types of swimwear: gathered sides, sweetheart neckline, midriff coverage, ties at the hips, and wide straps.
🔻 How to Dress the Inverted Triangle Body
Broad shoulders, fuller bust, narrow hips & defined legs? You might be an inverted triangle! Let’s balance your shape with confidence and style: 🎨 COLORS 🔸 Keep dark or solid colors on top 🔸 Use brighter or bolder colors on your lower half to draw the eye downward 🔸 Ombre or gradient patt
ciciimariee

ciciimariee

647 likes

A hand displays long stiletto nails in vibrant hot pink and neon yellow. Some nails feature a diagonal design with iridescent glitter flakes reflecting pastel tones, separated by a silver line, creating a bold and colorful look.
Neon Summer Stiletto Nails with Iridescent Glitter Accent.
Bold spring and summer nail set featuring long stiletto nails in vibrant hot pink and neon yellow. The design blends sleek, glossy color with eye-catching diagonal accents filled with iridescent glitter flakes that reflect soft pastel tones in the light. #colorful nails #neon green nail pigment
queen_scorpio69

queen_scorpio69

65 likes

A muscular man with long dark hair, a beard, and extensive tattoos on his arms and chest, wearing a red lei and black pants, shakes hands with another person in a wrestling arena. He is also wearing white and black wrestling gloves.
Head Of The Table…..Tribal Chief ☝️
#wwe #wweuniverse #fyp #fypシ #otc
Roman Reigns-

Roman Reigns-

52 likes

Small SquareRoom Ideas
Small square rooms can feel tricky to design, but with the right layout tricks they become functional, stylish, and surprisingly spacious. From diagonal furniture placement and floating shelves to mirror walls, corner desks, and low‑level lounges, these ideas show how to transform a simple square i
Daisy Owen

Daisy Owen

51 likes

Two muscular men, both with beards and extensive tattoos, shake hands in a wrestling ring. The man on the left wears a black t-shirt and pants, while the man on the right is shirtless with black pants. The background shows red ring ropes and a blurred audience.
Head of the Table
#wwe #romanreigns #romanreignswwe #wrestling #wweuniverse
Roman Reigns-

Roman Reigns-

54 likes

Two finished Minecraft market stalls are shown. The top stall is a wooden structure with flowers and lanterns. The bottom stall features a dark roof, white base, and a purple crystal decoration, with text overlays for 'Minecraft Market Stalls' and 'Swipe'.
Four polaroid-style images illustrate building a simple Minecraft market stall. Steps include placing barrels and stairs for the base, adding wooden fences for the frame, and decorating with pink and white banners for the roof.
Four polaroid-style images demonstrate building a multi-level Minecraft market stall. Steps show creating a 5x5 base with stone and wood, adding stairs, constructing stone walls and wooden fences for poles, and decorating the finished stall with flowers.
Simple Market Stalls in Minecraft
🌿 Simple Stall 🌿 ➡️ To make this stall place a 3x3 square of any block, the type does not matter as they are only placeholder blocks. Then on each corner place a barrel, and use the placeholder blocks to place stairs upside down. Once the stairs are placed all around the square remove the placehol
🌻ChromaGlitch

🌻ChromaGlitch

2257 likes

Crispy Fried Red Snapper🐟
Ingredients:📝 2 medium red snapper, cleaned and scaled 2 teaspoons salt 1 teaspoon black pepper 1 teaspoon paprika 1 teaspoon garlic powder 1 teaspoon onion powder 1 teaspoon dried thyme 1 teaspoon dried oregano 1 lime, juiced 1 cup all-purpose flour 1/2 cup cornstarch Vegetable oil,
rosario vnz 🇸🇻

rosario vnz 🇸🇻

26 likes

7-Day Ancient Qi Flow | Day 1 Let’s do it🥰
This Day 1 routine is a balanced ancient sequence that wakes the joints, moves stagnant Qi across major meridian lines, and gently opens the chest, ribs, hips, and spine. A soft, harmonious flow that wakes the body through smooth circulation — light, open, and naturally energized. 🌿 ✅ Move Bene
tcmyogisophia🪭

tcmyogisophia🪭

20 likes

Saving dinner one recipe card at a time ✨
POV: the recipe card disappeared before anyone else could grab a plate. 🤭✨ These are the kind of recipes you keep in the kitchen drawer forever because they actually get made on busy weeknights. Easy ingredients, cozy meals, and zero complicated steps. 🫶🍴 #RecipeCards #EasyRecipes #DinnerId
Stormi

Stormi

16 likes

The image displays handwritten mathematical calculations. The top section shows the expansion of (a²/b² + b²/a²)² to derive a⁴/b⁴ + b⁴/a⁴ = 7. The bottom section calculates (a²/b² + b²/a²)³ using algebraic identities, leading to the result a⁶/b⁶ + b⁶/a⁶ = 18.
a⁴/b⁴ + b⁴/a⁴ = 7
In the regular pentagon, a = side length & b = length of the diagonal. #math #maths #mathematics #geometry #trigonometry
cubicequation

cubicequation

16 likes

Concrete Jungle Ai Photo ⚠️
App Used : Gemini ⚠️ Upload Your Picture ⚠️ Add Prompt Below : Create a breathtaking ultra realistic high fashion editorial portrait of a stunning fashion forward woman with long flowing blonde hair. She wears a mustard yellow leather trench coat left dramatically unbuttoned paired with ma
TaniSha Mariê

TaniSha Mariê

16 likes

Stuffed Breakfast Pretzel Rolls
Ingredients → For the rolls 1 tube (13.8 oz) pizza dough 8 large eggs, scrambled (about 2 cups) ¼ teaspoon garlic powder 2 cups mild cheddar cheese, shredded (divided) 5 slices thick-cut bacon, cooked and crumbled (divided) → For boiling and finishing 5 cups water ¼ cup baking
Kewick

Kewick

10 likes

Dragon at Diagonal Alley!
A must-see at Diagon Alley is the fire-breathing dragon ontop of Gringotts! This is at Universal Orlando resort #universalorlando #diagonalley #wizardingworldofharrypotter #harrypotter #universalstudios
kylevacations

kylevacations

132 likes

Diagonal Masseter Release
Diagonal Masseter Release #faceyoga #facial #skincare #training #facial massager
Vivian Zhou

Vivian Zhou

2 likes

Beautiful head table
Patty Moreno

Patty Moreno

3 likes

Winter-neutral nail inspo ❄️🤍
We created this nude base with hand-drawn snowflakes, fine white striping, and a crisp diagonal tip—watch the full step-by-step! 📍 Saint Paul, Minnesota #happynails55105 #HappyNailsHeadSpa #WinterNails #ChristmasNails #NailInspo #NailArt #HolidayNails #SaintPaulMN
HAPPY NAILS & HEAD SPA

HAPPY NAILS & HEAD SPA

3 likes

One thing about me is imma always eat up a theme park for #harrypotter #hp #potterhead #slytherin #hogwarts #hogwartshouses #universalorlando #universal #diagonalley #wizardingworld #outfits #outfitinspo #fyp
Sav Sommer

Sav Sommer

23 likes

💎 MOSCHINO Y2K AVANT-GARDE EDITORIAL PROMPT Create a hyper-realistic, cinematic full-body fashion editorial using my reference image as the ONLY identity source. ⚠️ STRICT IDENTITY LOCK (NON-NEGOTIABLE) Use my exact face, bone structure, skin tone, and proportions Preserve natural skin texture
Pieface098

Pieface098

39 likes

The Teaser tutorial you need for your Pilates practice!! #pilatesteaser #pilatesmat #pilatesinstructor
Amanda Blauer

Amanda Blauer

0 likes

Homemade garlic bread #recipe BREAD 2 cups warm water, about 105°F 1 Tablespoon active dry yeast 2 ½ teaspoons granulated sugar 5 cups all-purpose flour, more as needed 2½ teaspoons table salt or fine sea salt 1 teaspoon olive oil Melted salted butter, optional In a small bowl, combi
Lemon8er

Lemon8er

7 likes

Working on head, shoulders, knees and heels
While I been working on my skills I’ve also achieved on getting my diagonal changes down
Jake’s Horsemanship

Jake’s Horsemanship

1 like

Juneteenth Freedom Plate Dinner
Today’s dinner is not just food. It is remembrance. It is flavor with a heartbeat. It is the kind of plate that feels like somebody’s grandmother, somebody’s auntie, somebody’s island kitchen, somebody’s Sunday after church, somebody’s backyard full of laughter, somebody’s ancestor whispering, “Bab
ElevatedByShell

ElevatedByShell

4 likes

Create a breathtaking ultra realistic high fashion editorial portrait of a stunning fashion forward woman with long flowing blonde hair. She wears a mustard yellow leather trench coat left dramatically unbuttoned paired with matching high heeled pumps. She sits on the floor leaning against a massiv
prettyeyes

prettyeyes

14 likes

A muscular man with a beard and a full sleeve tattoo on his left arm sits on a gym bench. He wears a grey tank top, black shorts, and smartwatches on both wrists, looking upwards in a gym setting. The Lemon8 logo and username are visible at the bottom.
HEAD OF THE TABLE
#wweuniverse #otc #Lemon8 #community #roman
Roman Reigns-

Roman Reigns-

46 likes

See more