Automatically translated.View original post

時短ちゃん⌇元SEの定時退社×Excel術

1996 followers

Follow

Follow

Follow

324 saved

201

2

Create a large number of folders in an instant!

It is former engineer working OL Tokusho-chan 👩🏻‍💻

Thank you for looking at the post 🤍 -

♡ - - - - - - - - - - - - - - - - - - - - °

Excel time saving tech introduced this 🧸🎧

How to create a folder in an instant

① Enter the folder name in column B

② Enter "md" in column A

③ Press F12 (* Depending on the PC, press fn as well)

④ Save the file format as "CSV (comma-separated) (* .csv)"

⑤ Display → Display → Check "File Name Extension"

⑥ Change the extension from csv to bat

⑦ Click "Yes" for the warning sentence for changing the name

⑧ Double-click to complete the folder in an instant

♡ - - - - - - - - - - - - - - - - - - - - °

Introducing PC time saving technology that can go home early!

Be sure to check out 〰️ other posts 🐾

@ jitanchan _ pc

The person who thought this was a genius The moment I felt spring # excel # excel # excel _ beginner

4/4 Edited to

Excelを使って大量のフォルダを一気に作成する方法は、仕事の効率化にとても役立ちます。私も職場でよく新入社員のフォルダや部署ごとのファイル整理に苦労していましたが、このやり方を知ってから格段に負担が減りました。具体的には、まずフォルダ名をB列に入力し、その隣のA列に「md」と入力します。これはフォルダ作成のコマンドを示す記号です。その後、保存時にファイル形式を「CSV(コンマ区切り)」で保存し、Windowsのエクスプローラーで拡張子を.csvから.batに変更します。batファイルはバッチファイルと呼ばれ、クリックするだけで複数のフォルダを自動で作成してくれます。私の場合、100人分の社員名入りフォルダを作る際にこの方法を使い、数分で作業が終わりました。通常、一つずつ手でフォルダを作成するのは時間もかかり、ミスの元ですが、batファイルによって簡単に一括処理できるのでミスも減りました。また、ファイル名拡張子の表示設定を有効にしないとbatファイルに変更ができないため、事前に確認しておくことが重要です。拡張子を変える際には、「名前の変更の注意文」が表示されますが、ここでは「はい」を選択し問題ありません。この方法は一見難しそうに感じますが、Excelの基本操作と少しのファイル操作の知識があれば誰でも簡単に習得できます。特に部署ごとやプロジェクトごとに大量のフォルダを管理している方、フォルダ作成に時間を取られている方にはおすすめです。ぜひ試してみてください！

Related posts

A laptop screen displays a Gmail inbox with a sidebar showing various custom labels, some with emojis, like 'Promotions', 'Attorney', 'Bank', 'Cash', 'Housing', 'Lifestyle', and 'Shopping'. The text 'Customized Google Labels' is overlaid.

A step-by-step guide showing how to create a new label in Gmail. It highlights navigating to 'Settings > See All Settings', then the 'Labels Tab', and clicking 'Create new label', with a screenshot of the 'New label' input box.

This image illustrates creating a new label by clicking a plus icon next to 'Labels' and provides examples of label names with emojis such as 'URGENT ⚠️', 'Health 🩺', 'IMPORTANT ✉️', and 'Shopping 🛍️'.

✨📧My inbox is now organized with Google Labels📧✨

If your email inbox feels like a junk drawer, this is your sign 👀 Google Labels are basically folders—but ✨cuter✨ and way smarter. Here’s how to set them up and make them fun with emojis 👇 --- 🏷️ How to Create Google Labels (the easy way): 1. Open Gmail (desktop works best) 2. On the le

648 likes

An iPad displays detailed handwritten notes on 'CH. 7: energy metabolism' with various sections, highlights, and a grid background, accompanied by an Apple Pencil.

An iPad with a lock screen showing two smiling women, emphasizing the need for an iPad and Apple Pencil for note-taking.

An iPad screen displays the Goodnotes 6 app page in an app store, showing its ratings, awards, and a special event featuring Sanrio characters.

best notes on an ipad as a college student💙

This is how I take all of my notes using my iPad as a college nursing student! I love the app GoodNotes and I can keep all my notes in different folders for each class instead of carrying around multiple notebooks in my backpack. I used my graduation money to get my IPad and Apple Pencil and 100% r

