Automatically translated.View original post

1472 followers

Follow

Follow

Follow

143 saved

55

Convenient Ctrl key

@ teru _ excel ← Follow other people who want to know ✅

Ctrl + R: Copy to the right

Ctrl + D: Copy down

· Ctrl + Enter: Batch input the characters you are entering into multiple cells

・ Ctrl + E: Read the entered putter and enter it automatically

· Ctrl + H: Replace function

The replacement function is a function that allows you to modify characters such as input or deletion at once during document creation.

The Ctrl key has many shortcut keys in addition to copy and paste. Let's make use of it to improve work efficiency 💪

- - - - - - - - - - -

Excel Time Shortener for 1 Minute a Day

➡️ learn skills just by imitating

➡️ want to finish work quickly and enrich my private time!

➡️ and secure private time!

➡️ feel free to comment and DM me

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

# excel # Excel Time Shortening # work efficiency # Excel Time Shortener

5/4 Edited to

私もExcelを使った作業ではCtrlキーのショートカットにずいぶん助けられています。特にCtrl＋Enterで複数のセルに一括して同じ文字を入力できる機能は、名前や日付などの繰り返し入力を大幅に効率化してくれます。最初は使い方を覚えるのが少し難しかったですが、これを覚えてから同じ入力作業にかかる時間が格段に減りました。また、Ctrl＋Eのフラッシュフィルはユーザーが入力したパターンを認識して自動で続きを入力してくれる優れた機能です。住所や氏名から特定の情報だけ抜き出したり、フォーマットを統一するときに非常に便利です。例えば、「大谷翔平」や「鈴木誠也」といった氏名の一覧を別のセルで名字や名前だけに分けたい場合、この機能が助かりました。そして日常的によく使うのがCtrl＋Hの置換機能。大量のデータの中で文字を一括で修正・削除できるため、ミスの修正や更新作業が驚くほど速くなりました。特に長いリストの中で複数の表記をまとめたいときは、この機能なしには考えられません。これらのショートカットは、一見使いこなすのが大変そうに見えますが、1日1分ほど練習してマネするだけで自然と身につきます。日々活用すれば作業速度が格段にアップし、仕事の効率化だけでなく、プライベートの時間も充実させられますよ。ぜひみなさんもCtrlキーの便利ワザを習得して、仕事の質を向上させましょう！

Related posts

A pink mechanical keyboard in a box is displayed on a store shelf. Below it are several smaller boxes containing keycap packs with wood, tortoise, and cheetah patterns, highlighting customizable options.

A white mechanical keyboard in a box is shown on a shelf. Below are various keycap packs featuring wood, tortoise, cheetah, and gold accent designs, emphasizing different color keyboards and keycap options.

A light green mechanical keyboard in a box is featured. Below it are multiple boxes of figural keycap packs, including designs resembling sushi and other food items, with a text overlay expressing a preference.

Cheap Customizable Keyboards! ✨

Run to your Target! 🏃‍♀️ For 25 dollars you can get a customizable keyboard where you can pop off the key Caps and change them. On top of having the keyboards, they also have a variety of keycap packs for only five dollars. Give your desk whatever style you want it to be. #target

1362 likes

8 Free Online Certifications to Boost Your Resume

Hi, lemons! In today's competitive job market, having the right certifications can make a significant difference in showcasing your skills and expertise. Online certifications are not only convenient but also cost-effective. Here are six free online certifications that can give your resume a va

1212 likes

Master Your Studies with These Key Tips 🤓📚

I know it is hard to study and understanding all of the key information that you need to ace your exams but I have learned some study tips that helped me. Here are some of my non-negotiable study tips to set yourself up for success: 1. Set Clear Goals • Define what you need to accomplish i

138 likes

A person in a yellow hoodie and sunglasses sips from a white cup with a green straw. Overlay text reads "cool 5Apps you need for improve learning productivity" in yellow and pink fonts.

A graphic displays five app icons: Uptime, Codebay, Quizlet, Grammarly, and Fireflies. Each app is associated with a key feature like "Get smarter, stand out," "Learn python with AI," "AI-powered Flashcards," "AI Writing Keyboard," and "AI notetaker."

The Uptime app icon is shown with text "Get smarter, stand out." Bullet points highlight its features: summarizing key messages from books, podcasts, and documentaries, and offering 5-minute "Hacks" instead of hours-long reads.

