Automatically translated.View original post

[Excel] As expected, this has the opposite effect

Can't you erase it if you make it?

@あっこ|ワーママのExcel•PC仕事術👈 other Excel work techniques here

This time, we will introduce how to display a graph in a cell!

It's better to have a graph than just a table

Easy to see, but

Handwriting has the opposite effect! lol

Please take advantage of it! ✨

─ ─ ─ ─ ─ ─ ─

Akko | Wormama's Excel Work Techniques

\ "I'm not good at it" to "I can do it a little" /

Make that work easier!

* 1 minute a day and efficiency UP 🔰✨

* Go home 30 minutes early for family time ✨

Look from here 👇

≫ ≫ ≫@あっこ|ワーママのExcel•PC仕事術

─ ─ ─ ─ ─ ─ ─

# excel # excel _ beginner # graph # work efficiency # wahmama

6/27 Edited to

... Read moreExcelの[描画]タブって、インク関連(「インクを図形に」「インクを数式に変換」など)が増えてくると、目的のボタンが埋もれて探しにくいですよね。私は「グラフを入れたいだけなのに、描画のボタンが多くて逆に迷う…」となったので、[描画]タブの“フィルタリング”で必要なものだけ残す運用にしました。 ■[描画]タブをフィルタリングする基本手順 1) リボン(上のメニュー)上で右クリック 2)[リボンのユーザー設定]を開く 3) 右側の一覧から[描画]を探す 4) [描画]の中にある不要なグループやコマンドのチェックを外す(または非表示にする) 5)[OK]で反映 ポイントは「タブ自体を消す」のではなく、“中身を絞る”こと。例えば、普段インク機能を使わないなら、インク変換系のグループを外しておくと、探す時間がかなり減りました。 ■フィルタリングしても「表示が変わらない」時の確認 ・ブックではなくExcel全体の設定なので、別ファイルでも同じ見た目になります(変わっていてOK) ・会社PCだと、管理者設定でユーザー側のカスタマイズが制限されていることがあります。保存できない/戻る場合はこれが原因かも。 ・Excelのバージョン差で、[描画]タブの構成が違うことがあります(表示されるコマンド名が微妙に異なる)。 ■そもそも[描画]タブが出てこない時 1)[ファイル]→[オプション]→[リボンのユーザー設定]で[描画]にチェックが入っているか確認 2) タブが多すぎて隠れている場合があるので、ウィンドウ幅を広げる/リボンを展開して確認 3) タッチ対応端末やペン設定の有無で出方が変わることもあるので、環境依存の可能性も疑います ■私のおすすめ運用(時短のコツ) ・普段使うタブ(ホーム/挿入/データ)以外は「必要なときだけ見える」状態にしておく ・[描画]は“インクを使う日”だけONにする、くらいで十分でした 描画機能自体は便利なんですが、使わない機能が並ぶと逆に作業効率が落ちがち。[描画]タブのフィルタリングで「必要なものだけ」に整えると、クリック数も迷いも一気に減りました。

Related posts

Excel vs Word
Excel formatting does the same thing as many people using Word #tutorial #exceltips #exceltricks #exceltutorial #exceltraining #worktips #alwayslearning
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

4954 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
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

36 likes

100 Excel Tips
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
ExpressoSolut

ExpressoSolut

1446 likes

Excel drop it function
Remove columns and rows using drop in excel. #exceltips #excel #exceltutorial #businesstips #business #tutorial #boss #spreadsheet
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

20 likes

This image illustrates 20 Excel tips and tricks. It covers adding a dynamic dropdown list, unpivoting data, adding slicer buttons to a PivotTable, using text to columns, transposing data, duplicating windows, and tracking cell values with a watch window. Each tip includes a visual example and brief instructions.
20 Excel Tricks & Tips 👇
Master all 20 and become an excel wizard 🧙‍♂️ 1️⃣ Add a dropdown tied to a dynamic list Know how to create a drop down using data validation? Cool…now how about extending that reference when your list expands? Step 1: create a table out of the list. This will extend the table anytime a
ExpressoSolut

ExpressoSolut

247 likes

Compare lists in excel
Excel list comparison help #excel #tutorials #exceltips #exceltraining #fyp
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

9 likes

#Exceltutorial
#verifiedonlemon8 #honestreview #elf Random Thoughts 💭What's on my mind: How to guides for Excel Current Mood: Accomplished ⭐Rate: ⭐️⭐️⭐️⭐️⭐️
JMWINC2026

JMWINC2026

0 likes

Excel list comparison 🌸
Excel list comparison went viral save this for when you need it #exceltraining #excel #exceltutorial #exceltips #exceltricks
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

139 likes

