Automatically translated.View original post

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

1303 followers

Follow

Follow

Follow

422 saved

170

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

An iPad screen displays the title 'HOW TO TAKE NOTES HOT GIRL ADDITION' with pink bows and cherry illustrations, indicating a guide to effective note-taking.

An iPad screen shows the Notability app page in an app store, highlighting its 4.7-star rating, features like PDF note-taking, and recent updates including an AI study tool.

An iPad screen within the Notability app shows organized notes with subjects and dividers like 'Weekly Reset' and 'Salon Life,' demonstrating how to categorize notes for easy access.

HOW TO TAKE NOTES

✨ Taking Effective Notes with Notability: A Game-Changer for Students and Professionals ✨ Are you looking to boost your productivity, improve your study habits, or streamline your work life? Taking organized, clear notes is key, and Notability is a powerful tool that helps you do just that! Here

3041 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

1478 likes

Two packages of chicken-flavored instant ramen and a carton of brown eggs are displayed on a countertop, with the text 'Instant Ramen but make it... BETTER'.

Two blocks of instant ramen noodles are boiling in a pot of water on a stovetop, with the text 'BOIL YOUR NOODLES'.

A pat of butter is melting in a black skillet with minced garlic, accompanied by the text 'MELT BUTTER IN A SKILLET & ADD MINCED GARLIC'.

Instant Ramen but make it… BETTER

#ramennoodlerecipes #cheapmeals #dinnerideas #budgetfriendly #cooking

4692 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

125 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

1622 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

2814 likes

Excel cheat sheet

Excel cheat sheet #excel #exceltips #exceltricks #exceltraining #tutorials #excel_learning

14 likes

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

546 likes

Changing the Mac folders on laptop / computer

I think there are other ways to do this and you can even add photos or icons, but this is the easy and quick way or if you just want color. If I figure out how to do the custom / other way to change the folders, I’ll show that one too. #Apple #MacBook #iPhone #tutorial #decor #hacks

1706 likes

A person in light blue scrubs and white clogs holds a stethoscope and a syringe, with text overlayed saying "tips on surviving your first semester of nursing school!". The image highlights essential nursing tools and the theme of guidance for new students.

Screenshots of online product listings for a nursing school planner and nursing badge cards are shown. A pink text box overlays the image, stating "you don't need all these fancy supplies!", advising against unnecessary purchases for nursing school.

A hand holds three detailed flashcards illustrating the human heart and circulatory system, including cardiac conduction and oxygenation. The text overlay reads "FIND A STUDY STYLE THAT WORKS FOR YOU", emphasizing personalized learning methods for nursing students.

Nursing School Survival Guide!✨🩺

Nursing school is far from easy, but if you’re just starting out or thinking of becoming a nurse, welcome! As a current nursing student, I want to share some tips with you that I have learned along the way. 🩺 Let’s talk supplies! You may be tempted to buy all these fun supplies, but in realit

1433 likes

A Canon G7X camera on a tripod, recording a person, with the title "THE STEPS OF MAKING A Youtube Video" overlaid. The camera screen shows a live view of the recording subject.

A Canon G7X camera on a tripod, recording a person, with the text "1. FILM" overlaid. The camera screen displays the live recording view.

A laptop screen showing video editing software (iMovie) with a video timeline and a preview of a person speaking. The text "2. EDIT" is overlaid on the screen.

The Steps Of Making A Youtube Video! ✨🍋

I’ve made sooo many videos in my life and these are the steps!! 1. Film! make a video, it can be anything! i make all kinds of videos from vlogs to book reviews! 2. Edit! editing is my favorite part!! you can do ANYTHING with a video!! get creative with it! 3. Thumbnail! I use canva! Th

2107 likes

Let’s Create in Canva 🎨✨

It’s time to bring those ideas to life! Canva makes designing so fun, simple, and aesthetic. Whether you’re working on journals, planners, social posts, or digital products—you can create it all right here. 🌸💻✨ Ready to design something beautiful today? Let’s create in Canva! 💡💫 #CanvaDesign

71 likes

$1099 Later… Here’s the Truth About the iPad Pro✨

$1099 might sound crazy for a tablet… but here’s why this iPad Pro became my ride-or-die as a work-from-home mom and student: ✨ It’s basically my laptop, sketchbook, planner, & notebook all in one I pair it with: — Apple Magic Keyboard (hello built-in trackpad & laptop vibes!) — Apple