Cool apps you need for learning productivity

#apps #appsyouneed #productivity #study #learning #studytips #appsforschool #appsforstudents These 🤩SUPER COOL🤩 apps can make learning easier and more efficient: 1️⃣Uptime: 🌟Get smarter, stand out - Summarising the key messages of the world's best books, podcasts and docu

115 likes

Excel's Most Powerful Trick-Ctrl+E

📊 Welcome to Our Excel Mini-Class! 🚀 In today’s session of the Boost Your Excel Skills series, we’re unlocking the magic of Ctrl+E—your new best friend for saving time! ⏳ Whether you’re working with big datasets or just need to clean up information, this shortcut will help you instantly fill in

150 likes

A box for a Desktop Dry Erase Organizer from Five Below, featuring a white dry erase surface and storage compartments, highlighted as an office must-have.

A box for an Acrylic Tablet Stand, showcasing its compact design, 360-degree rotation, anti-slip silicone, and ability to fold flat, raise, tilt, and rotate.

A packaged teal Book Light with a flexible neck, designed for reading after dark, and a warning about button cell battery ingestion hazards.

OFFICE MUST-HAVES

Five Below had some great office finds for the WFH office, your school desk or your office cubicle. Everything is under $12 and has a purpose to make things for convenient. #summervibes #lemon8contest #office #workfromhome #Lemon8 💵 Price: Under $12 Purchased from: Five Below @Fi

2119 likes

A clean desk setup featuring a pink keyboard, white mouse, and various cute figurines, including Sonny Angel dolls and rabbit clips, on a brown mouse pad, suggesting a personalized and efficient workspace.

A table titled 'Tabs & Browsing (Chrome/Browser)' listing keyboard shortcuts for actions like opening, reopening, switching, and closing tabs, as well as bookmarking pages, for both Windows/ChromeOS and Mac.

A table titled 'Multitasking & Navigation' detailing keyboard shortcuts for actions such as switching between apps, snapping windows, minimizing windows, and accessing task view, for both Windows/ChromeOS and Mac.

⌨️Shortcuts you need for a smoother workflow pt 1

‧°𐐪♡𐑂°‧₊ Save time & boost your focus with these must-know key combos: 🔄 Tabs & Browsing (Chrome/Browser) — Open, close & switch between tabs without touching your mouse — Try: Ctrl/⌘ + T, Ctrl/⌘ + Shift + T, Ctrl/⌘ + Tab 💼 Multitasking & Navigation — Snap windows, jump betwee

35 likes

A person in a white lab coat takes a mirror selfie, with the text overlay "What I used to pass the first two years of medical school" at the top.

A screenshot of the Med School Bootcamp website interface, displaying various medical subjects like Immunology and Nephrology, with a text overlay "MEDSCHOOLBOOTCAMP".

A screenshot of the Sketchy learning platform interface, listing medical subjects such as Microbiology, Pharmacology, and Immunology, with a text overlay "SKETCHY".

Must-haves study materials for medical school

As a third year medical student, I can speak on the third-party resources I used that helped me do well my first two years of medical school and when/how often I used them. Medschoolbootcamp - I used these for the most difficult classes which for me were renal, pulmonology, and cardiology. I lik

194 likes

Excel Magic: 5 Ctrl Shortcuts to Save Your Time 💫

✨ Welcome to Our Excel Mini-Class! ✨ Attention, productivity pros! 🔥 Excel isn’t just a tool; it’s your secret weapon for working smarter, not harder. Today, let’s dive into 5 essential CTRL shortcuts that will save you time and impress your coworkers! 💼✨ 💡 CTRL + 1: Bold text! 💡 CTRL + 2:

20 likes

A desk setup for a graduate student with a research paper, a laptop, a retro keyboard, highlighters, and a breakfast sandwich, illustrating study tips for a peaceful environment and highlighting key points.

A quiet and organized office space with a desk, chair, and bookshelves, described as a peaceful place for studying, emphasizing the importance of a conducive study environment.

A hand holding a breakfast sandwich, a Sausage McMuffin with Egg, next to a keyboard, highlighting the importance of breakfast for energy and focus during study sessions.

Graduate Student tips

#studytips #lemon8challenge These are the things I did just study today. 1. I come into the office over the weekend because it is a nice quiet place. I have three screens to work with and my printer in case I need to print anything. 2. You have to make sure you have breakfast. Today I di