1580 likes

A MacBook screen displaying a customized desktop with a peach-toned wallpaper featuring an August calendar, motivational widgets, and a wave graphic. The title 'customize Macbook with me' is overlaid, indicating a personalization guide.

An illustration showing various aesthetic wallpaper options for a desktop, including floral and gradient designs. A search bar for 'desktop wallpaper' is present, along with a tip to choose high-quality images to avoid pixelation.

A visual guide on how to clean up the MacBook Dock by removing unused apps. It shows a cluttered Dock and then a streamlined one, with step-by-step instructions for removing an app via right-click options.

✨ Tiny MacBook changes that made it way cuter ✨

I finally sat down to customize my MacBook, and it honestly feels like a whole new laptop now. 🌸 The first thing I did was change the wallpaper - I make my own (you can grab them for free 🫶), but if those aren’t your style, Pinterest is always a great option. Just make sure to pick something hig

1839 likes

A+ habits to copy before school starts ✨🦋👇

Okay besties… the semester isn’t here yet, but we all know once it starts it’s ✨ pure chaos ✨ so I’m setting myself up now. Not with the boring ‘make a schedule’ tips (been there, forgot to use it), but with habits that actually make my life easier when school takes over. Think: 📂 pre-made dig

2844 likes

Customize your folders in Goodnotes

New customization folder feature in Goodnotes ✨ Y'all know I've been in my brown era 😭 so I couldn't wait to redo my folders 🤎 What do y'all think of this new update? #goodnotes #digitalorganization #digitalplanning #ipad #study

150 likes

Instant Pot Beef Barbacoa

Tender, juicy Instant Pot Beef Barbacoa Tacos loaded with bold, smoky flavor. Perfect for Taco Tuesday (or any day you crave authentic Mexican flavor). Made with chuck roast, chipotle peppers in adobo, and warm spices for that slow-cooked taste. Ingredients 2.5 lbs beef chuck roast, cut into la

51 likes

A desk setup with a computer displaying ChatGPT and text overlayed: 'Back to school hack I wish I knew sooner: ChatGPT folders for each class.' An iPad with notes, a keyboard, and a white tumbler are also visible.

A computer screen shows the ChatGPT 'Project name' creation interface. An overlay explains 'Step 1: Make a ChatGPT folder for each class,' with examples like 'BIO101: Foundations.'

A computer displays the ChatGPT interface. Overlays detail 'Step 2: Pin your main chat per class' and 'Step 3: Use it weekly - Summarize lectures - Ask for quiz help - Build flashcards.'

Set Up ChatGPT Class Folders for Fall Semester 💻

One of the best things I did last semester was set up separate ChatGPT chats for every class. Each one became a living, searchable study guide. Here’s how to use folders like a low-effort academic assistant: – Name the folder after your class (ex: “BIO202: Genetics”) – Pin your chat for ea

500 likes

Create your NOTES in seconds!✨

In this post I want to share one of my favorite features in Notes💛 It’s super helpful if you have printed or handwritten text in front of you and want to quickly save it as a Note on your iPhone! Swipe left to see this feature work its magic!✨🪄 #iphonetipsandtricks #iphonehacks #iphon

181 likes

🍫 Fudgy Marshmallow Cookies = Instant Joy!

Soft, Chewy & Loaded with Marshmallow! These are rich, gooey, and topped with the fluffiest frosting—basically a brownie, cookie, and s'more all in one! 🔥🍪 ✅ Ingredients: Cookies: * ½ cup unsalted butter * 1½ cups granulated sugar * 2 eggs * 1 tsp vanilla extract * 2 cups all-purpos

97 likes

An iPad home screen displays various app icons and folders, with a white outline highlighting a row of app folders. A pink text overlay reads 'HOW TO SET Custom folder icons for APP FOLDERS'.

The iPad screen shows the 'All Shortcuts' interface with numerous shortcut tiles. A pink text box instructs to 'Open shortcuts and add a new one'.

A close-up of the Shortcuts app interface highlights the 'Choose from Menu' option within the 'Control Flow' section. A pink text box instructs to 'Go to "scripting" and choose "choose from menu"'.

How to set custom folder icons for app folders

