Automatically translated.View original post

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

7385 followers

Follow

Follow

Follow

7 saved

3

How to fix rows and columns! How to keep headlines hidden even when scrolling

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

Today, I introduced how to fix rows and columns so that the heading is not hidden even when scrolling ✨

I would be happy if you could send your requests and comments to comments / DM 😊

11 hours agoEdited to

Related posts

✨✍🏾HOW TO: Structure Your Notes PERFECTLY📝✨

✨ Ready to level up your notes? Whether you’re studying economics, accounting, business, psychology, language, physics, or chemistry, I got you! I’m sharing note-taking templates designed to help you stay organized and actually understand what you’re learning. 📝 Here are a few hacks to make your

6562 likes

Excel shortcuts every student should know! 👩🏻‍💻

Stop Wasting Time: Master These Excel Formulas for Maximum Efficiency! 🕒 If you’ve ever struggled with Excel, mastering formulas can seriously up your game. Here’s a breakdown of the essentials that’ll make you look like a pro 1.Core Calculation Formulas 🧮 These are the basics you can’t live

1175 likes

Guide to havingAestheticAnd productive Notes

Guide to having aesthetic notes!! #hellolemon8 #aesthetic #notes #school #educationtips #schoolnotes #aestheticnotes #guide #cute #productive

4630 likes

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

#periodictable #study #learning #science

363 likes

4 easy steps to make progress chart in Google Shee

4 easy steps to make progress chart in Google Sheets #googlesheets #googlesheetstutorial #exceltips #digitalplanner #googlesheetstips #excel

625 likes

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

This is a must visit in Istanbul!

Location details👇🏼 Imagine stepping underground into a dimly lit, ancient water reservoir, where towering columns rise from the depths, and the sound of dripping water echoes around you. 📍Basilica Cistern—one of Istanbul’s most magical and mysterious sites. Originally built in the 6th cen

8000 likes

A Harvard-approved resume template is displayed, featuring a clean, single-column layout with sections for education, professional experience, leadership, and additional information, emphasizing a standard, easy-to-read format.

A person takes a mirror selfie, with overlay text stating "Standard one column format with black & white text," illustrating a key resume formatting tip.

An interior shot of a building with a "MERCURY" sign, accompanied by overlay text advising "Bullet points focused on results rather than responsibilities" for resume content.

Are you using an ATS-friendly resume template? 📃

The top universities in the world are teaching their students to use a standard resume template like this one, because it actually works! I remember paying $6 for a fancy resume template with cute pink accents on it from Etsy back in college. It had two columns and the information was hard to re

347 likes

A tablet displays a colorful Google Sheet with various data, set on a desk with study supplies. The image highlights the title 'THE GOOGLE SHEETS SHORTCUT THAT FEELS ILLEGAL' and promotes swiping for more content.

This image illustrates two Google Sheets shortcuts: 'SHIFT + ALT + →' for grouping rows, shown with a Chinese vocabulary list, and 'CTRL + ALT + M' for adding comments to cells, demonstrated with a text box.

This image presents two Google Sheets shortcuts: 'CTRL + ALT + SHIFT + H' for opening version history, shown with a date, and 'Ctrl + D' for filling down content, illustrated with copied text about Tetanus.

🧠 Google Sheets Hacks That Saved My Study Life

🔀 SHIFT + ALT + → Group selected rows or columns This shortcut lets me group and collapse chunks of data: like entire weeks of plans, so I can focus without getting overwhelmed. 💬 CTRL + ALT + M Add a comment to a cell I use this to leave mini reminders like “Revise this before the test” o

503 likes

A Google Sheet displaying an assignment tracker with columns for Class, Assignment, Date Due, and Done. Rows are color-coded by class, and some assignments have checked boxes in the 'Done' column, indicating completion.

A Google Sheet showing a list of Accounting assignments with due dates and checkboxes. An overlay text reads, 'Add all of your classes and assignments!', illustrating the initial setup of the assignment tracker.

A Google Sheet screenshot with the 'Insert' menu open, highlighting the 'Checkbox' option. An overlay text states, 'Add checkboxes to help you get things done!', demonstrating how to add checkboxes for tracking progress.

How I organize my assignments!