9 likes

Grocery List for Weight Loss + 2 Week Meal Pan🥬🍓🥕

When it comes to shopping for weight loss, the key is to fill your cart with nutrient-dense foods that are satisfying, flavorful, and easy to incorporate into your meals. Not only will this make cooking fun, but it will also help you stay on track with your health goals. Let’s dive into everything

439 likes

A title image showing "3 WAYS I TAKE NOTES" overlaid on a dimly lit window with blinds and artificial ivy vines, setting the theme for note-taking methods.

An iPad displaying digital handwritten notes on "Cellular Respiration" in the Goodnotes app, with an Apple Pencil attached, illustrating digital note-taking for biology.

A laptop screen showing typed notes on "The Trojan War" in the OneNote application, demonstrating digital note-taking on a computer.

3 ways I take notes

Taking notes can be effective depending on how you do it. These are the 3 ways that I’ve found most convenient for my studying. 1. Goodnotes I honestly don’t have anything bad to say about Goodnotes it’s very convenient when I only feel like carrying my iPad and pencil. I like being able to ma

55 likes

My top 3 keebs from my collection so far~ ⌨️💜

I don’t have the most amazing keyboard collection yet, but I do have a handful of keebs that I love! Here are my 3 favorites: 1. LTC Neon75 - hot swappable, 84 key format, wired OR wireless 2. HK GAMING GK61 - hot swappable, 61 key format, wired only 3. Razer BlackWidow V3 Quartz - NOT hot

38 likes

Build Your Professional Persona: Step-by-Step ✨💼

Want to step into your workplace with confidence and purpose? Creating a professional persona can help you own the room, navigate challenges, and shine as your best self. Here’s how to build yours: 1️⃣ Define Your Goals & Traits What do you want to achieve? Which traits will help you get th

14 likes

#fyp #ctrldough #cozycreator #bakingtok #gamergirl

0 likes

An overhead flat lay of an everyday carry (EDC) collection, featuring a portable monitor displaying 'MY EDC', two smartphones, a mechanical keyboard, a compact computer, a mouse, earbuds, a smartwatch, and external storage devices, all clearly labeled.

A close-up view of a compact computer, a wireless mouse, a mechanical keyboard, wireless earbuds, and external solid-state drives, arranged on a gray surface.

A close-up of a smartwatch, wireless earbuds, a smartphone with multiple cameras, and an external hard disk enclosure, resting on a gray textured surface.

My Everyday Carry (EDC) List

1. iPhone se 📱: Compact but powerful, great for daily use like communication and quick photography. 2. ARZOPA G1 Game max 🖥️: A portable monitor. It offers excellent visual for gaming or watching videos on - the - go. 3. Samsung T5 2TB SSD 💾: It provides ample, fast, and reliable storage fo

571 likes

A hand holds a diamond-shaped keychain featuring the SZA CTRL album cover. The image shows SZA sitting on grass surrounded by old computer monitors. Text overlay reads "SZA CTRL."

SZA CTRL Keychain

CTRL SZA Released June 9, 2017 #sza #ctrl #album #albumcover #keychain #rnb #musictok

45 likes

Increasing my milk supply ✨

here are some ways i’ve increased my supply, along with latching my baby every chance i can get! ✨Liquid IV: This hydration multiplier contains electrolytes, which help with fluid absorption, ensuring that you stay hydrated. Hydration is key for milk production, so drinking it throughout the da

110 likes

A sleeping newborn baby is shown in a gray bouncer or rocker, with text overlaying the image that reads "Newborn essentials as a mom of 4."

Screenshots display various baby diapering products, including a healing ointment, a diaper cream applicator, and a diaper caddy, with the word "Diapering" overlaid.

Screenshots show different breastfeeding products, such as electric breast pumps and a silicone breast pump, with the word "Breastfeeding" overlaid.

Newborn essentials as a mom of 4

These are the products I have used most with all 4 of my babies! #newbornessentials #babyessentials #newbornproducts #babynecessities #babyproduct

734 likes

Study with Me for Finals 🎧

Hi everyone! 🍋 This week I’m going to be studying so much for finals. I took one already and have two more to go. I thought I’d show you guys how I study and take you guys along with me. I have my business stats final tmr I really hope I do good. Good luck on your finals!!! You got this! #stud

226 likes