You know that default folder you get whenever to combine apps on an iPad? Well let me show you how to change the icon without compromising the folder functionality. ⬇️ ✳️ Open up the Shortcuts app and create a new one ✳️ Go to the SCRIPTING CATEGORY and select “Choose from Menu” function ✳

367 likes

🎮 Make Life Fun with These Apps

1️⃣ Whering ✨ Platform: iOS & Android | Paid: Free A stylish outfit app where you browse looks, upload your own wardrobe, and mix & match clothes. It’s like having your own fashion playground every day. Why recommend: 2️⃣ Folderly ✨ Platform: iOS & Android | Paid: Free A task-o

1836 likes

A title image with the text "HOW TO CREATE YOUR OWN emojis" in black and brown, surrounded by various beige and gold aesthetic items like a perfume bottle, handbag, slippers, ballet flats, candle, and a bouquet of roses, with a colorful emoji app icon at the top.

An iPhone screen displaying app icons, with an arrow pointing to the "AI Emojis" app icon. Text instructions indicate to "UPDATE IOS 18.1" and "DOWNLOAD APP AI EMOJIS," set against a brown background with decorative elements like a coffee drink and a cinnamon roll.

An iPhone screen showing the "Emojis" section of the app, with options for "My Emojis" and "My Packs." An arrow points to the "Create Pack" option, with text instructing to "CREATE YOUR PACK TO CLASSIFY YOUR EMOJIS," surrounded by decorative food items.

Create Your Own Custom Emojis with Genmoji! 📲✨

🎨💖 If you’re obsessed with emojis and want to take your creativity to the next level, here’s a step-by-step guide to making unique ones and using them across all your favorite apps! 🌈🤩 🔹 First, make sure you have iOS 18.1 📱💡 To access the magic of Genmojis, you need the latest iOS version. G

4756 likes

A close-up of a bowl of Mongolian Beef Instant Noodles, featuring tender beef, ramen noodles, sliced onions, green onions, and red chili peppers, ready to be served.

Ingredients for the beef marinade, including thinly sliced beef, cornstarch, baking soda, Shaoxing wine, dark soy sauce, soy sauce, white pepper, and neutral oil, laid out on a wooden board.

Ingredients for the sauce, including beef broth, oyster sauce, soy sauce, dark soy sauce, sugar, chicken bouillon, and white pepper, arranged on a wooden board.

Mongolian Beef Instant Noodles🍜🌶️

These Mongolian Beef Instant Noodles taste just like your favorite takeout: but they’re easy to make at home!🍜🌶️I used beef chuck instead of flank steak, and it turned out tender, flavorful, and much more budget-friendly😏😏 I was also craving ramen noodles, but you can use any noodles you like. Trus

279 likes

Instant Pot Shredded Beef (Ropa Vieja)

Tender shredded beef simmered in a rich tomato and bell pepper sauce, cooked quickly in the Instant Pot. Time: 70 min Serves: 6 Ingredients * 2 lbs beef roast or (beef stew meat if that is what you have) * 2 tbsp olive oil * 1 large onion, thinly sliced * 1 green bell pepper, thinly sliced

5 likes

Learn to use Canva

I been using Canva for a year and they have evolved to helping me create better content. Canva is a beginner-friendly design platform for making graphics, presentations, videos, social posts, flyers, websites, and other visual content. It works with templates, drag-and-drop editing, and a large lib

1 like

A close-up of Instant Pot Beef Bourguignon in a white bowl, featuring tender beef, baby potatoes, carrots, and mushrooms in a rich sauce, garnished with herbs. The image also displays the recipe title and a list of ingredients for the dish.

INSTANT POT BOUGUINON,!!

https://www.everydayeileen.com/instant-pot-beef-bourguignon/

0 likes

A handwritten recipe for Instant Pot Deviled Eggs is displayed in a spiral notebook. The recipe lists ingredients such as eggs, mayo, vinegar, mustard, salt, and pepper, along with instructions for cooking eggs in an Instant Pot and preparing the deviled egg filling, garnished with paprika.

Here’s the instant pot version for deviled eggs.

Here’s the instant pot version of my deviled egg recipe!!! Some people prefer to do the 5 5 5 method more. And the serving size is bigger due to holidays. You can size it down! #deviledeggs #deviledeggsrecipe #Recipe

