Automatically translated.View original post

わこ｜1分で学べるPC仕事術

7362 followers

Follow

Follow

Follow

122 saved

39

[Excel Convenience] Automatically update serial numbers! How to use the ROW function

@ wako _ pc _ work ← Overtime will be reduced by following!

Today, I introduced how to automatically correct the serial number when deleting a line ✨

If you have any questions or comments, please send them to comments or DM 😊

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

[Self-introduction]

It's Wako!

At a major IT company, I develop apps and manage teams 💪

There is such a past.

Adaptation disorder due to working too much

Overtime is now less than 10 hours a month!

・ I was shaken by my boyfriend who I dated for 5 years

Let go of perfectionism and 😊

Meet a nice person and have a happy marriage 🕊️

These two things changed me when I was at rock bottom!

① Skill up

② Mind

We will deliver not only Excel, PowerPoint, Word but also mind and know-how to promote work easily 🫧

Nice to meet you!

Those who want to know more 👇

@ wako _ pc _ work

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

2025/12/26 Edited to

Related posts

A laptop displays an Excel spreadsheet with charts and data, while a hand interacts with the trackpad. The image features text overlay "Excel shortcuts cheat sheet" and "SWIPE FOR MORE," indicating a guide to Excel shortcuts.

This image lists four essential Excel shortcuts: Autosize Columns (Alt + H + O + I), AutoSum (Alt + =), Display formula in cells (Ctrl + ~), and Insert Current Date (Ctrl + ;). It is part of a multi-page guide.

This image presents four more Excel shortcuts: Insert Hyperlink (Ctrl + K), Freeze Rows & Columns (Alt + W + F + F + F), Fill Down / Fill Right (Ctrl + D and Ctrl + R), and Paste Special - Values (Alt + E, S, N).

Excel shortcuts every student should know! 👩🏻‍💻

Excel shortcuts can significantly improve your efficiency and productivity when working with spreadsheets. Here are some powerful Excel shortcuts that everyone should know. These shortcuts can save you a lot of time and make working with Excel more efficient. Practice using them regularly to become

2718 likes

Sequence in excel or google sheets

The =SEQUENCE function in Google Sheets is a game changer for generating numbers automatically. No more typing rows manually. In this quick tutorial I’ll show you how it works and how you can use it in real projects. #googlesheets #exceltips #spreadsheettips #googlesheetstricks #datame

5 likes

A woman takes a mirror selfie, holding a coffee cup and phone, with text overlay 'EXCEL SHORT CUTS SAVE TIME & FRUSTRATION PART 1'. Abstract shapes frame the image.

A beige graphic slide explains the Excel shortcut 'SHIFT + END + DOWN' for selecting an entire column or section of data, with a 'SWIPE' indicator.

A brown graphic slide details the Excel shortcut 'CTRL + A' which selects all data in a worksheet, accompanied by a 'SWIPE' instruction.

EXCEL SHORTCUTS

These excel short-cuts are just a few that have made my excel work take a fraction of the time and genuinely changed my work life!! Working in excel can be extremely frustrating when not using the tool efficiently. Here are some crucial shortcuts to enhance your experience with Excel. CTRL + A

2586 likes

Excel goal and metric dashboard

Track personal or business goals with this goal tracking template. Lever 3 on my site. #template #excel #exceltraining #exceltips #work

9 likes

How to Create Serial ID Numbers

📊 Welcome to Our Excel Mini-Class! 🚀 Hey Excel enthusiasts! 👋 In today's session of the Boost Your Excel Skills series, we’re showing you How to Create Serial ID Numbers in Excel—a quick and efficient way to automatically generate unique identifiers for your data. Whether you're managing

3 likes

The front cover of the manga "Firefly Wedding" by Oreco Tachibana, featuring a blonde woman and a dark-haired man, both with bloodstains, against a pink and purple background with fireflies.

The back cover of "Firefly Wedding" manga, displaying a synopsis of the story, publisher information (Viz Media, Shojo Beat), pricing, and an illustration of a woman with a red umbrella.

An open manga page showing "Chapter 1: Unwanted Repayment." It features a black and white illustration of a man and a woman in traditional Japanese attire, kneeling, surrounded by glowing elements.

a twisted marriage of convenience

