Automatically translated.View original post

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

22.1K followers

Follow

Follow

Follow

313 saved

122

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

7418 likes

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

3820 likes

Bible Journaling 🤍📝

Here are some creative ways for the next time you are journaling in your Bible! Very cute and creative! Hope you enjoy 😊🤍

1433 likes

A laptop displaying a messaging app, a notebook with handwritten notes, a pen, and a glass with a red drink on a desk. The image has an overlay text that reads: 'how to take notes in AND out of class! + tips!'

A black slide titled 'Part 1: Note-taking tips' with white text explaining the importance of organized notes, focusing on main ideas, and using shortcuts for effective studying.

A black slide titled 'Part 2: Notes shortcuts' displaying a list of common abbreviations and symbols like 'w/ - with', 'b/c - because', '∞ - infinity', and '≥ - greater than/equal to'.

how to take notes 📝 in AND out of class! + tips! 📚

i’ve always struggled with taking notes but this will help you stay on track!! 🤍🤍 did you learn something new?? ☕🍂🧺🧸 #studytips #lemon8challenge #studyinspo #studying #studymotivation #notesupplies #notetaking #school #highschool #college

2187 likes

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

619 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

1546 likes

Anatomy questions

#anatomy #student #college #nursingstudent #study

27 likes

recommended school supplies as a senior in hs💕🍋✨

These are quite subjective, but it helps me do well in school and keep organization! 1. BOTH pastel and bright/neon highlighters🖍️: I’ve basically always hated the aesthetic of neon highlighters, but when used correctly they serve me so well for note-taking and studying. I use the neon highlight

5466 likes

The daughter despised by the entire village ultimately set the whole nation ablaze with excitement. #movie #film #fyp

0 likes

What Do Your Race Goals Actually Look Like?

Most ultrarunners start with the same baseline goal: Just finish. It’s honorable. It gets you to the start line and across the finish. But what happens when “just finish” stops being enough? For me, that shift happened when I realized I was getting bored. I had the fitness. I had the dedicati

3 likes

Do you Journal ? 📓 💜

Journaling for me is very healing and it’s a hobby I’ve had every since I was a little kid🥺📓I think as a adult I enjoy it so much because it gives HEALING ENERGY🌈💖It feels good to get my thoughts out on paper no matter how sad, crazy, or cheesy it sounds. #journalprompts #journalling #jour

1385 likes

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

181 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

146 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

how to ACTUALLY get into journaling

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

6396 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

31 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

1170 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

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

1276 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

894 likes

A personalized Bible with a gray cover and blue accents, featuring the text "Personalized Loaded Bibles Adrian Marcos" overlaid. It has blue ribbon bookmarks and is resting on a dark, furry surface.

A side view of the personalized Bible, showcasing its gray cover with blue accents and blue index tabs for books like Genesis, Exodus, Leviticus, and Numbers. Blue ribbon bookmarks are visible.

An open personalized Bible displaying a page titled "A Man of God" with character traits, and an illustrated page with a combine harvester in a field. Blue tabs are labeled with words like "Faith," "Anxiety," and "Wisdom."

@Cheyenne Lesperance Personalized Loaded Bible 💙🩵🚜🩵💙🚜 #personalizedbible #christianownedbusiness

13 likes

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

1422 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

3075 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 🌧️

548 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

4473 likes

A laptop screen displays the ChatGPT website, highlighted as an essential app for college students. The screen shows the 'What can I help with?' prompt, suggesting its utility for various academic queries.

A laptop shows a Google Docs class schedule and the 'Class Timetable' app icon. Text describes it for organizing schedules and class locations, aiding college students in managing their courses.

A laptop displays the 'Structured Daily Planner' app, emphasizing its use for organizing personal and college life, tasks, and events. The app interface shows a 'Study for Exam' entry.

Apps you need if your a college student

College life made easier! 📚✨ Here are must-have apps for students: stay organized with Struction, ace studying with Quizlet, manage deadlines on Google Calendar, and check your classes with Timetable! . Level up your productivity and make campus life stress-free! 💻🎓 #Lemon8partner #Lemon

831 likes

✨I’m Officially An Author✨

Hold on... because your girl is officially a published author! 🥹📖 To be real, this book actually happened by accident. I didn’t even set out to write it like this, but I stayed with it and turned it into a 40-day devotional. And look, I’m gonna tell you now…some of these days might make you say,

1 like

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

You’re Leaving Miles on the Table and Don’t Even Know It