My Excel pet peeves that make me want to scream 😤
Let’s talk about Excel’s freaking default settings, which is my biggest crashout ever! Why is overflow the go-to instead of wrap text? Who’s out here typing and thinking “Yes, let my content spill into other cells!” The whole point of Excel is neat and boxed-up info. Overflow totally ruins that! An
Billie🐻‍❄️🤍

Billie🐻‍❄️🤍

9 likes

Excel percent format issue trick
Excel percent format issue trick. Fix percentage issues. #tutorial #exceltips #excel #excelpro #exceltricks #exceltutorial #exceltraining
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

12 likes

Excel list comparison 🌸
So we have to use something called Planbook at work (Teacher). I think this will make me want to actually use it more, and I can see me changing it again before second semester begins lol. How cute is this?! I’d usually do random colors, but love the pink & green combo. #Planbook #
Hey 😁

Hey 😁

4473 likes

Excel signature
Yes a handwritten signature imported in excel #exceltips #exceltricks #exceltraining #exceltutorial #excel
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

189 likes

Excel highlighting trick
CTRL+ Shift + arrow to highlight cells. #exceltips #tutorials #exceltraining #exceltutorial #excel #excelpro #onthisday
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

26 likes

5 PROVEN METHODS TO EXCEL AT WORK
Hey productivity bestie ☕✨ If you’ve been busy ALL day but still feel like you got nothing done… yeah, we fixing that TODAY 👀 Here’s your simple Productivity Glow-Up Blueprint (no overwhelm, just results 💼💅🏽): ✨ Set CLEAR goals (not “do work” be specific!) ✨ Prioritize what actually matte
7figurebrandingqueen

7figurebrandingqueen

3 likes

EXCEL FORMULA: TRANSPOSE
In the vast landscape of Excel functions, the Transpose formula stands out as a powerful tool that can transform the way you work with data. Whether you're a seasoned spreadsheet maestro or just dipping your toes into the world of Excel, understanding and harnessing the Transpose function can b
Peyton’s Place

Peyton’s Place

187 likes

Separate words in excel
Separating text in excel #exceltricks #exceltips #tutorials #takemyclass #fyp
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

28 likes

An infographic details Excel Custom Formatting, covering its definition, access methods, and syntax for positive, negative, and zero values. It illustrates various operators like numbers, colors, and symbols, alongside examples for formatting dates, conditional formatting, fractions, scientific notation, percentages, custom text, number abbreviations, and using symbols.
Excel Custom Formatting
This is my favorite Excel trick 😎 Custom Formatting Custom Formatting is even cooler…allowing you to change the way your cell values appear in a cell. Here...let me show you a few example… but first: ➡️ How do you open up to Custom Formatting dialogue box? A few ways: 1️⃣ Hit CT
ExpressoSolut

ExpressoSolut

184 likes

Excel formatting tips
Excel formatting tips #tutorials #excel #excelforbeginners #exceltraining
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

170 likes

A promotional image titled "Three Microsoft Excel hacks to save you hours in 2023," featuring a smiling woman with crossed arms and the Microsoft Excel logo on a light green background.
This image details the first Excel hack: "Return to the top without scrolling" by pressing Ctrl (or Command) and the up arrow twice, accompanied by a small Excel icon.
This image details the second Excel hack: "Quickly resize columns and rows" by double-clicking the dividing line between columns, accompanied by a small Excel icon.
3 Excel Hacks you need to know!

You know what's a game-changer in the office world? Understanding Microsoft Excel! 📊 It's not just a spreadsheet software; it's your secret weapon for success. Here's why: First, it's a productivity wizard. Excel can crunch numbers, organize data, and create slick charts in a
corporatespirit

corporatespirit

391 likes

A tablet displays an Excel wedding budget spreadsheet on a desk with notes and a planner. The image is titled 'Stop Struggling with Excel Learn These Super Easy Formulas'.
This image details core Excel calculation formulas: SUM, AVERAGE, MIN, and MAX. Each function is explained with an example Excel table showing its application and purpose.
This image explains Excel's reference formulas, VLOOKUP and HLOOKUP. It provides examples with tables demonstrating how to search and retrieve data vertically and horizontally, along with usage tips.
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
emilie.studygram

emilie.studygram

1191 likes

RANDBETWEEN() Function in Excel
How to use RANDBETWEEN() Function in Excel #excel #exceltips #exceltipsandtricks #exceltutorial #microsoftexcel
DataUnleash

DataUnleash

0 likes

How to Find Matrix Inverse in Excel
#lemon8challenge #lemon8badgehunt How to Find Matrix Inverse in Excel #excel #exceltips #exceltutorial
DataUnleash

DataUnleash

1 like

The Difference between IF and IFS Function in Excel
#emergingcreator The Difference between IF and IFS Function in Excel #excel #exceltips #exceltutorial #microsoftexcel
DataUnleash

DataUnleash

0 likes