5 likes

A title card with the text "Create your own emojis ios18" surrounded by various decorative emojis like a seashell, headphones, blue tulips, a carousel, and a Chanel perfume bottle, with the Genmoji app icon at the top.

An iPhone screen showing the Genmoji app icon, with arrows pointing to instructions to update iOS 18.1 and download the "Ai Emojis" app from the App Store.

A screenshot of the Genmoji app's "Emojis" section, displaying guides, "My Emojis" options, and a "Create Pack" button to organize custom emojis, with an arrow indicating its purpose.

Tutorial: how to create custom emojis⚡️✨

🎨💖 If you’re obsessed with emojis and want to take your creativity to the next level, here’s a step-by-step guide to making unique ones and using them across all your favorite apps! 🌈🤩 🔹 First, make sure you have iOS 18.1 📱💡 To access the magic of Genmojis, you need the latest iOS version. Go t

325 likes

Getting organized

💰Price[$1.74] 🛒12pcs A4 Large Capacity Loose-Leaf File Folders, With 11-Hole Binder Rings, Made Of Modern PP Material, Expandable Button And Label Pockets, Suitable For School, Home, Office, Attendance, Travel - Portable Design, Back To School, School Supplies 300+ sold 🎁60% OFF COUPON for every

0 likes

A Mac desktop setup with a monitor, keyboard, and mouse, displaying the title 'HOW TO MAKE YOUR MAC FILES AESTHETIC' with a light brown folder icon. The image serves as an introduction to customizing Mac file folders.

A Mac desktop setup showing a context menu for a 'File.png' with the 'Copy' option highlighted. Text overlays instruct to right-click the PNG and select 'copy' to begin customizing folder icons.

A Mac desktop setup illustrating the steps to customize a folder icon. It shows right-clicking a folder to 'Get Info', then clicking the folder preview in the info window to paste the copied PNG.

Mac file folders: aesthetic edition 📁

If there's a way to make something a little more aesthetic.. I'm 100% going to do it. anyone else?? 🤭 I LOVE customizing the file folders on my desktop to match my current background (currently loving the neutral/cozy gingham vibe). And it's SO easy to do! Find the file folder PNG

122 likes

Create and Manage Your 2nd Brain! 🍋✨🤯

A "2nd brain" tool, like Notion or Obsidian, provides a structured way to capture, organize, and access information, offering immense benefits for focused work and creativity. Here's how: 1. Centralized Knowledge Hub Benefit: Consolidates all your ideas, notes, and research in one

8 likes

A MacBook Air M2 with a customized desktop background featuring various images, a calendar, and a to-do list. Text overlay reads 'how to get the most out of your mac'.

A close-up of a Mac desktop showing default folder icons for 'photos', 'media planning', 'YT collabs', 'tiktok', and 'IG'. Text overlay says 'customize your folders'.

A Mac screen displaying a right-click context menu on a folder, with 'Get Info' highlighted, illustrating the first step to customize folder icons.

how to customize your Mac🌟💻

you own a MacBook, now what? here’s some ways you can personalize your settings! 1: Custom Folder Images ✨no more boring folders that are hard to keep track of ✨stand out against desktop background ✨simple to change to your preference 2: FreeForm Application ✨bullet point style whiteboa

400 likes

A plate featuring an easy sage and dill Instant Pot roast, sliced and topped with gravy and fresh dill, alongside creamy mashed potatoes and air-fried carrots with candied pecans. The image includes text overlays describing the dish and a Lemon8 watermark.

A close-up of a hearty fall meal on a light gray plate, featuring sliced roast beef covered in gravy and fresh dill, a serving of mashed potatoes, and roasted carrots with candied pecans. A Lemon8 watermark is visible.

A top-down view of a delicious fall meal on a light gray plate, showcasing tender sliced roast beef with gravy and a sprig of dill, creamy mashed potatoes, and roasted carrots garnished with candied pecans. A Lemon8 watermark is present.

An easy Instant Pot fall recipe 🥩🥕🍂

Happy October and fall! I want to start with wishing that I added more pecans on the carrots lol. It’s bothering me so much that I didn’t put many. I did prepare this in a hurry lol. Anywho, this sage and dill instant pot roast was super tasty. The entire dish was. I hope you enjoy! Sage and Dil