I got 15,000 miles back on a flight I already booked. Didn’t call anyone. Didn’t complain. Just checked the price, canceled, and rebooked. Here’s the part nobody tells you. You have to go back and look. The miles don’t come back automatically. The airline isn’t going to email you when

1 like

How to take study notes: 5 effective methods

#lemon8diarychallenge Better notes will help you remember concepts, develop meaningful learning skills, and gain a better understanding of a topic. Effective notes will even lead to less stress when test time comes around! Learning how to take better study notes in class helps improve reca

55 likes

for all the people pleasers and overthinkers

entering our unbothered era one boundary at a time #boundaries #journal #peoplepleasing #overthinking #voicejournal

22 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

6 likes

How to Start Your eBook Design in Canva

Want to create your first eBook? Here’s how to get started with Canva! Canva has tons of ready-to-use templates. Search ‘eBook’ in the templates section, pick one that fits your style, and customize from there! Choose a color scheme that reflects your brand. Use Canva’s color picker or tr

44 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

Excel projects with a Gantt chart

Auto populate the Gantt style chart with name and color #template #excel #tutorial #friday #exceltips

11 likes

This room had too many styles fighting for attention—modern table, farmhouse art, colorful rug. I simplified by choosing one cohesive look: moody wallpaper + a color-drenched ceiling for drama, light neutrals to balance it out, and gold accents for warmth. Finished with greenery to tie it all toget

36 likes

How to Cope with Goldfish Memory 🌿

Some people are saying you don’t need to memorise the textbook, but that is not always true - I have sat tests that have been literally a memory exercise from a several hundred page textbook. Now, this is a terrible way to test student’s understanding, but sometimes that’s the game you gotta play.

53 likes

How to start time boxing with Notion

I don’t know about you, but in 2023, my entire life literally changed when I decided to go full-time with my business. Did I feel overwhelmed? Yes. But did I still manage to do (almost) everything I wanted to do this year? YES. 🚀 And can you guess what my secret weapon was? Time boxing! ⏰ So tha

242 likes

The highly requested editing tutorial for my DITL vlogs! #ditl #contentcreator #contenttips #contentcreatortips #editingtutorial #editingtips

51 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

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’

351 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

55 likes

A modern two-story new construction home with light siding and stone accents, a garage, and a driveway, under a clear sky. Text overlay reads 'SOLD' and 'Here's how I saved my clients $$$ on a new build'.

A kitchen interior with white brick backsplash and a stovetop. Text overlay informs that buyers have the right to realtor representation for new construction homes and do not have to pay the builder's list price.

A blurred interior background with text detailing how a realtor negotiated a new construction home deal, securing $6,000 below list price, a 4.99% fixed rate, $10,000 in closing costs, and $5,000 for upgrades.

How I saved my clients $$$ on their first home🗝️🤍

🏡When first buying a home it can be overwhelming! There’s so much you feel like you need to know and it’s probably going to be the largest purchase in your lifetime! 💰I promise it’s not as difficult as it may seem! And there’s ways that a Realtor can help you save some cash! 🗝️If you’re

704 likes

My top 5 Canva apps

There are so many Canva apps I use. These are my top 5! Follow me for more. #canva #canvatips #canvahack #canvadesign #canvatutorial

6 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

200 likes

Bible color coded!

such a cute and helpful way to see the different genres of books in the bible! #biblecolorcode

870 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

333 likes

You need to start using the NOTES app like this

Here’s how to turn basic notes into your personal command center: Lines + grids: Perfect for keeping your handwriting straight, whether you’re jotting with your Apple Pencil or making a clean to-do list. Colored text: Add personality, highlight important info, or just make your notes less borin

253 likes

A promotional image featuring a woman with text overlay that reads: 'Ultimate office software Cheat Sheet can leverage your career. Get PDF from valder.org'. The image also includes 'lemon8 @wuvalder' branding.

A 'Custom Guide Microsoft® Excel 2021 Basic Quick Reference Guide' cheat sheet, detailing the Excel program screen, keyboard shortcuts, general navigation, getting started, editing, and formatting options.

A 'Custom Guide Microsoft® Excel 2021 Intermediate Quick Reference Guide' cheat sheet, illustrating chart elements, chart options, various chart types, and instructions for creating, modifying, printing, and distributing charts.

my ultimate office software cheatsheet

Let me tell you a little secret: I used to be that person who Googled every single Excel formula, struggled with PowerPoint layouts, and spent way too much time formatting Word documents. Sound familiar? 😅 But then, I decided to take control. I printed out these Ultimate Cheat Sheets for Excel, Po

59 likes

See more