8464 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

1813 likes

Instant Pot Creamy Chicken and Rice Soup

This Instant Pot Chicken and Rice Soup is the best comfort food dish. It's creamy, healthy and really easy to make! This delicious soup is the perfect family meal for chilly nights. WHY YOU'LL LOVE THIS RECIPE Uses real ingredients. This Instant Pot creamy chicken and rice soup recipe

4866 likes

Create a GIF from ANY VIDEO

Sometimes you just can't find the right gif to express yourself. And making one, well that's something you need special software for right? WRONG! If you have an iPhone you can make a gif. The best part? It only takes a couple of clicks thanks to Apple's Shortcut App! Here's How

61 likes

Create Your Logo Using Magic Media on Canva

Need help designing your logo?! Canva has an awesome AI feature called Magic Media that. A create the design for you in no time! Disclaimer: You must have a Canva Pro account! Give it a try and let me know what you think in the comments. Follow @planitdigitalgirl for more amazing Canv

146 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

93 likes

How I stop forgetting notes and tasks 🫶

#productivity #productivitytips #aiapp #adhdhacks #adhdtips

3 likes

INSTANT POT French Onion Beef & Noodles

Instant Pot French Onion Beef & Noodles •1 Lb Steak, Cubed •1 Tb Salt & Pepper •2 Tb Oil •1 Onion, chopped in large pieces •2 Tb Worcestershire •2 C Beef Bouillon/ Beef Stock •1 Can French Onion Soup •1/2 C Cornstarch/water •Wide Egg Noodles •Mozzarella Cheese for topping

117 likes

How to change your font for your folders

I don’t like having to download apps just to get fonts, so this is what I do. It just takes a while, especially if you’re gonna do every app you have on your Home Screen. If you’re gonna change the images on the apps, that would be a good time to add on the fonts while you’re at it. #iPhone

112 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

139 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

498 likes

💡iPad Tip: Create a Battery 🔋 Charging Automation

💡iPad Tip: How to create charging 🔋Automation This trick is so cute and easy to set up! Here's how to do it👀⬇️ 1️⃣Open the Shortcuts app 2️⃣Select Automation and the "+ New Automation" 3️⃣Scroll down to "Charger" and select it 4️⃣Select "Run Immediately" then &#

231 likes

Instant Pot Sausage & Potatoes

• 1 1/2 lbs fresh diced potatoes • 1 lbs kielbasa sausage cut into small pieces • 1 small onion diced • 2 or 3 garlic cloves minced optional • 2 1/2 cups shredded cheddar cheese • 1 1/2 to 2 cups chicken or vegetable stock • 1/2 cup milk • 1/4 cup heavy whipping cream • 1/2 tablespoon unsal

7 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 ✳

363 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

Brown Butter Chocolate Chunk Cookies 🍪🤎

crispy edges, soft centers, and that deep nutty flavor from the brown butter ✨ Ingredients •2 sticks unsalted butter •1/2 cup granulated sugar •1 1/4 cups light brown sugar •2 1/2 cups all purpose flour •1 tsp baking soda •1/4 tsp baking powder •1 tsp fine sea salt •2 large eggs + 1 egg

75 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

295 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

6 likes

Instant Pot Greek Beef Stifado 🍲🧅

Instant Pot Greek Beef Stifado 🍲🧅 Ingredients: 2 lbs (900g) beef chuck, cut into 1-inch cubes 2 tablespoons olive oil 1 large onion, chopped 1 lb pearl onions or small shallots, peeled 4 garlic cloves, minced 2 tablespoons tomato paste 1 can (14 oz) crushed tomatoe

47 likes

2 likes

🧹 📓📚Tips (As a grad student these are the study tips I’ve been living by)📓📚: 1.Stay Organized: Use planners, digital calendars, or apps to track deadlines, assignments, and exams. Keeping things organized will help you manage your time effectively. 2.Break Down Tasks: Large projects can feel ove

28 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

Upgrade your instant noodle

⏲️No time? Make these quick & easy pan noodles with instant ramen 🤗 Done in 15 min. Feeds 3-4 🌱Ingredients -2 packs instant ramen noodles - 1 onion, diced - 1 bell pepper, diced - 8 oz. frozen mixed vegetables (230g) - 6 oz. frozen broccoli (170g) - 2 Tbsp. soy sauce - 1 ½ tsp garlic