Title: Firefly Wedding Creator: Oreco Tachibana 📄 Plot: Meiji-era noblewoman named Satoko, who is engaged to be married to a nobleman but targeted by an assassin named Shinpei. Satoko is ill, has a short time to live, and wants to secure a marriage to benefit her family before she dies. When

117 likes

Excel time stamps

Yes, I said permanent time stamps #exceltips #excel #tutorial #worktips #exceltraining #exceltricks

53 likes

Excel File Overwritten? Get It Back in Seconds!

Accidentally saved over your spreadsheet? Relax — recovery it simpler than you think. This video shows you how to restore your Excel files. Save your important data fast! 🚀 #excel #recovery #deleted #file

0 likes

Excel permanent timestamp

Time stamps DO NOT update when you close and reopen #excel #exceltips #templates #tutorial #exceltraining

23 likes

Marriage of convenience and enemies to lovers!

The Stones of Fire series by Sarah Ashwood. Completed urban fantasy shifter series in KU and Audible. #kindleunlimited #romantasy #enemiestolovers #enemies to lovers #marriageofconvenience #morallygreymen #sarahashwood #lemon8books #bookstoread #reader

58 likes

Enter 1000 Serial Numbers in ONE Second! 🤯

✨ Welcome to Our Excel Mini-Class! ✨ Hey, Excel pros! 🖥️ Ever needed to quickly fill a column with serial numbers but didn’t want to waste time typing them one by one? 🤔 I’ve got you covered with a super simple trick to enter serial numbers in just ONE second! ⚡ 🔑 Steps to enter serial number

2 likes

Toxic hearts: marriage of convenience

This quote is from a character in my new book, Toxic Hearts. Does it resonate with you? Let me know! #bookquotes #romancebooktok #romancebookrecs #romancereadersofbooktok #nadiabraeckelbooks

2 likes

Toxic Hearts: Marriage of convenience

Authors, you feel me right?. If you're a fan of romantic suspense books you can grab 'Toxic Hearts' at the link in my bio! #nadiabraeckelbooks #indieromanceauthor #romanticsuspensebooks #romancebookrecs #newreleases

1 like

Home organization and convenience to take with you

Seriously, this isn’t just an organizer… it’s a solution for your entire routine 👇 ✔️ Keeps fruits and snacks organized in your fridge ✔️ Helps food stay fresh longer (less waste 💸) ✔️ Separate compartments = more hygienic and practical ✔️ Perfect for families, especially with kids And the

9 likes

Convenience is key with this Dr.Brown milk pitcher 🥰🥰🥰

#fyp #lemon8challenge #followerslemon8 💌 Brand:

2 likes

Toxic Hearts: Marriage of Convenience

Have you read Toxic Hearts yet? 💜 Enemies to friends to lovers 💜 Fake Relationship 💜 Marriage of Convenience 💜 Opposites Attract 💜 Age Gap 💜 Retired Military MMC 💜 Broken FMC 💜 Dark Secrets Then you’ll love Toxic Hearts! Also available at my TikTok shop @Nadia Braeckel Books Cat

0 likes

Toxic hearts: marriage of convenience

Have you read Toxic Hearts yet? 💜 Enemies to friends to lovers 💜 Fake Relationship 💜 Marriage of Convenience 💜 Opposites Attract 💜 Age Gap 💜 Retired Military MMC 💜 Broken FMC 💜 Dark Secrets Then you’ll love Toxic Hearts! Also available at my TikTok shop Catch up on book 1, Toxic

7 likes

Toxic Hearts: marriage of convenience

The moment Melanie and Nick met was anything but cute—and that’s exactly why neither of them forgot it. Have you read Toxic Hearts yet? 💜 Enemies to friends to lovers 💜 Fake Relationship 💜 Marriage of Convenience 💜 Opposites Attract 💜 Age Gap 💜 Retired Military MMC 💜 Broken FMC 💜 Dark Sec

1 like

Excel conditional formatting

HR & People tool practical Excel application of conditional formatting #tutorials #template #excel #exceltricks #exceltraining

9 likes

Convenience at Your Fingertips: Sofa Arm