10 likes

Categorize your folders 📁

Your business will only grow as much as your systems do. 📁✨ Organizing your folders may seem small, but having clear categories for admin, clients, finances, and marketing saves HOURS of time and stress. Start simple: • Admin • Client Files • Invoices & Finances • Marketing & Bran

325 likes

A Kobo Libra Colour e-reader in a floral case displays a lockscreen with 'BUSY READING' and a Miffy bunny, illustrating a Kobo lockscreen tutorial.

A Canva interface shows custom size input fields set to 1264 width and 1680 height in pixels, instructing users to create a new design with these dimensions.

A Canva design interface displays various elements and two design pages featuring 'Kobo Girlie' and a bunny, demonstrating how to create designs using pictures and stickers.

How I create my kobo screensavers!

A little while ago, I shared how I create inserts for my Kobo Libra Colour, and today I thought it’d be fun to show how I design my custom Kobo screensavers. It’s super simple and all done using Canva! Step 1: Start by creating a design with the appropriate dimensions for your kobo device. St

129 likes

iPadOS 26 Featured Part 5: Add Folders to Dock

iPadOS 26 Featured Part 5: Add Folders to Dock #apple #iPadOS26 #iPados26features #iPados26update #iPados26tricks

8 likes

How to create digital planner stickers- folders

🍓Full YouTube Tutorial (free) 🍰 20% Off Template: SAVE20 ✨OrganizedDigitalPlanner.com . . . #digitalplanner #ipad #ipadplanner #notefulplanner #notefulapp #noteful #goodnotesplanner #goodnotes #digitalplanners #digitalplannerstickers #digitalstickers #ipadnotetaking #aest

8 likes

How to create a viral Facebook page in 30 days using free tools ….💸

This roadmap gives you the exact daily plan to grow faster with AI tools, content strategy, and consistency. 📈 Most people fail because they post randomly. Viral growth is a system — not luck. 🔥 ✅ Niche research ✅ Content planning ✅ Viral post creation ✅ Facebook growth strategy ✅ Moneti

20 likes

A flat lay displays materials for creating a vision board, featuring a pink decorative frame, magazines, star string lights, and sticky notes with goals like 'TRAVEL MORE' and 'DREAM BIG'. A planner shows '2026 Vision'. The image is overlaid with the text 'HOW TO Make A Vision Board'.

How to Create Your 2026 Vision Board ✨

A vision board is more than just pretty pictures—it's a powerful tool to manifest your dreams and keep your goals top of mind! Here’s how to make one that truly inspires you: ☁️✨ 1. Reflect & Dream Big! ☁️ Find a quiet moment to yourself. Grab a journal and think about what you truly

98 likes

Creating Folders in Goodnotes 📂✨

tiny things that make life ✨organized✨: folders in Goodnotes. 💜 Mini Must-Knows tap New → Folder. name it + pick a color. add an icon → save. simple, aesthetic, and makes everything look so neat 🌸 save this for your Goodnotes setup inspo! #tech #goodnotes #tipsandtrick #TechTi

14 likes

MiniFile Folders DIY

Made some file folders for my dolls #barbie #miniatures #toycollector #DIY #dollhouseminiatures

8 likes

Organized your documents folder with one click, its even will create folder

#scan #savetime #easy

1 like

Instant Banana Pudding 🍌

In the video I’m obviously making for a large group , this recipe is for a much smaller portion 1-2 bananas (more if preferred) Pudding base: 1 can of sweetened condensed milk 2 box of French vanilla pudding mix 2 cups of cold water 1/2 cup of heavy cream Mix together and set

12 likes

A smartphone displays Google Drive with color-coded folders like 'Business' (red) and 'Important' (dark grey), illustrating digital organization. A red pushpin and floating yellow and blue folders are also shown, with text 'Organizing my chaos Google Drive With Color-Coded Folders'.

Two smartphones show Google Drive folders in grid and list views, demonstrating color-coded organization. Folders include 'Business' (red), 'Jayden' (blue), 'Miko' (pink), and 'Pics&Videos' (purple) as examples, with the text 'EXAMPLE'.

🌈Change Your Google Drive Into Colorful Folders📁🌈

