Automatically translated.View original post

ひろ | 定時退社のExcel時短術

22.1K followers

Follow

Follow

Follow

307 saved

130

1

Table headings can be fixed with this

Follow those who want to save more time ↓

@ hiro.shigotojutsu

─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─

Can you use this time shortening technique right away?

It seems to be usable immediately! ▶ ︎ 💯

Take your time! ▶ ︎ 💪🏻

It seems to be no good at all ▶ ︎ 😭

Let me know in the comments!

─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─

Fulfilling your life from work

@ hiro.shigotojutsu

─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─

# Excel Convenience

# excel _ beginner

2025/7/31 Edited to

Excelで見出し行を固定する機能は業務を効率化する上で非常に便利ですよね。私も最初は複数行の固定ができないと悩みましたが、ウィンドウ枠の固定メニューで柔軟に設定できることを知って解決しました。特に、\"ウィンドウ枠の固定\"を使うと、先頭行だけでなく複数行や列も固定可能です。操作は「表示」タブの\"ウィンドウ枠の固定(E)\"から選択するだけ。例えば、出勤表のようなデータをスクロールしても名前や日付の見出しが常に見えるため、入力ミスも減ります。また、ツールバーや数式バーの表示・非表示も編集画面の見やすさに影響するので、必要に応じて設定を見直すのもおすすめです。固定状態は解除も簡単で、状況に合わせて使い分けられます。私は実際にこの方法で事務作業の時間を大幅に短縮でき、エクセル初心者の同僚にも喜ばれています。ぜひ皆さんも自分のデータに合わせて見出し固定を活用してみてください。初めは慣れが必要ですが、慣れると作業効率がアップすること間違いなしです！

Related posts

A study setup featuring a tablet displaying apps, a pink drink in a clear cup, pens, and a notebook with handwritten notes. The image is overlaid with the text 'Lazy Girl COLLEGE HACKS' and 'GET A HIGH GPA WITHOUT TRYING SO HARD'.

A student in a lecture hall, seen from behind, attentively listening to a professor. Yellow arrows point from the student's head towards the professor, emphasizing focus on the lecture.

An open spiral-bound textbook with colorful tabs and highlighted sections, illustrating the concept of skimming. A yellow arrow points to a specific page.

Lazy Girl College Hacks: 9 Tips for a Higher GPA📚🎓

Yes, I know “why is Chalie posting college content?” I’m here mainly for fitness advice and everything health-related, but I’m also a lifestyle account—and a big part of my life is being a college student and let’s be real—college can be overwhelming, especially when it feels like there’s a never-e

7470 likes

A dining room with a wooden table and chairs, featuring a white text overlay that reads "WHY YOUR HOME LOOKS BAD And How to FIX IT."

A close-up of a sofa with pillows, accompanied by text stating "Just because we have the space, doesn't mean we should fill it. #1. Too much stuff."

Four panels illustrating correct and incorrect curtain placement, showing how to hang curtain rods high and wide, and use wide rods to avoid covering windows.

Does your home look bad? How to fix it!

I see a lot of people on here asking for interior design and decorating advice, here you go! 1. Declutter! Majority of people have way too much stuff. If you are not using it, shoving it in a closet somewhere won’t make you use it more, get rid of it. 2. Curtains hung wrong or lack of curta

3834 likes

A handwritten guide on a grid notebook, titled "ORGANIZING NOTES! HOW TO WRITE NOTES AS A NON NEAT HANDWRITER." It illustrates 5 tips: using titles, headers, bullet points, indentation, layouts, doodles, and arrows to organize notes effectively.

A handwritten list of vocabulary words and definitions on a lined notebook page. A pink handwritten text at the bottom advises, "WRITE THE NOTES W SPACES AS NEEDED," demonstrating a note-taking strategy.

A handwritten vocabulary list on a lined notebook page, with "VOCABULARY" as a pink heading. Pink text at the bottom instructs, "PICK A THEME COLOR AND USE THE PEN TO WRITE HEADINGS/TITLES."

HOW TO WRITE NOTES AS A NON NEAT HANDWRITER

Easy note taking. #notes #school #notetaking #loose notes #easynotetaking

901 likes

A person's hands are shown studying math with an open textbook, a pencil, and a notebook. The image has text overlays "how to study math" and "SWIPE FOR MORE", indicating a guide.