Convenience at Your Fingertips: Sofa Arm Clip Tray for Easy Access! . . #AmazonDeals #AmazonGadgets #SofaAccessories #AmazonFinds #HomeComfort #ClipTray #AmazonPrime #LivingRoomEssentials #SmartLiving #DailyFinds

24 likes

A purple folder displays a collection of Kuromi-themed sticky notes. The notes feature various designs including Kuromi characters, hearts, skulls, and patterned backgrounds in shades of purple, black, and white. They come in different shapes and sizes.

Convenience books

I saw these at walmart. People are already reselling them on ebay and etsy. If you are lucky enough to fund them just get them before resellers do. #BackToSchool #lemon8challenge #summervibes #lemon8contest #ThingsToDo

60 likes

The image is a title slide for "JAPANESE Convenience store SWIPE Phrases," featuring a stylized convenience store counter with a coffee cup and a drink icon. It introduces a series of useful Japanese phrases for convenience store interactions.

This image displays the phrase "Would you like to add a hot coffee?" in English, followed by its Japanese romaji translation "Hotto kōhī mo tsukemasu ka?" and the Japanese script, set against a convenience store counter background.

The image shows the English phrase "Do you need a bag?" with its Japanese romaji translation "Fukuro wa irimasu ka?" and the Japanese script, presented over a convenience store counter scene.

Phrases for a japanese convenience store

Do you need a bag? = Fukuro wa irimasu ka? Would you like to add a hot coffee? = Hotto kōhī mo tsukemasu ka? The restrooms are for customers only. = Toire wa okyaku-sama sen'yō desu. Card declined. Do you have another form of payment? = Kādo ga uketukerare masen. Hoka no shiharai hōhō wa

71 likes

Toxic hearts: marriage of convenience

Have you read Toxic Hearts yet? 💜 Enemies to friends to lovers 💜 Fake Relationship 💜 Marriage of Convenience 💜 Opposites Attract 💜 Age Gap 💜 Retired Military MMC 💜 Broken FMC 💜 Dark Secrets Also available at my TikTok shop @Nadia Braeckel Books Catch up on book 1, Toxic Wishes, her

5 likes

Excel automatic sort

Automatically sort spreadsheet as you type #tutorials #excel #friday #exceltips #exceltraining

10 likes

Thugging in front of the Convenience store on MPrd

Long live The King. 👑 Amen.⚡🌎💙🌎⚡ P.S. That word 'Thugging' I used means 'Team hugging'. #WezAFamily And #WeFriends #4Land4E 🖤❤️

2 likes

Toxic Hearts: marriage of convenience

Have you read Toxic Hearts yet? 💜 Enemies to friends to lovers 💜 Fake Relationship 💜 Marriage of Convenience 💜 Opposites Attract 💜 Age Gap 💜 Retired Military MMC 💜 Broken FMC 💜 Dark Secrets Also available at my TikTok shop @Nadia Braeckel Books Catch up on book 1, Toxic Wishes, her

1 like

Toxic hearts: marriage of convenience

Have you read Toxic Hearts yet? 💜 Enemies to friends to lovers 💜 Fake Relationship 💜 Marriage of Convenience 💜 Opposites Attract 💜 Age Gap 💜 Retired Military MMC 💜 Broken FMC 💜 Dark Secrets Then you’ll love Toxic Hearts! Also available at my TikTok shop Catch up on book 1, Toxic

0 likes

It's Time To Refill Our Little Convenience Store!

This time around I set up our little convenience store with a St. Patrick's Day theme & upgraded our snack display by adding the mini fridge. 🍀🍏🥝 #SnackRestock #StPatricksDay #HomeOrganization #VintageDecor #ThriftedFinds

323 likes

A hand holds several pink-spined romance novels, including 'Red, White & Royal Blue' and 'Practice Makes Perfect'. The image has a text overlay that reads 'marriage for convenience book recs', indicating a list of recommended books for this trope.

The book cover for 'Twisted Secrets' by Katee Robert is displayed. Surrounding text highlights its themes: 'Russian mafia', 'fast paced', 'dark', 'bad'ss fmc', and 'guilt from the past', suggesting a dark romance with a strong female lead.

The book cover for 'Between Commitment and Betrayal' by Shain Rose is shown. Keywords like 'enemies to lovers', 'forced proximity', 'spicy', 'king of dirty talk', and 'billionaire' describe the book's tropes, including a fake marriage.