Hey there! I'm currently a junior studying at the University of South Florida. I totally get how overwhelming school assignments can be, but I've found a system that works for me! My friends have even commented on how helpful my assignment checklist is, so I thought I'd share it with yo

2107 likes

Beginner tutorial for a daily planner on Notion 📝☀

455 likes

100 Excel Tips The best Shortcuts, Formulas, Formatting & Advanced Tips Bookmark this, you'll save 1,000 of hours! A list of tips that all professionals need. Here is a preview: ⌨️ Shortcuts 1. How to hide a column? Ctrl + 0 2. How to hide a row? Ctrl + 9 3. How to

1429 likes

An outdoor dining scene with people seated at tables, featuring the overlaid text "Freeze the Top Row in Excel." A purple glass is visible in the foreground on a black mesh table.

A light beige background with black text asking, "Do you ever have hundreds of rows of data and when scrolling down, you loose sight of the column header and forget which column/field is which?"

A light beige background with black text stating, "This is when freezing your top row is crucial! I will show you how!"

HOW I FREEZE THE TOP ROW IN EXCEL

The ability to freeze that first row of my column headers has been a lifesaver, allowing me to scroll through thousands of rows of data without losing sight of my column headers/fields. By simply selecting the row below the one you want to freeze, heading to the "View" tab, and clicking

105 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

A completed Sims 4 build featuring an above-ground pool with a patio, outdoor kitchen, and lounge area, all under a decorative pergola. The image includes text overlays indicating it's a guide for building a simple pool in The Sims 4.

Step 1 of building a Sims 4 pool, showing the raised foundation. It consists of one flat square section and two rounded pool sections, both raised six times, with dimensions indicated as 8x7.

Step 2 of building a Sims 4 pool, illustrating the addition of four columns, a fence of choice with planters, and stairs leading up to the raised patio and pool area.

3 Easy Steps To Build A Pool In The Sims 4✨

A simple but cute above ground pool and patio. In the pictures I laid out all objects you’ll need to build this. I would love to see what you all come up with once yours is decorated. No this build is not available on the gallery, that’s why I showed you how to make your own 😁 as always, Happy Simm

1351 likes

A computer screen shows a Finder window with 'Documents' selected and the 'Electronic Arts' folder highlighted, with a pink overlay instructing to 'First open documents and click on EA file'.

A computer screen shows a Finder window with the 'Electronic Arts' folder open, highlighting 'The Sims 4' folder, with a pink overlay instructing to 'Then click on sims 4 file'.

How to add sims 4 mods and cc

There were a couple of questions asked about how to add mods and cc to the game and this should help. There are a few more details that I will post on part 2. #sims4 #sims4cc #sims4mods

1024 likes

How to Make Decisions + Journal prompts ✍🏻

Do you have a hard time making decisions? Journaling can help you! By eliminating uncertainty and working through the process of making a choice, this can be a great idea if decision making is something that you find hard to do. Here's how you can start: - Have a separate journal for

241 likes

Excel differences in columns

Find the differences between these columns in Excel with these Excel tricks #excel #exceltraining #exceltips #excel _learning #tutorial #excel_learning #excelforbeginners #fyp

36 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

Free Online MATH Courses!!

🧮 If math has you stressed, don’t worry, these free courses make it so much easier to learn! From algebra and calculus to linear algebra and stats, I’ve got you covered with the best resources. ✏️ Drop a ❤️ if you're ready to learn, and follow for more tips to help you crush your classes! 📚✨

933 likes

How To Make A Simple Content Planner on Your iPad

Here’s an easy way to make a content planner on your iPad to help you organize your content. This will be a simple, generic tutorial (you can customize it further). 📅 You will need to download Google Sheets from the App Store for this planner. 📅 Once you have Google Sheets installed, your fir

234 likes

A hand holds a stack of self-help books outdoors, featuring 'Rich Dad Poor Dad' by Robert T. Kiyosaki prominently. Other titles include 'Tuesdays with Morrie' and 'Atomic Habits'. Text overlays indicate 'Self-help book recommendations' and a discussion about 'Rich Dad Poor Dad'.

A book page titled 'Chapter Two LESSON 2: WHY TEACH FINANCIAL LITERACY?' from 'Rich Dad Poor Dad'. The highlighted text reads: 'It's not how much money you make. It's how much money you keep.'