A digital note titled "How to study Math" lists tips: "Understand the Basics," "Organize Your Notes," and "Practice Regularly," with bullet points explaining each.

A digital note titled "How to study Math" continues with tips: "Draw Diagrams and Visualize," "Read Textbooks Carefully," "Consistent Study Schedule," and "Understand the Why."

How to Study Math 📐🧮

Studying math effectively involves a combination of understanding concepts, practicing problem-solving, and developing good study habits. Here are some tips to help you study math more efficiently. Bonus Tip: 🗣️ Ask for Help. Don't hesitate to ask your teacher, classmates, or online forums

3071 likes

An overhead view of a desk with open notebooks, pens, markers, and a tablet, featuring the title "HOW TO TAKE NOTES EFFICIENTLY in & out of school # 4 tips #."

A graphic titled "STUDYING 101 HOW TO STUDY MORE EFFECTIVELY!" detailing the first tip: "1. Record Key Points," with sub-points on focusing on concepts, using abbreviations, and color coding.

A graphic titled "NOTE-TAKING METHODS" presenting the second tip: "2. Choose a Suitable Note-Taking Method," illustrating Cornell, Mind Mapping, Outline, and Charts/Diagrams methods.

How To Take Notes Efficiently | 4 Tips✨📝

#notesguide #notestaking #studytips #Lemon8

1278 likes

how to ACTUALLY get into journaling

you GOT this! thanks to carrie walker for a lot of these suggestions 🫶🏼 #journaling #writing #MentalHealth #mentalhealthtips

6442 likes

A black and white image with the title "SPIRITUAL WARFARE what the enemy says VS what God says" over a blurred background of people with raised hands, suggesting worship or prayer.

A black and white image listing "3 things the enemy says," detailing how the enemy steals, kills, destroys, and fills heads with lies, with quotes from Louie Giglio.

A black and white image listing "3 things God says," emphasizing worship as warfare, praise as purpose, and being equipped to rebuke, with Bible verses from Psalms.

SPIRITUAL WARFARE

this topic is huge in a Christians life! we are constantly battling the enemy throughout the day and so it’s important to remember that God is in control and is fighting battle after battle for us because He loves and cares for us! i recently spoke on this topic with my worship team at church and t

1172 likes

A tablet displaying Goodnotes settings for public speaking notes, showing Marker Felt (Thin) font with title size 38, headings 25, and regular text 21 points.

A tablet displaying Goodnotes math notes on linear functions, showing typed questions and handwritten solutions using the pen feature, as described for calculus.

Steal my Goodnotes settings

This is my first year using goodnotes for all of my classes and so far I am really enjoying it! I have found settings/formats that work very well for me and I was hoping to share them with Lemon8. I have a different folder for each class with varying notebooks/folders inside depending on my

1563 likes

A computer screen displays templates for a monthly meal planner and budget, with text overlayed: 'HOME SKILLS no one teaches you.' The screen is set against a background with framed artwork.

A close-up of a computer screen shows a detailed monthly budget spreadsheet. Text highlights the importance of creating a budget for monthly and irregular expenses, suggesting automatic payments or reminders.

A wall calendar for December 2025, featuring a puppy, hangs on a refrigerator. Text advises using one main calendar to schedule appointments, deadlines, and social plans, grouping errands for efficiency.

The Hidden Skills That No One Teaches Women!! 📊✨

There are so many skills involved in running a life and a home that are completely invisible. No one formally teaches them, they’re rarely praised, and yet women are often expected to “just know” how to do them and do them well! 1. Budgeting Is More Than Math 📊 Budgeting isn’t just about knowin

670 likes

💎 your design is rare 👽

💎 You carry a design that very few will truly recognize... 👁 You didn't stumble on this by accident Nothing you do is by accident anymore — you know that... You've fallen down so many times you lost count You've gotten back up in silence No applause No one checking on you

0 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 study desk with a pegboard and books, featuring text overlays 'LAZY GIRL COLLEGE HACKS' and 'GET A HIGH GPA WITHOUT TRYING SO HARD,' accompanied by a bee and crown graphic.

A study desk background with the text 'Stop Taking Notes. Start Listening.' and a paragraph advising to focus on lectures and review slides later for detailed notes.

A study desk background with the text 'Record Now, Review Later' and a paragraph suggesting recording lectures to revisit and replay key parts at one's own pace.