marriage for convenience book recs

for my besties who love grumpy cold men with a soft spot only for them 😫🤌 plus the marriage for convenience trope 😮‍💨 #lemon8bookchallenge #lemon8bookclub #lemon8bookworm #book #booktok #bookaesthetic #booksoflemon8 #bookrecommendations #bookrecs

487 likes

Choose convenience, crush consistency

Making the gym easy to get to makes it easy to stay consistent. Start simple and set yourself up to win. #gymtips #fitness #fitnesstips #beginnerfitness #healthylifestyle

1 like

Toxic Hearts: Marriage of Convenience

Marriage was never in the plan. Neither was him. 💜 Enemies to friends to lovers 💜 Fake Relationship 💜 Marriage of Convenience 💜 Opposites Attract 💜 Age Gap 💜 Retired Military MMC 💜 Broken FMC 💜 Dark Secrets #booktokfypage #nadiabraeckelbookse #enemi

3 likes

Toxic Hearts: marriage of convenience

What’s a book quote that lives In your head rent free? #romancebooktok #romancebookrecs #romancereadersoftiktok #nadiabraeckelbooks #romanceauthorsoftiktok

3 likes

Live where Luxury meets Convenience! ✨🌸

Live where luxury meets convenience—high-end finishes, top craftsmanship, and shopping & dining just minutes away! #home #backyard #kitchen #luxury #design

838 likes

A vibrant red and black background with a Chinese flag features the title 'Learn Chinese Phrases' and 'phrase said by convenience store clerk', with a 'SWIPE' arrow indicating more content. The image promotes language learning.

Against a red and black background with a Chinese flag, the phrase 'We're out of stock on that item.' is displayed in English, Pinyin (Nà jiàn shāngpǐn yǐjīng mài wán le), and Chinese characters.

Set against a red and black background with a Chinese flag, the phrase 'Do you have a membership card?' is presented in English, Pinyin (Nín yǒu huìyuán kǎ ma?), and Chinese characters.

Chinese phrases of a convenience store clerk

How can I help you? = Nín xūyào shénme bāngzhù? Do you have a membership card? = Nín yǒu huìyuán kǎ ma? Would you like a bag? = Nín xūyào dài zi ma? Your total is 50 yuan. = Zǒngjì shì wǔshí yuán. Cash or card? = Xiànjīn háishi kǎ? The restroom is for customers only. = Cèsuǒ zhǐ xiǎn

9 likes

Meal Prep The Day Before For Better Convenience

#quickmeals #onthegomeals

3 likes

Convenience Stores In South Korea

GS25 in South Korea hits different! 🛍️ Affordable snacks, welcoming staff, and a vibe that lets you browse stress-free. Who else loves the convenience store life here? #gs25 #conveniencestore #cctv #korea #southkorea

368 likes

What $10 Gets You in Mexico’s Convenience Store

What $10 Gets You at OXXO, the most popular convenience store in Mexico! ❤️🇲🇽 Opened since 1977, Oxxo is a popular chain of convenience stores in Mexico, known for its wide range of products including snacks, drinks, and essentials. It’s often open 24/7 and is a go-to spot for many people looki

432 likes

I do covenant…forget your convenience!

I do covenant to choose obedience over convenience. To be still when movement feels easier. Because stillness is not inactivity — it is alignment. There is work happening in the quiet. There is work being done on your behalf. #BeStill #DivineTiming #FaithWalk #ObedienceOverConvenie

6 likes

Toxic Wishes: Marriage of Convenience

Have you read Toxic Hearts yet? 💜 Enemies to friends to lovers 💜 Fake Relationship 💜 Marriage of Convenience 💜 Opposites Attract 💜 Age Gap 💜 Retired Military MMC 💜 Broken FMC 💜 Dark Secrets Then you’ll love Toxic Hearts! Also available at my TikTok shop Catch up on book 1, Toxic

0 likes

The convenience of having Microlocs

✨ The best part about having Microlocs? The effortless styling! ✨ With just 2 minutes, a little fluff, and a quick flip, you’re ready to go! Whether it’s a busy morning or a last-minute outing, Microlocs keep it simple, stylish, and stress-free. Who else loves the convenience of Microlocs? Dr

71 likes

See more