A book page titled 'Chapter Seven OVERCOMING OBSTACLES' from 'Rich Dad Poor Dad'. The highlighted text states: 'The primary difference between a rich person and a poor person is how they manage fear.' The page also lists obstacles like fear and cynicism.

Book that you should have at home

#selfhelpbooks #lemon8challenge #healing #richgirlaesthetic #mindset #mindfulness #books #bookaesthetic #aesthetic #lifestyle "Rich Dad Poor Dad" by Robert Kiyosaki explores personal finance through the contrasting lessons Kiyosaki learned from his own "poor dad&

362 likes

A hand writes in a spiral notebook with a pink pen, illustrating the start of building good study habits. A white keyboard and monitor stand are visible in the background, setting a study scene.

A desk setup features an iPad displaying detailed notes on engineering data and mathematics, alongside a black keyboard and pink mouse. The image emphasizes studying at the same time daily to build focus.

Two spiral-bound planners, one pink non-dated weekly planner and a floral one, are shown on a desk. This image illustrates the habit of setting daily goals and writing down study objectives.

These Are What GOOD Study Habits Look Like!

Good study habits don’t just happen, they’re built with small, consistent changes that make studying more effective and less overwhelming. One of the best ways to start is by sticking to a routine. Studying at the same time every day trains your brain to associate that time with focus and productiv

200 likes

Excel drop it function

Remove columns and rows using drop in excel. #exceltips #excel #exceltutorial #businesstips #business #tutorial #boss #spreadsheet

20 likes

The first image is a laptop screen displaying 'LEARN SQL FOR BEGINNERS PART 3' as part of a guide titled 'How to become a Data Analyst'.

This image illustrates an SQL query using `WHERE major = 'Biology'` to select specific rows from a `students_table`, showing the filtered result with only Biology majors.

This image demonstrates an SQL query using `WHERE major = 'Biology' OR major = 'History'` to filter a `students_table` for multiple majors, showing the combined result.

Swipe if you’re a beginner & want to learn SQL!

In this post, we'll learn how to select specific rows from your table using a WHERE statement. As a recap, we've already learned about a few other statements, and we know that the statements have to come in a specific order. Only the SELECT and FROM statements are required. Here's

371 likes

A student is slumped over a desk with homework papers and a binder, illustrating the exhaustion of last-minute study. The image is titled 'How to finish homework last minute'.

A phone screen displays an active 6:00 AM alarm, illustrating the tip to 'wake up before school hours to finish hw' for last-minute homework.

A phone screen shows a text message asking a friend for homework, illustrating the tip to 'ask a friend for a copy' when finishing homework last minute.

How to finish homework LAST MINUTE ⏰

Sometimes im so lazy to do my homework and i wait until the last very last minute and I start panicking 😵‍💫 however I still manage to finish it 🙌 here’s some tips that can help 😏 ⏰ wake up before school hours to finish task ⏰ ask a friend for a copy ⏰ skip class (last min resort ⚠️) if it

497 likes

The image is a cover slide titled "MASSIVE ACTION PLAN Amy Landino How To Stay Focused & Get Things Done," revealing 9 takeaways. It features a desk with a pink planner, laptop, flowers, and earbuds, indicating a productivity theme.

This slide, numbered 1, advises to "Create clarity by listing desires." It explains that listing all desires without judgment helps understand personal goals, set priorities, and allows for genuine self-reflection.

Slide 2 focuses on prioritizing the top three desires for focused action. It suggests selecting these desires to concentrate efforts, enhance productivity, prevent overwhelm, and increase the chances of success.

How To Stay Focused & Get Things Done

Just watched this amazing video from Amy Landino. Sharing my summary note and hope it helps you too. ❤️ Like this post if you want to see more summaries like this. 1) Create clarity by listing desires. 2) Prioritize top three desires for focused action. 3) Set deadlines for achieving to

38 likes

🎀 💰 How to track finances in notion!

‧°𐐪♡𐑂°‧₊ Hey 👋🏼 I wanted to share a really simple & easy way to keep track of your income, expenses and/or savings using notion! Notion is a flexible tool that can really do anything you want, if you make it! To create a finance tracker, I usually create 3 separate tables for expenses, income

205 likes