Study tips for LAZY GIRL 🥰🥰

#backtoclass #studytipsdaily #studyinghacks #studyskill #summerbod

1419 likes

Name cells in excel

Customize and store headings in Excel #exceltips #tutorial #exceltraining #exceltricks #exceltutorial #excelforbeginners #learn Takw my Excel class xecutethevision.com#onthisday

32 likes

Improve your notes: key aspects✨🌸

Want to make your notes more effective and organized? Here’s a guide on the key aspects every set of college notes should have! From using clear headings with chapter numbers to organizing content with comparison tables and subheadings, I’ll show you how to structure notes that make studying easier

148 likes

the next time you edit… learn this hack ✨✨

Today’s the last day of CapCut Club with Steph and today I’m showing you how you can bookmark you favorite text and sound effects when you’re editing to save time! ✍️✍️✍️ #contentcreator #creator #creators #editinglife #letschat

20 likes

An iPad displays Goodnotes with notes on 'Surface area,' titled 'MY GOODNOTES SETTINGS.' The image introduces an overview of Goodnotes settings for note-taking, featuring a pink cursor and a cowboy hat emoji.

An iPad screen shows Goodnotes with the pen selection menu open, highlighting 'Ball Pen' as the preferred writing tool. The text 'ALWAYS use ball pen!' emphasizes this choice for efficient note-taking.

An iPad displays Goodnotes 'Stroke Settings' with a pen thickness slider set to 0.2 mm. Handwritten examples below show pen thicknesses of 0.2 mm, 0.3 mm, and 0.5 mm, with 0.5 mm marked as the most used.

goodnotes digital note taking 💡✏️✨

Hello everyone! Here is my overview of my goodnotes settings that I use to take notes with! Ball pen: I tend to always stick with ball pen as this is the setting that allows me to write efficiently and more like my normal handwriting. Fountain pen/brush pen are great for creating your own title

4482 likes

Don’t ask if you are not willing to allow ✨

#books #to #read #jerryhicks #estherhicks The teachings of Abraham : learning to manifest your desires New to Lemon8! Something I love：I love the sound of rain 🌧️

552 likes

A desk setup with a laptop displaying a document, a white keyboard, and printed papers, illustrating a nursing student's study environment. Text overlay reads "How I study for nursing school @Babyitsgeni."

How I study for nursing school

I create a Word document that begins with the class and exam I’ll be studying for. I include the topic of the week to identify what I should focus on more based on the exam (though I do read everything to ensure comprehensive understanding). I make sure to include the headings from the PowerP

141 likes

SPOILER ALERT! All’s fair Dina vs Carr. No lie Dina was wrong as hell for what she said about carr at that table and they should of fixed the script writing for their relationship. #allsfair

1 like

Tips for TYPING NOTES 💻

Do you prefer writing or typing notes? Use • bullet points and - lists: easily highlights information with a method that usually takes up a lot of space but when using a computer, you got plenty of space Use Headings: structure and organization baby 🙌🏻 Use tools like Bolding and Underli

180 likes

The image displays anatomy questions for '1. INTRODUCTION', covering essays on epithelial tissue, short notes on connective tissue fibers, fibroblasts, macrophages, and differences between muscle types, elastin & collagen, and inversion & eversion.

The image presents anatomy questions for '2. RESPIRATORY SYSTEM', including essays on the respiratory system and lungs, short notes on diaphragm, nose, paranasal sinuses, trachea, pleura, and differences between trachea & bronchi, and left & right lung.

The image shows anatomy questions for '3. DIGESTIVE SYSTEM', with essays on stomach anatomy, short notes on appendix, oesophagus, tongue, intestines, liver, anal canal, parotid gland, and differences between small & large intestine, duodenum & ileum, and oropharynx & nasopharynx.

Anatomy questions

#anatomy #student #college #nursingstudent #study

27 likes

Overall, I’ve enjoyed Notability better for school note taking! ✨Better Organization: I don’t have to flip through tons of pages to find what I’m looking for. With dividers and sections, I can easily find notes I need to review. ✨My handwriting looks better. This is probably my biggest reason!

5415 likes

✨ Elevate Your Journals & Planners with Canva

