Automatically translated.View original post

るん|簡単Excel時短術

1563 followers

Follow

Follow

Follow

259 saved

51

Batch delete only input field

Other posts @ run.excel ⬅️ time saving from here

[Procedure]

1. Ctrl + A

Select all tables

2. Ctrl + Shift + [

Only the input point is selected

3. Delete

------------------------------------------------------

This account (@ run.excel) is

Let's go home early and make some free time

⛸️ I can go home 30 minutes earlier than usual ⌚ ︎

🫖 Relaxing at home, happy time with children

🕊️ to people who rely on people around you

I would be happy if I could go home earlier than usual and help make time for myself 🫶

# excel _ beginner # work efficiency Time Shortening Techniques

2025/12/26 Edited to

Excelで表中の入力されたセルだけをまとめて削除したい場合、今回紹介したショートカットは非常に便利です。私は普段から大量の入力データを扱う仕事をしていて、うっかり計算式まで消してしまうトラブルを防ぐため、この方法を活用しています。特にCtrl+Shift+[の使い方を覚えることで、数式や書式を残しつつ中身だけを消去可能です。うっかり式を削除してしまうと後で再設定が大変になるので、この技で効率的に処理できます。また、入力欄だけを選択できるので、チェックボックスやテキストボックスの削除や括弧内の文字だけ消す関数操作などにも応用でき、作業がよりスムーズになります。Windowsの予測変換のリセット操作と併用して使うと、さらに快適なExcel作業環境が作れます。エクセル初心者の方でも簡単にできるので、ぜひ日常の仕事効率化に役立ててみてください。私もこのテクニックで毎回30分以上の時短が実感できています。

Related posts

A flat lay image featuring a pink notebook, gold heart-shaped dish with paperclips, and a gold pen, alongside a keyboard and pink flowers. The text overlay reads "5 FREE ONLINE CERTIFICATIONS to Boost YOUR RESUME."

5 Free Online Certifications to Boost Your Resume

Hi, lemons! In today's competitive job market, having a standout resume is crucial. Employers seek candidates with not only relevant experience but also a commitment to continuous learning. Fortunately, the digital age offers a wealth of free online certifications that can enhance your skill se

742 likes

Sensory input before I start the day as a teacher

I start my mornings with sensory input on purpose. When I’m regulated, my whole day runs better and it helps me better understand what my students need too. Regulated adults create regulated classrooms. #specialeducationteacher #specialeducation #spedteacher #sensory #sensoryintegratio

25 likes

A study desk with an iPad, highlighter, textbook, and notes, featuring the title "How to get a 4.00 GPA Based on your Major" and "All majors included!".

Strategies for Business & Management Majors (Business Management, Accounting, Finance, Economics), including Active Participation, Case Study Analysis, Practice Financial Modeling, and Utilize Study Groups, with mentions of MarketingSherpa and GroupMe.

Strategies for Communications & Education Majors (Communications, Education), including Create Multimedia Presentations, Peer Teaching, Reflective Journaling, and Attend Workshops, with mentions of Canva and Notion.

Major-Specific Strategies to Achieve a ✨4.0 GPA✨🎓🧠

🎓1. Business & Management Majors (Business Management, Accounting, Finance, Economics) ✅Active Participation: Example: In a Marketing class, when discussing a case study like Coca-Cola’s rebranding, share your analysis of the marketing mix (4Ps). This not only engages you in the materi

6986 likes

How to send networking messages on LinkedIn 🧍‍♀️🧍‍♀️

🤝 Networking on LinkedIn can open doors to new opportunities and valuable insights. 🎯 Start with a clear and straightforward message. Introduce yourself briefly and state the purpose of your connection request. For example, you might say you're exploring new roles in their industry, or you

76 likes

A graphic titled 'LISTENING RESOURCES for Korean Language Learners' with arrows pointing to 'youtube channels' and 'podcasts,' surrounded by small Korean flags. The bottom includes 'lemon8' and '@thepolyglotfox' branding.

Screenshots of Spotify podcast pages for 'IYAGI - Natural Korean Conversations,' 'Talk To Me In 100% Korean,' 'Heeya Korean,' and '한국말로 (In Korean),' showing episode details and ratings.

Screenshots of Spotify podcast pages for 'TAYONI's Korean Podcast,' 'SpongeMind Podcast,' 'Cozy Storytime in Korean,' and 'KJしゃベラジ-韓国語&日本語でおしゃべりラジオ,' displaying episode information.

COMPREHENSIBLE INPUT - Korean Language Learners

Continuing what has now become a series 😅 Here are a few of my favorite resources for listening practice and comprehensible input in Korean: (and if you want to learn more about CI, check out my other content!) PODCASTS: ➡️ Iyagi - Natural Korean Conversations by TTMIK ➡️ Talk to me

682 likes

Smarter Learning: Dan Koe's 3-2-1 Method💐

If you’ve ever wanted to dive into a new field but felt totally overwhelmed, here’s a framework that’ll make it happen. It’s called Dan Koe’s “3-2-1” method, and trust me, it’s a game-changer! 🧠💡 This strategy helps you absorb the essentials of any topic in just one month by combining input, o

51 likes

A flat lay image with books, a plant, and white tulips, featuring the text '4 FREE AI TOOLS FOR JOB SEEKERS' as the article title. The image sets a professional yet inviting tone.

A MacBook Pro displays the Jobscan website, which uses AI to review resumes and provide improvement recommendations. The screen shows 'Optimize Your Resume Faster with Power Edit' and an example resume with a rocket graphic.

A MacBook Pro shows the Teal website's AI Cover Letter Generator. The text explains it uses AI to write custom cover letters in seconds, with steps for generation displayed on the screen.

Try these 4 FREE AI tools to job hunt! 💻

There are so many AI tools at the tips of our fingers — many of which are completely free! If you’re a job seeker and aren’t having much luck finding your next adventure, I encourage you to try these out. And no, you don’t need to have technical skills to use these programs! Each of these is des

1307 likes

Spiritual Detox-Cut the Dead Weight & Realign ✨〰️

Ever feel like you’re carrying energy that isn’t even yours? Like your mind is cluttered, your body feels off, and your intuition is quieter than usual? 🤔 That’s not just stress-that’s a spiritual buildup, and your soul is telling you it’s time to detox. 🫧🧼🧹 A spiritual detox isn’t about bur

189 likes

Another pumpkin update for batch #2 🧡🎃

Pumpkins!!! 🧡🎃 YAYYY! Thank you for all of the donations! 36 is huge, but the next update is going to be even huge-er 😅 10 days until the pumpkin patch!!! #pumpkinseason #pumpkinpatch #pumpkin #donation #kindergartenteacher #teacher

766 likes

3 Insightful ChatGPT Prompts

Prompt 1: Spot Your Blindspots Self-awareness is the first step to freedom. What are 3 blind spots holding you back right now? Ask yourself brutally honest questions: → Where am I procrastinating and why? → What feedback have I ignored recently? → What do others keep pointing out that I

262 likes

A title slide for "LISTENING RESOURCES For Spanish Language Learners," categorizing them into "YouTube channels" and "podcast." The background is light yellow with red, green, and white dots.

Screenshots of four Spotify podcasts for Spanish learners: Spanishland School, Podcast de gramática y lengua española by Hoy Hablamos, No Hay Tos, and Español Automático. Each shows ratings, episode details, and a "Found On Spotify!" label.

Screenshots of YouTube channels and one Spotify podcast for Spanish learners: Advanced Spanish with Spanish Obsessed (podcast), Spanish with Alma, Español con Juan, and Dreaming Spanish (YouTube). Each shows subscriber counts and descriptions.

COMPREHENSIBLE INPUT - Spanish Language Learners

Continuing what has now become a series 😅 Here are a few of my favorite resources for listening practice and comprehensible input in Spanish: (and if you want to learn more about CI, check out my other content, including my other recommendations for languages like Japanese, Korean, French, Ma

164 likes

Read-only mode on safari tutorial 🤓

The reader tool in safari is great for minimising any distractions like adds and read each context with ease! Simply tap the icon, turn the reader on and adjust the text size, the font you want your text to have and the color. My personal favorite is a simple Sand serif font and the crème color!

561 likes

💵How to Find High Paying Jobs for Introvert Girls?

1- Pursue Remote Opportunities Remote jobs provide flexibility and a quieter work environment, perfect for introverts. Look for remote roles in tech, writing, or consulting that allow you to work independently from home. This setup suits your preference for solitude and can often lead to well-comp

242 likes

Do you do this? 🎥 notnathaniel_taplin #doctorexplains #relatable #anatomy #sensory

3 likes

🧽SpongeBob Window Keychain Packing📦

🌟Just finished packing the last three of our first batch of SpongeBob window keychains📦. 🤯We’re blown away by your enthusiasm; we never expected the first batch of jellyfish field keychains to sell out so fast💨! They were gone in just a few days⌛️! 😉But no worries! We’re already working hard

7 likes

Weird things from my doc

#lemon8challenge #lemon8badgehunt #adhd

25 likes

GET PAID and STOP AI 🤖 from STEALING your photos!😳

🤑Here is an awesome moneymaking tip for photographers⬇️: 🛡️Protect your money from your side hustle! Do this today before it’s too late! ⚙️ Go into your camera settings and add your name last name of your small business to the copyright information. 🏦Doing helpful things like this will p

159 likes

How to Network on LinkedIn Without Being Pushy

🌟 Ever found someone amazing on LinkedIn and thought, "I'd love to chat with them!" but then froze, not knowing how to reach out? 😬 Don't worry, I've got your back! Career coach Phoebe Gavin just dropped some golden advice on how to slide into those LinkedIn DMs like a pro. N

21 likes

My midterm lifesaver: all-in-one PDF Study Tool 📚

Study with me 📚 Just finishing midterms and i want to share with you the tool that helped me a lot in studies. It’s “PDF Element”—the tool can solve all PDF problems with outstanding features: • OCR • AI chat bot • Translate • Proofread And many features Don’t miss out this amazing tool 🥹

3 likes

Gut-healthy good swaps

Foods that I used to find healthy that were actually hurting my gut. Now, I focus on quality of food and ingredients ✨ #cleaningredients #guthealthswaps #guthealth #antiinflammatorylifestyle #antiinflammatorydiet #cleaneating

2161 likes

From Panic to Peace: How CamScanner Saved My Exams

I have to admit that the universe never gives me a second of peace 😨 I still remember that day — final exam for Python 1. Only 2 hours left and just one cheatsheet remaining. And then… I spilled matcha all over it 😔 I was panicking and completely stressed out. Thankfully, with the recovery fea

62 likes

Your input is very appreciated on my Demo songs❤️😘

1 like

How I always get in early for job applicantions

Set notifications!! The job market over the last few years has gotten more competitive with more applicants and less roles Something that really helped me stand out was getting in early. I noticed that when I applied early, I was more likely to hear back because I was in the first batch of appli

45 likes

The image features a cartoon character with blue hair and glasses, hands on cheeks, against a light purple background. Text reads '7 Tools for Streamers' and 'That isn't about video clips stuff you might not need until you need it'. A pink starburst says '#3 and #6 are my favs'.

7 Tools for Streamers ✨

These are tools that you don’t think you need but happy to have when you do! I love 3 and 6, which tools would you be willing to try out? 🤔 🤩 Let me know and I’ll send some tips your way! #twitchstreamer #contentcreator #youtube #girlstreamer

546 likes

A green and white graphic titled 'Master Simple Excel Operations', listing five basic Excel tasks: creating a workbook, entering data, adjusting column/row size, inserting/deleting cells, and using functions.

A graphic titled 'Keyboard Function Key Identification' showing a white keyboard layout and a table identifying common keys like Esc, Tab, Caps Lock, Shift, Ctrl, Alt, Enter, Backspace, Sleep, and Wake Up.

Getting Started with Excel: It's Really Simple!

We'll start with the basics, learning about Excel's interface, toolbar, cells, and other fundamental operations. Then, we'll move on to common office shortcuts, as well as some frequently used functions and formulas. #ExcelBasics #ProductivityTips #SpreadsheetSkills #Exce

40 likes

Upgrading our chicken brooder

Will they like it? So far, it’s giving “happy hens in a penthouse.” We scored 3 large pet pens for $140, major thrift win, and turned them into a temporary teen chicken setup while we prep their outdoor run. They’re flappin’, dust bathin’, jumpin’, and doing chicken zoomies all day. Right now

10 likes

20 Essential HTML tags for beginners

#softwareengineering #dayinmylife #coding #digitalplanning #studymotivation

2 likes

incognito tab - how to delete browsing history .

3 likes

How to get the job w/ no experience!

I may not have had “direct experience”.. but I had TONS of transferable skills! I took a small break from childcare as I was configuring some medical problems. I’m studying Human Resource Management so I wanted to find a entry level job in that field. I knew I could do the work but 25+ jobs denie

170 likes

Complete Step-by-Step Guide Time Lapse Photography

Hi, Wanderlust Warrior Lemons!Time lapse photography is a mesmerizing technique that captures the passage of time and movement in a way that is impossible to perceive with the naked eye. It has become increasingly popular in travel blogging, allowing photographers to showcase the beauty of landscap

9 likes

MY BO7 SETTINGS THIS YEAR AS A TOP 250 PRO 😳🔥 #warzone #callofduty #blackops7 #bo7 #gaming

12 likes

Supercharge Your Content Process with These Tools

Creating content can feel overwhelming, but using the right tools can make the process smoother. Pimosa makes video, image, and audio editing easy and intuitive. InVideo offers text-to-video features with a wide range of templates for quick video creation. Descript lets you edit videos a

12 likes

✨📕STEAL MY PSYCH NOTES: Sensation & Perception🍋✨

🗣️ Learning about sensation and perception? Here are a few notes to get you through it! I’ve included 20 key terms and a few important figures you should know when learning about and reviewing these concepts. As always, let me know if there is anything you’d like to see discussed or need clarity on

89 likes

A wooden pier over water with buildings in the background, featuring the title "HOW TO RECORD volunteer hours FOR PA SCHOOL" and decorative white lines and yellow flowers.

A list of recommended columns for tracking volunteer hours: volunteer organization, # of hours, description of role, contact name, contact number, and contact email, with yellow flower decorations.

How to record volunteer hours for PA school

To put it simply, I love using Google sheets! The platform is easy to use and allow me to to record all information I needed that was accessible across any device I use. You can use pen and paper if you would like, however, I recommend this method as it also allows you to input links to diff

41 likes

i flew solo to Curacao 🇨🇼 this is how i did it 🕺🏽 #beacharnae #solotravel #solotrip #curacao #curacao🇨🇼 #curacaotravelguide #amybradley #amybradleyismissing

0 likes

Replying to @HeyItsTrinh Tutorial on how to bulk create daily agendas for the school year! #fyp #foreverhannas #teachersoftiktok

1 like

5 Steps to set up your AI Empire today.

The difference between a "dream" and a "destination" is a plan. 🗺️ I know you’re tired of the meetings that could have been emails and the performance reviews that don't match your worth. I was there. I used a program to turn my frustration into a $1k/month (and growing)

14 likes

A computer screen displays a code editor with JavaScript/TypeScript code, showing a project structure and a file named 'EditForm.tsx'. An overlay text reads 'Best AI Coding App'.

Best AI Coding App

Best AI Coding App in 2025? It’s BootSelf – And Here’s Why You’ll Love It! If you’ve ever tried to learn coding and felt overwhelmed, confused, or just stuck… you're not alone. I’ve tested a dozen apps, platforms, and tutorials — but BootSelf is the AI-powered coding mentor that finally mad

133 likes

Day 18 of my 30 day coding challenge

Create a sleek and interactive Emoji Picker using HTML, CSS, and JavaScript! 🔎✨ This project features real-time search, emoji keyword filtering, and a click-to-copy function—perfect for social media, messaging apps, and web projects. Try it now and boost your JavaScript skills! #codingforbeginners

2 likes

From Pixie Hollow to Your Kitchen!

✨🧚‍♀️ Step into Pixie Hollow — but make it delicious! 🧁🍋 From airy Pixie Puffs to bright Lemon-Lily Cupcakes, I whipped up a magical batch of fairy-approved treats you can make right in your Air Fryer and Instant Pot! 🌿🌸 Perfect for tea parties, spring picnics, or just adding a little everyday spar

3009 likes

Personal branding 101 🙇🏽‍♀️📝

Personal branding is key to standing out and showcasing your unique value. Here are some essentials for building a strong personal brand: Define Your Niche: Identify your strengths, passions, and areas of expertise. Focus on a specific niche where you can showcase your knowledge and skills to st

34 likes

time management tips - corporate & grad student

tips for managing work & grad school, from a girl balancing a corporate career in beauty and a part-time mba. with the right strategies, you can make it happen.💜 #timemanagementtips #timemanagement #mbalife #gradschoollife #productivityhacks

27 likes

𝑯𝒆𝒚 𝒇𝒓𝒊𝒆𝒏𝒅𝒔, 𝑰 𝒏𝒆𝒆𝒅 𝒚𝒐𝒖𝒓 𝒊𝒏𝒑𝒖𝒕! 🌲🏃‍♀️ ✨️If you had told me a few years ago that I'd be thinking about trail running, I would have laughed it off. The idea of navigating those rugged paths used to intimidate me. But now, I’m actually considering giving it a go! 😳 For all the trail runners

1 like

Another batch that no one will see, lol.

And yet another batch of my ugly self that no one will see because this app is lame as balls on a cactus.

3 likes

Enter into your productive lifestyle

It's great that you're motivated to improve your health, appearance, and financial situation! While the term "lazy" implies a lack of action, it's important to transform that mindset into one of productive habits and self-care without overwhelming yourself. Here are 200 actionab

16 likes

your input is not based on productivity. the one that actually matters. it's based on who you are as a person, how you treat others and how you use your auhenticity to add value to your own life and other people's lives simply by being yourself, not your damn fucking bank account. yes, money is nec

2 likes

My Best Reset After Too Much Input

My Best Reset After Too Much Input is the kind of evening reset that stops the whole night getting worse. Lowering demand on purpose is usually the smarter move for me. #autismuk #aspergers #autisticadult #recovery #neurodivergentlif e

0 likes

See more