41 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

72 likes

A laptop on a desk displays a design application with various visual assets, while a monitor in the background shows a pixelated tree. The image features text overlay: "These apps will change how you organize your design files, content, and photos!"

A screenshot of the Cosmos app interface displays a grid of diverse design inspirations, including 3D objects and abstract art. The image highlights Cosmos as a sleek AI-powered inspiration hub for capturing creative ideas.

Screenshots of the Playbook app interface showcase a photographer's event gallery, a designer's portfolio, and visual boards. The image describes Playbook as an app for organizing creative assets with AI tags and seamless project management.

Apps to Keep Your Design Files & Photos in Order

Starting my creative projects used to mean drowning in endless folders on my MacBook or piecing together mood boards in Miro—like I did for my recent room makeover. But honestly, I often lost motivation because I’d forget where I found all my inspiration online. Pinterest is always great, b

109 likes

Tutorial of printing large images/photos #beesaccessoriesboutique #walgreens #diy #balloondecor #fypシ

2 likes

🚨 This might be the easiest digital product flip I’ve seen… and most people are

Imagine getting **1000+ ready-made coloring pages**… and turning them into a product you can start selling *today*. No designing. No stress. No starting from scratch. — ✨ Introducing the 1000+ Coloring Pages for Kids Bundle (with PLR + MRR Rights) This isn’t just a coloring pack… I

5 likes

3 Minutes Instant Pot Apple Cinnamon Oatmeal

The Easiest Oatmeal You’ll Ever Make – 3 Minutes in the Instant Pot! No stirring, no pot watching—just cozy, creamy oats with the press of a button. Here’s the magic ratio: 🥣 1 cup oats = 2 cups liquid For this batch: — 3 cups oats — 3 cups water — 3 cups milk (don’t use all milk—it can

25 likes

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

1 like

Instant Pot Apricot Jam

You will love this 3-ingredient Instant Pot Apricot Jam made with just apricots, sugar and lemon juice (no pectin needed). Super simple, delicious and so much better than store-bought! Ingredients ▢2 pound Apricots, rinsed ▢1 cup Granulated sugar ▢2 tablespoon Lemon juice Instructions

9 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

394 likes

An overhead flat lay features an iPad displaying a vision board with pink and money-themed images, alongside headphones, a beauty product, and a drink. The text "Plan & Create Like A Boss" is prominently overlaid on the image.

An overhead flat lay shows an iPad with a vision board, headphones, and a beauty product. Overlaid text asks, "Are you ready to level up your content game?" and promises tips for digital planning and beauty & lifestyle content creation.

A flat lay displays an Apple Pencil, an iPad showing a vision board, and a cellphone with a woman's image. Text labels them as tools for refining designs, planning, and shooting stunning photos and videos.

✨ Plan & Create Like a Pro on Your iPad! ✨

Ladies, let’s get into digital planning! 💻🎨 Whether you're brainstorming beauty tips, lifestyle hacks, or personal goals, your iPad can be your ultimate content creation tool. I use apps like Canva to resize designs for every platform and ChatGPT for crafting SEO-rich captions that slay every t

198 likes

Let me show you how to make a Classic & Authentic CHILE VERDE STEW in under 30 minutes! It’s seriously so easy and soooo delicious 🤤 Ingredients: 12 roasted & peeled hatch pepper 2 1/2 lbs chuck roast or pork shoulder 2 tbsp all purpose flour 1 1/2 tbsp salt & 1 tbsp bp 1 onion; chopped

249 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

Nigerian Pancake + Zobo Drink = Instant Food Coma

POV: You wanted a light breakfast… Nigeria said eat and be strong 😂 This is a Nigerian pancake served with boiled eggs, carrots, cucumber, and a cold cup of zobo drink. Simple ingredients, but somehow one plate feels like three meals. Nigerian breakfasts don’t play. One bite in and you alr

3 likes

Easy Peasy Instant Pot Pumpkin Puree

Making fresh pumpkin puree is now so easy in the Instant Pot. NO peeling or cutting of the pumpkin ahead of time. Ingredients ▢1 Pie Pumpkin, or Sugar Pumpkin ▢1/2-1 cup Water, for puree ▢1 cup Water , for cooking Instructions If using, place trivet in the Instant Pot insert and ad

22 likes

See more