A desk setup with a person's hands on a white keyboard and mouse, a monitor, and a laptop. Overlay text reads '3 MISTAKES TO AVOID when studying LEARN MORE', introducing common study errors.

An open spiral notebook filled with handwritten notes on engineering methods and programming concepts, with a pink pen resting on it. Overlay text highlights '1 Cramming Spreading out study sessions leads to better retention.'

A desk with a black keyboard, a pink mouse, and a tablet displaying complex mathematical equations and matrices. Overlay text advises '2 Multitasking Focus on one subject at a time for consistent better results.'

Do NOT Do This While Studying!!

We’ve all been there, spending hours studying but still not getting the results we want. The truth? It’s often not how much you study, but how you study. Avoid these common mistakes to make your study time way more effective. Cramming Trying to learn everything the night before a test might fee

106 likes

A tablet displays digital math notes on a grid background, covering topics like Gaussian Elimination and RREF. The overlay text reads "how to take better notes," suggesting a guide to effective note-taking strategies.

A hand with a stylus points to digital math notes on a tablet, illustrating concepts like REF, RREF, and Gaussian Elimination. The text overlay, "1.) Use Headings and Subheadings," emphasizes organizing notes for easy review.

A tablet displays digital math notes detailing LU Factorization with steps and an example. The overlay text, "2.) Bullet Points for Conciseness," advises using bullet points to highlight key information effectively.

Take PERFECT Notes In Class📝

📝 Take Perfect Notes That Make Studying a Breeze! 📝 Transform your notes with these simple tips: Use Headings and Subheadings 📂 Organize your notes with a clear structure for easy review and quick reference. Bullet Points for Conciseness ✔️ Highlight key ideas with short, simple bullet poi

79 likes

🔥 Viral Carousels + Free Cheat Sheet

If you’re not using carousels by now, you’re leaving visibility on the table. Want a cheat sheet to make yours stand out? Just visit the link in my bio and tap the free template link to grab it! Follow @vue.noel for more Canva tips, hacks, and freebies! #seamlesscarousel #brandcarous

44 likes

HTML Cheat Sheet

Essential HTML tags every developer needs! 🚀 Quick reference guide covering structure, text, links, images, forms & more. Perfect for beginners and coding bootcamps! Save this for your next project 💻✨ #HTML #WebDevelopment #Coding #Programming #webdev

1 like

Data Analysts Career Guide: SQL Query Optimization

Hello everyone! I wanted to share tips for optimizing SQL query performance. Using indexes effectively on key columns and selecting specific columns can speed up data retrieval. Additionally, minimizing nested queries and optimizing join operations enhances efficiency. Moreover, limiting unnecessar

14 likes

An iPad screen displays the ChatGPT 4.5 interface with various prompt suggestions like creating a cartoon, suggesting activities, creating a chart, and counting items in an image, along with a virtual keyboard.

An iPad screen shows a ChatGPT conversation where the user asks for the top 20% of information on the nervous system. ChatGPT provides a concise breakdown including its definition, divisions, and neurons.

An iPad screen displays a ChatGPT conversation explaining photosynthesis in simple terms and connecting it to daily life, using an example of planning a garden.

ChatGPT Study Prompts That Will Save You Hours!

Let’s be real, studying can be overwhelming, especially when you don’t know what to focus on. These ChatGPT prompts helped me simplify complex topics, avoid common mistakes, and actually remember what I’m learning. 🧠 Ask for the most essential 20% of any topic 🌱 Connect science to daily life s

427 likes

My monthly planner in Notion

Notion monthly planner that is inspired by the 12 Week Year method. Feel free to use the template + follow me on Instagram @ZaraArmstrongDesign 💫 #notion #notiontemplate #notionhacks #planner #graphicdesign #graphicdesigner #graphicdesigninspiration

153 likes

The Golden Gate’s just the beginning. SF is stacked 👏🏽 with 👏🏽 gems. Here 15 unforgettable things to do in San Francisco, blending iconic landmarks with underrated spots. 💎 @San Francisco [partner] We’re hitting the spots you’ve seen in postcards, like the Golden Gate Bridge 🌉, cable cars, and t

88 likes

my favvvv way tbh🫶🌸

#productivestudent #productivelearning #studygram #studytips #studywithme

357 likes

See more