A white pre-built mechanical keyboard with an aluminum build, featuring a programmable knob, resting on a white desk mat. The keyboard is described as high quality and sturdy.

A close-up of the white mechanical keyboard, highlighting its features: gasket mount, 75% layout, hot-swappable, wireless and wired connectivity, and ability to connect up to 3 devices.

An overhead view of the white mechanical keyboard, showcasing its 'shell white' colorway, which is ideal for a white-themed desk setup. It features a 75% layout with a knob.

The most high quality keyboard I own ☁️

Out of all the keyboards I currently own (which is honestly too many), this one from Keychron is by far the one with the highest quality. The base feels super strong and sturdy, and it is also quite heavy. The keycaps and switches that came with the keyboard is also amazing, but I did eventually en

32 likes

My 4 AI Must-Haves for the New Semester

1. AIPPT 🎨 I used to waste so much time stressing over the design and layout of my presentation slides. With AIPPT, I type in my topic and key points, and it generates a beautiful, well-structured presentation. This lets me put all my energy into researching and practicing my delivery. 2. Solve

135 likes

Cool keyboard:Trend in every key!☠️💀

#mechanicalkeyboard #fyp #keyboard #Foryou #fypシ゚viral

31 likes

A close-up of a pink mechanical keyboard featuring CeraKey pink ceramic keycaps. The keyboard has a rotary knob and rests on a pink and teal geometric desk mat. The image highlights the aesthetic of the new keycaps, with text overlay 'CeraKey Pink Ceramic Keycaps'.

CeraKey Pink Ceramic Keycaps

Loving my new ceramic keycaps from CeraKey Do you want to hear a sound test? #keyboard #mechanicalkeyboard #keebs #Keycaps #aesthetic #pink #gaming #tech

40 likes

7 BEST Tricks To Get Your Hands Busy With This Key

#Fidget #Keyboard #ASMR #DIY #KeyboardFidget

102 likes

can't waitt for summer ☀️🌊🏖

3 likes

Two Harper's Bazaar magazines, the American April 2025 issue with three models and the UK March 2025 issue with Priyanka Chopra Jonas, are displayed on a white fluffy blanket.

A close-up of the American Harper's Bazaar April 2025 magazine cover, featuring three models and the prominent title "HERE & NOW".

The contents page of the American Harper's Bazaar April 2025 issue, listing articles under sections like "FACES OF NOW" and "BEAUTY", with small accompanying images.

Which magazine is better? UK or The American one?

#lemon8challenge #dealsandsteals I have two Harper’s bizarre one from UK and one from American the from the UK is 11.99 and the American version is 7.99 which one is better in my opinion I think Harper Bazar UK one is way better your pay four dollars more for a poster and more stories and more

9 likes

How I Reduced My AI Score by 88% in Just One Day

✨ Latest Update: My AI detection rate on Turnitin dropped to 0%! (From over 88% all the way down to single digits — what a relief 😭) Not gonna lie, I was losing it over those AI scores these past few days. Everything was 100% handwritten, yet Turnitin still flagged it sky-high. After digging int

200 likes

Winter-themed keyboard with the sweetest tiny cozy patterns❄️

Every key has the sweetest little winter-themed line art, from snowflakes to tiny characters, and the soft blue-white gradient feels like a gentle snow day. It's like bringing a little warm winter magic to my desk, and typing on it makes every work moment feel cozier.🥺 #keycaps #winterkeyboard

21 likes

Ctrl + Shift: 6 Hidden Shortcuts You NEED to Know😎

👉 Welcome to Our Excel Mini-Class! ✨ Today, we’re diving into the incredible CTRL + SHIFT shortcuts—your new best friend for tackling spreadsheets faster and smarter. ⏰ 💻 ✨ CTRL + SHIFT + 1: Set thousands format ✨ CTRL + SHIFT + 2: Set time format ✨ CTRL + SHIFT + 3: Set date format ✨ CTRL

203 likes

📌Recover Microsoft Office Disappeared from Your PC

Can’t find Microsoft Word, Excel, or Office apps on your PC anymore? This video explains why Office may disappear after updates or errors — and how to restore your apps quickly without losing files. #microsoftoffice #msword #exceltips #apps #datarecovery #techtips

5 likes

Living in China is super convenient

Living in China is super convenient #china #travel #beijing #Shanghai

1 like