From chaotic file dumps to a rainbow of productivity, I never knew digital organization could feel this cute! 🩷 Pink for passion projects, 💙 blue for bills, 💚 green for goals, and 💛 yellow for... the stuff I pretend I’ll get to. Highly recommend turning your digital mess into a mood board

145 likes

'Best Part Of Waking Up.... 'GoodMorning 🌞 #foldersinmycup☕️👍 ... #happymonda

1 like

CREATE YOUR OWN VERSION OF A DESKTOP ✨🖥️ ⌨️

For every season, I create a desktop aesthetic. So, this is my 💌 Valentines version! ❤️‍🔥 pick an icon picture of your choice ❤️‍🔥 download to desktop ❤️‍🔥 remove the background of the photo ❤️‍🔥 create a folder (or use a current folder) ❤️‍🔥 *Right Click* “get info” ❤️‍🔥 copy image of

5 likes

Instant Pot Egg Bites for a Quick Breakfast 🥚

Skip the drive-thru and make these easy, customizable Instant Pot egg bites at home! They’re just as delicious as Starbucks’ sous vide egg bites, but more affordable and tailored to your taste. Why You’ll Love This Recipe 🌟 Quick and Easy: Whisk, pour, and let the Instant Pot work its magic.

34 likes

A MacBook screen shows a blue folder icon transforming into a Kuromi character icon, illustrating cute MacBook folder customization. The text overlay reads 'cute macbook folders'.

A MacBook screen displays twelve pink folder icons with various patterns like hearts, plaid, and polka dots. The text overlay reads 'pink folders'.

A MacBook screen displays nine pink folder icons with various patterns including hearts, polka dots, and gingham. The text overlay reads 'pink folders'.

cute folders for your macbook! 💻

hi friends! i made a post in the past, teaching you how to customize the folders and icons on your macbook. i thought it would be fun to share some cute folders i found on pinterest, that you can use for your own desktop. you can remove the background from pictures using many different service

97 likes

Two bowls of instant soft serve, one banana with caramel and cinnamon, and one berry with sprinkles and chocolate chunks, are displayed on a dark surface. The image has a text overlay 'Instant Banana Soft Serve'.

A close-up of a bowl of creamy banana soft serve topped with whipped cream and brown sugar sprinkles, presented on a white marble surface.

A bowl of banana soft serve topped with whipped cream and cinnamon, with a jar of caramel topping and a spoon blurred in the background on a dark surface.

Instant Banana Soft Serve + Berry Option

The most insanely delicious, ultra creamy banana soft serve, made with just five simple ingredients in five minutes! The secret ingredient is instant pudding mix and I have included a lower calorie, refreshing berry option as well! If you’re craving something sweet, or a healthier version of ic

15 likes

Instant Pot Braised Beef Noodle Soup🐮🍜🌶️

Tastes just like that slightly spicy braised beef noodle soup from restaurants 😍 I had some daikon radish at home so I added it in too Also highly recommend this hand-pulled noodle I keep repurchasing (see p5) Ingredients • Beef short ribs (or beef chunks) • Scallion &

2 likes

Digital Decluttering: Refresh Your Digital Space

In today's fast-paced digital world, our lives are filled with an overwhelming amount of information, apps and notifications. Amidst this digital chaos, it's easy to feel stressed, unfocused, and drained. Here are 4 ways to declutter your devices and reclaim control over your digital space.

19 likes

An iPad screen displays the Notability welcome page, highlighting features like secure cloud backup, cross-device access, smart study tools, and live transcripts. It also shows sign-in options via Google, Apple, Microsoft, or email.

The Notability app interface on an iPad shows the 'All Notes' section with 'Getting Started' and 'Tools Guide' notes. The sidebar lists 'Notes' and 'Subjects,' while promotional banners for 'Pro features' and 'Gift Notability' are visible.

An iPad screen shows a blank Notability note with a toolbar at the top. The phrase 'SO FAR SO GOOD' is handwritten in black ink on the digital paper, demonstrating the app's writing functionality.

What does Notability do that others don’t?

There’s something about a good notes app that makes your brain feel calmer. Clean pages. Smooth ink. Everything exactly where it should be. So today I’m doing a VERY detailed, honest review of Notability — the good, the powerful, and the “oh wait… that’s actually useful.” 🤍 This is for student

14 likes

See more