Looking to make your digital or printable journals and planners more aesthetic & creative? Two trending Canva elements—Paper Cuts and Ripped Paper—are perfect for adding texture, depth, and personality to your designs! 🎨 Why Use These Elements? ✔️ Paper Cuts – Clean, layered shapes that a

466 likes

How to Annotate / Study YOUR Bible (pt. 1)

#lemon8dairy #annotatedbible #beginnersbible #bible #howtostudythebible

233 likes

A notebook with handwritten history notes and a pen, featuring an overlay that reads "Study Techniques" and "MAKE STUDYING FASTER." A paper with "RECORD FRAGMENT" is also visible.

A notebook with handwritten notes in the background, overlaid with a white box detailing the 5-step "Blurting method" for studying, including choosing a topic and recalling information.

A notebook with handwritten notes, featuring a white box overlay explaining the 5-step "Mind mapping" technique, from starting with a central idea to showing relationships.

Quick Study Techniques

One of my favorite things to do in school was to try out study methods to find out which one works best for me so I am loaded on studying tactics My goal is to give these tactics to you so you can find out what works best personally for you Have you tried any of these tips? What works best f

341 likes

A notebook open to a page of handwritten chemistry notes, featuring purple highlights and headings. A pen rests on the page, with text overlays reading 'take notes with me' and 'aesthetic notes study inspo'.

A close-up of chemistry notes titled 'Chapter 1: Basic Concepts (atoms)'. The section 'Discovery of Atomic Structure' is highlighted in purple, detailing experiments by JJ Thompson, Milliken, and Rutherford.

A close-up of chemistry notes explaining atomic mass, isotopes of hydrogen, and an atomic symbol diagram. A purple Mildliner and a grey Gelly Roll pen are shown below the notes, used for writing equations.

how to take aesthetic notes💜📝

I love taking cute notes! It’s a fun way to study and romanticize studying! This is how I do my simple but cute notes: 💜pick a color for your class! I chose purple for inorganic chemistry! Make sure to have a highlighter and gel pen in this color. Also get a black and grey pen! Right now I’

357 likes

Things the schools don’t teach part 1

#kidslifeskills #momsoflemon8

87 likes

breeze through textbooks with these techniques 📗🤍✨

breeze through textbooks with these techniques 📗🤍✨ - SQ3R (my personal favorite) - PQ4R i am someone who DESPISES reading textbooks. i would rather write a paper than read a chapter because i find it so boring, so it’s important to me that i learn chapters quickly and efficiently. these are

556 likes

A laptop displays a digital planner interface, featuring a weekly schedule, a Pomodoro timer, and a motivational quote. The screen shows sections for daily tasks and a progress bar, set against a cozy background with a red and white checkered pillow.

Two screenshots of the xTiles digital planning interface are shown. The top image displays a weekly planner with a Pomodoro timer, while the bottom image features a 'Dream Life' section with identity and affirmation prompts.

A detailed view of the xTiles weekly planner shows daily tasks for Monday through Thursday, separated into work and personal categories. A Pomodoro timer widget is prominently displayed on the right side of the screen.

organize your life & reach goals w xTiles!! 🌟🌟

If you know me, you know I'm always on the hunt for ways to organize my life! SO - wanted to share with y'all how I've been organizing with xTiles! xTiles is a super easy and flexible Notion alternative that I've been able to build my planning/notes/goals into. What I love: ❤️Eas

91 likes

Google Docs for Students

We don’t talk enough about the small digital skills that make a huge difference. Google Docs is more than just a typing space it can boost your productivity, collaboration, and confidence as a student. Here are my favorite tools: 🧠 Voice typing = notes while you talk 📑 Insert a table of co

205 likes

Capella University RN-to-BSN, 4055 Assessment 3

Capella University RN-to-BSN, 4055 Assessment 3: Disaster Recovery Plan #nursingstudent #nursingschoolstudytips #assignments #capella #nursinggraduate

2 likes

Plan with me Week 8: Birthday Week 🥳

We’re going to ignore that I’ve been M.I.A for almost a week 🥴 Life was Life-ing but We Back Now 🥰 Just in time for my Birthday Week 🥳 so #planwithme in my #kinbor / #hobonichiweeks style planner. Birthday Stickers from Walmart Kinbor Planner from AliExpress Zebra Pen USA MildLiner

94 likes

Bathroom Trash Can with Lid