A white retro-style keyboard connected to an iPad displaying a cute frog-hatted character and the time 4:49. The keyboard features round keys, serving as a stylish accessory for the device.

A close-up of the white retro-style keyboard, highlighting its round keys and multiple function keys for enhanced typing. The design blends vintage aesthetics with modern utility.

The retro-style keyboard connected to an iPad, showing 'Wednesday, 27 March 4:50' and indicating its Bluetooth enabled feature. The setup offers seamless connectivity for the device.

My new retro ipad keyboard ⌨️

Say hello to the YUNZII B303 Typewriter Keyboard! 🎉 It's a fusion of retro charm and modern convenience. With seamless multi-device connectivity, switch effortlessly between your iPad and other gadgets. 💻⌨️ Its sleek design fits perfectly on any desk, adding a touch of sophistication. Whether y

1417 likes

A hand holds a black air duster/vacuum over a colorful mechanical keyboard, with the text 'LET'S CLEAN MY KEYBOARD' overlayed.

A flat lay shows a black air duster/vacuum, a green compact cleaning tool case, and a USB cable, arranged around a mechanical keyboard. Text labels 'air compressor/vacumn' and 'compact tool case' are present.

A close-up view of the left side of a mechanical keyboard with custom anime-themed keycaps, showing dust and debris before cleaning. The text 'BEFORE' is overlayed.

Gadgets to Clean Your Tech Essentials

Tech Essentials to help clean your Gadgets ! I got these recently in the mail through Amazon because my keyboard was gross, and I was tired of looking at it gross. The green compact case comes with a bunch of different accessories to help get into the tight spaces and also comes with microf

17 likes

0 likes

A laptop, planner, drink, and keys are on a desk, with text overlays "How I do my: College Notes" and "Agricultural Business Major," illustrating a student's study setup.

A laptop screen displays a PDF document titled "Topic 2. Market Supply_ClassNotes," detailing "Technical Progress" with agricultural examples, under the heading "Step 1 Download Materials."

A close-up of a laptop screen shows the Google NotebookLM website, with the text overlay "Step 2 Go to NotebookLM," indicating the next step in digital note-taking.

Digital note-taking my biggest study glow up

Often times instructors cram so many concepts in such little time! It can be hard to write or type notes for a class! Downloading the materials and utilizing AI to write the notes for me, saves time and energy. Your professor does not teach well? Use AI to break down the notes even further and

112 likes

Top 4 websites to level up your presentation 💡

1. Edraw.AI 🤖 Edraw.AI is like having a design assistant who never sleeps! From mind maps to flowcharts, it helps you create pro-level visuals in seconds. Just type in what you need, and the AI does the work—no design experience needed. The only downside? The free version limits your exports, so y

63 likes

A laptop screen displays a customized Windows desktop with a Christmas tree wallpaper, personal photos, and custom icons for applications like Netflix, Disney, Google, and YouTube, illustrating how to make a laptop aesthetic.

A laptop screen shows a web browser open to an icon converter website, displaying download details for an ICO file. Text indicates Pinterest, Canva, and Red Ketchup Icon Converter are used for backgrounds, photos, and icon conversion.

A laptop screen shows a right-click context menu on a YouTube icon, with the 'Properties' option highlighted, instructing the user to select it as the first step in customizing icons.

make your windows aesthetic ✨

if you’re anything like me you loveee to be organized and aesthetic and you’re phone probably is so why not make your laptop as well ! #assthetic #windows #laptopsetup #Lemon8Diary #computerwallpaper

50 likes

No way a keyboard just sounded that good.

#fyp #fypシ #setup #gaming #keybord #zh100 #mechanicalkeyboard #asmr #heal #Froyou

3 likes

Ctrl+C, Ctrl+V, Ctrl+V…

Looks like the developers got lazy in 2026. #cats #cat #cats🐾

41 likes

Your New Favorite Keyboard! ⌨️

Logitech G Play Days are back and the Pro X TKL keyboard brings play and productivity to life with its Functionality ✅ RGB ✅ Typing ASMR to your hearts desire ✅ Use my code “KasuallyKat” at checkout on logitechg.com to save an additional 10% on select Logitech G products! #logitechg #ke

12 likes

5 SECRETS AND QUALITY OF LIFE CHANGES YOU SHOULD HAVE KNOWN EARLIER #WWMonTiktok #wherewindsmeet

0 likes

See more