How to add Filter on your worksheet in Excel
How to add Filter on your worksheet in Excel #exceltricks #exceltutorial #excel #excelsheets #exceltips
DataUnleash

DataUnleash

2 likes

TRUE & FALSE in Excel
True & False Condition in Excel #excel #excelsheets #exceltips #exceltutorial #spreadsheet
DataUnleash

DataUnleash

0 likes

Separate tab for excel notes
Keep your notes to yourself with excel camera #tutorial #excel #exceltraining #exceltricks #business #exceltutorial #exceltips
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

37 likes

TRUE & FALSE in Excel
#lemon8challenge #lemon8badgehunt In this video, i will be explaining how to use True & False in Excel #excel #exceltips #microsoftexcel
DataUnleash

DataUnleash

0 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
Sireen | Data Mentor

Sireen | Data Mentor

7 likes

Excel tip to filter
Excel filtering tip #tutorials #exceltips #exceltraining #excelforbeginners #business
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

23 likes

How to use PRODUCT Function in Excel
How to use PRODUCT Function in Excel #excel #exceltips #exceltricks #exceltutorial #microsoftexcel
DataUnleash

DataUnleash

0 likes

do you know this excel trick?
#exceltips #excel #spreadsheet #halloweenideas #halloween #hellolemon8
Excel.dashboard.queen

Excel.dashboard.queen

0 likes

Compare lists using excel
Find the differences between columns in excel #exceltips #learning #excelshortcuts #excelspreadsheets #skillshare
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

8 likes

Let’s break these excel habits
Do you consider this proficient in Excel?? I can tell you it’s not. My office survival course is for you and can be done in as little as a weekend or during lunch for a week. #exceltraining #tutorial #excel #exceltips #exceltipsandtricks #exceltricks #onlinecourse
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

37 likes

A laptop displaying a lock screen with a scenic mountain and lake image, next to a potted cactus and a lit candle. The title 'CONDITIONAL FORMATTING IN EXCEL' is overlaid in green text.
An Excel spreadsheet showing a list of student names and their grades. Text on the right explains the goal: 'WE HAVE A LIST OF STUDENTS WITH CLASS GRADES LETS USE THE CONDITIONAL FORMATTING TOOL TO GIVE A BETTER VISUAL REPRESENTATION OF WHERE STUDENTS ARE IN THE CLASS'.
An Excel spreadsheet with the 'Grade' column (cells C5 to C22) highlighted, indicating the data selection for conditional formatting. Text on the right says 'HIGHLIGHT YOUR DATA...'.
CONDITIONAL FORMATTING IN EXCEL
Excel's conditional formatting is a powerful feature that allows you to visually emphasize specific data points, making your spreadsheets more intuitive and informative. Two commonly used conditional formatting rules are the Gradient Scale and the Greater/Less Than rules. Let's explore how
Peyton’s Place

Peyton’s Place

164 likes

Excel IF Function
How to use IF Function in Excel #excel #exceltips #exceltraining #exceltricks #exceltutorial
DataUnleash

DataUnleash

0 likes

How to use AND Function in Excel
Here is a video explaining how to use AND Formula in Excel #excel #exceltipsandtricks #exceltips #exceltutorial #microsoftexcel
DataUnleash

DataUnleash

0 likes

Excel projects with a Gantt chart
Auto populate the Gantt style chart with name and color #template #excel #tutorial #friday #exceltips
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

11 likes

✨ Welcome to Our Excel Mini-Class! 🐶 In this session, we’re diving into essential Excel functions that will save you tons of time! ⌛ From quick calculations to powerful data organization, these functions do the work for you—no more repetitive tasks! 🔄🔍 These go-to functions will boost your produ
WPS Office

WPS Office

3 likes

How to use IF & ISBLANK Function in Excel
How to use IF & ISBLANK Function in Excel #excel #exceltips #exceltricks #exceltutorial #learnexcel
DataUnleash

DataUnleash

2 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
WPS Office

WPS Office

150 likes

Does anyone know this excel function?
#hellolemon8 #excel #exceltips #excelx #excelhacks
Excel.dashboard.queen

Excel.dashboard.queen

1 like

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

Excel tips at XecuteTheVision

9 likes

Less clicking, more doing. Excel like a pro! 📊💡 #
Shop Now at https://peakchoicemall.shop
Sincere

Sincere

1 like

Don’t be a square use Excel…..
Excel is a very powerful tool that you can use in engineering maths and science. Start easy and build up. #excel #mechanicalengineering #stem #engineeringstudent #physics
EngineerItWithMJL

EngineerItWithMJL

1 like