Bathroom Trash Can with Lid, Plastic 3 Gallon Garbage can with Press top Lid Gold Step Pedal Trash can, Narrow White Trash bin for Bathroom, Bedroom, Restroom, Living Room, Office, Dog Proof Trash Can. #amazon #amazonfinds #amazonmusthaves #lemon8bookclub #amazonfinds United States

50 likes

A laptop and an open textbook on a desk, with the text overlay "STUDY TIPS WHAT TYPE OF LEARNER ARE YOU?" and a lightbulb icon.

A person studying with a laptop and an open book in a cafe setting, with the text overlay "LINGUISTIC LEARNER".

A close-up of a pen resting on a stack of printed papers, with the text overlay "LOGICAL LEARNER".

What type of learner are you?

What good is studying if you’re not studying the right way for YOU? Everyone processes information differently, therefore everyone studies differently. This is a lesson that took me a VERY long time to learn. For years I’d study using flashcards and would get so frustrated when I wouldn’t l

62 likes

A pink mechanical keyboard with a notebook open to handwritten notes on networking and data structures, illustrating the concept of ditching physical notebooks for digital note-taking.

A digital note-taking application interface displaying organized notes with highlighted headings, bullet points, and sections on company settings, data structures, and arrays, demonstrating digital note creation.

A screenshot of a digital note-taking application's view settings, showing options to customize the appearance of notes with various rule lines and page colors to mimic real paper.

How to Take Digital Notes without an IPad 📝

You don’t need fancy tools to create digital notes worth reviewing. If you already pay for or have Office 365 - then you have OneNote! If you don’t have the suite already then no worries. The best thing to use is what you have! Most schools offer it for free or heavily discounted. (I don’t

548 likes

✨⌨️Word Hacks To Type Like A PRO | SAVE FOR LATER🗂️✨

✨ Want to cut your writing and editing time in HALF? These Microsoft Word shortcuts will help you work smarter, not harder! Whether you're a student, professional, or writer, knowing these time-saving hacks can make all the difference. ⌨️ Here's a few essential shortcuts you NEED to kno

103 likes

A close-up of a pen resting on a notebook with handwritten notes, featuring the title 'Master Your Study Game' and 'TIPS TO ORGANIZE YOUR NOTES' in prominent text overlays.

An open spiral notebook with lined paper and colorful markers, illustrating the tip 'Use a consistent format' to make notes easier to read and understand.

A fountain pen on an open spiral notebook, highlighting the tip 'Create a system for organizing your Notes' by using different notebooks or folders for subjects.

Ace Your Exams With These Note Organization Tips 📝

Sure, here are some tips on how to organize your notes for better studying: 📑 Use a consistent format. This will make your notes easier to read and understand. Consider using different colors for headings, subheadings, and bullet points. 📝 Create a system for organizing your notes. This could

239 likes

I stopped crawling under the table for this 😅

I didn’t realize how annoying my setup was until I fixed it. Having to crawl under the table every time my phone died was not it. This just made everything so much easier and actually usable. ✨️LINK IN BIO✨️ #lemon8home #homehacks #lifeeasier #momlife

2 likes

A person's hand writes notes in a notebook with a pen, with the text overlay "TOP 3 STUDY METHODS" highlighting the article's theme.

A laptop and notebook display notes, illustrating the "Spaced practice" method with a schedule for reviewing material over time.

A notebook with handwritten notes and a pen, detailing the "The SQ3R method" for reading comprehension, including steps like Survey, Question, Read, Recite, and Review.

STUDY METHODS 📖📚🎒

If you have to study, but don’t know how to approach your studying, I’ve compiled my top 3 best study tips for you: 1. Spaces practice 2. The SQ3R 3. Study before bed I love to study before bed because it gives me something to think about while heading to sleep! It makes me tired and I hav

1376 likes

The image displays a computer screen with a word processing document open, featuring the title 'How I Take Notes for Readings as a Doctoral Student' in blue text, introducing the topic of the post.

The image shows a computer screen with a word processing document, displaying the note-taking tip: 'Create sections for each new chapter, article, or book you have to read.'

The image shows a computer screen with a word processing document, displaying the note-taking tip: 'Do an initial skim of the readings and list out main topics. Usually they list these in the introduction or as paragraph headings.'

How I Take Reading Notes as a Doctoral Student

My top note-taking tips #lemon8college #studytips

7 likes

See more