A person wearing glasses and a houndstooth jacket sits in a car, looking at the camera. Text overlay introduces the 'RANDBETWEEN FUNCTION IN EXCEL'.
An Excel screenshot shows the formula bar with '=RANDBETWEEN(1,100)' and cell A1 displaying '12'. Text explains how to generate a random number within a specific range using this Excel formula.
An Excel screenshot shows cell A1 with '12' and the formula '=RANDBETWEEN(1,100)'. Text explains that the number is between 1 and 100 and can be refreshed for a new random value.
HOW I USE RANDBETWEEN IN EXCEL
In the pool of Excel formulas, the RAND() function brings the ability of randomness to my data. However, if you want control over the range of integers generated, enter the RAND() formula in combination with RANDBETWEEN(min, max). With this formula, I can set the minimum and maximum values to tailo
Peyton’s Place

Peyton’s Place

42 likes

Excel instructions template
Document instructions by department with an SOP template ready to use. Document procedures and process #tutorial #exceltricks #work #procedure #process
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

16 likes

A desk setup with a monitor displaying a project plan, a laptop, keyboard, and a plant, illustrating the topic of 'Excel alternatives best in 2025'.
A screenshot of Zoho Sheet displaying a spreadsheet with country population data, highlighting it as a free Excel alternative with advanced features for seamless collaboration.
A screenshot of Smartsheet's campaign planning interface, demonstrating its project management features, templates, and views for tracking progress and collaboration.
Excel alternatives best in 2025
Looking for a fresh spin on spreadsheets? These tools bring fresh alternatives to Excel and Google Sheets, offering powerful features, real-time collaboration, and user-friendly designs. Whether you’re a data enthusiast, team player, or productivity seeker, there’s something here for everyone. S
Reverelia

Reverelia

49 likes

GROUPBY Function in Excel Explained
How to use GROUPBY Function in Excel #exceltips #excelformulas #excel #exceltutorial #excelhacks
DataUnleash

DataUnleash

1 like

An Excel spreadsheet displays a list of full names in column B, with an overlay titled 'HOW TO Separate FIRST & LAST NAME Using the delimiter tool' and a large arrow pointing to the names.
A screenshot of Excel shows the 'Data' tab selected and the 'Text to Columns' wizard open. The first step, 'Delimited', is chosen, and the 'Next' button is highlighted, demonstrating how to begin splitting data.
Two Excel screenshots illustrate the 'Text to Columns' wizard. The top shows selecting 'Space' as the delimiter. The bottom shows the final step, where the destination is set, and the 'Finish' button is highlighted.
HOW TO SEPARATE FIRST & LAST NAMES IN EXCEL
In my daily data management tasks, I often encounter scenarios where first and last names are crammed into a single cell. It can be quite a hassle to manually split them into separate columns. Thankfully, Excel offers a solution that saves me a ton of time: the "Text to Columns" feature.
Peyton’s Place

Peyton’s Place

520 likes

A laptop displaying an Excel-like interface, a gold lamp, and glasses on a desk. The image is overlaid with the title "EXCEL'S COUNTA FUNCTION" in light green text, introducing the topic.
A light green background with bold white text stating: "THE COUNTA FUNCTION COUNTS THE NUMBER OF CELLS THAT ARE NOT EMPTY IN A RANGE." This defines the core purpose of the Excel COUNTA function.
An Excel spreadsheet showing a column of names labeled "Winners." The formula `=COUNTA(G4:G23)` is being entered into a cell, demonstrating how to apply the COUNTA function to count non-empty cells.
EXCELS COUNTA FUNCTION
In the vast realm of Excel, where cells transform into dynamic canvases of data, I recently stumbled upon a tool that revolutionized the way I analyze information – the COUNTA function. Allow me to share my newfound admiration for this versatile gem. COUNTA, short for 'count all,' is not
Peyton’s Place

Peyton’s Place

47 likes

Excel cheat sheet
Excel cheat sheet #excel #exceltips #exceltricks #exceltraining #tutorials #excel_learning
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

14 likes

Easy way for sum in excel
Easy way for Sum in excel #exceltraining #excelformula #excelformulas #exceltutorial #exceltips
Andey

Andey

0 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
Peyton’s Place

Peyton’s Place

105 likes

A laptop screen displays a Google Sheet titled 'FALL 2024 ASSIGNMENTS SPREADSHEET' with columns for Course, Assignment, Due Date, and Days Till Due, showing various college assignments.
A Google Sheet template with headers 'COURSE', 'ASSIGNMENT', 'DUE DATE', and 'DAYS TILL DUE' is shown, with text instructing to start by organizing columns with these headers.
Two Google Sheet snippets demonstrate how to populate the assignment tracker. The first shows entering a course name, and the second shows entering assignments and their corresponding due dates.
Time to organize your assignments!
I’ve been using this method to organize my assignments since I was a freshman, 2 years ago. I am now a junior and If I can say one thing is that—this is the real deal here ✔️ Using Google sheets has been a game changer for me in my college career. It keeps me on track with all my assignments,
arianna 💌

arianna 💌

5210 likes

See more