Share this page!

Enter URL or ID to Unroll

You can paste full URL like: https://x.com/threadreaderapp/status/1644127596119195649
or just the ID like: 1644127596119195649

How to get URL link on X (Twitter) App

  1. On the Twitter thread, click on or icon on the bottom
  2. Click again on or Share Via icon
  3. Click on Copy Link to Tweet
  4. Paste it above and click "Unroll Thread"!
  5. More info at Twitter Help
Tips Excel Profile picture
@gudanglifehack
Apr 24 • 6 tweets • 2 min read • Read on X
Scrolly
Stop wasting hours on manual clicks. Here are 20 Excel shortcuts that will save you 2+ hours every week. 🧵👇 Image
1.Ctrl + Arrow Keys: Jump to the very edge of your data (Top, Bottom, Left, or Right).
2.Ctrl + Shift + Arrow Keys: Select all cells until the end of the data range.
3.Ctrl + Home: Instantly return to cell A1.
4.Ctrl + PgUp / PgDn: Move to the next or previous worksheet.
5.Ctrl + G: Open "Go To" (perfect for finding blanks or specific cells).
6.F2: Open the active cell for editing (stop double-clicking!).
7.Alt + Enter: Add a line break inside a single cell.
8.Ctrl + ;: Insert today’s date instantly.
9.Ctrl + 1: Open the full Format Cells menu.
10.Ctrl + Shift + $: Format numbers as Currency.
11.Ctrl + Shift + %: Format numbers as Percentage.
12.Alt + H + O + I: Auto-fit column widths (fixes those annoying #### symbols).
13.Alt + =: AutoSum—instantly sums up the column or row.
14.F4: Repeat your last action OR lock a cell reference (A1).
15.Ctrl + D: Fill Down (copies formula/data from the cell above).
16.Ctrl + Shift + L: Toggle Filters on or off.
17.Ctrl + T: Convert data into an official Excel Table.
18.Ctrl + Z: The "Life-Saving" Undo button.
19.Ctrl + F: Find specific data within your sheet.
20.Alt + A + M: Remove Duplicates from a selected range.
Pro-Tip: If you forget a shortcut, just tap the Alt key. Excel will show you "Key Tips" on the ribbon to guide your next move.
Which one is your most-used shortcut? Let me know below! 👇

• • •

Missing some Tweet in this thread? You can try to force a refresh
　

Keep Current with Tips Excel

Tips Excel Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @gudanglifehack

Tips Excel Profile picture
Apr 27
Hey Excel enthusiasts! 👋
Ever stared at thousands of rows of messy data and felt completely overwhelmed?
Pivot Tables are the secret weapon that transforms chaos into crystal-clear insights in seconds.
This is a 100% original, step-by-step thread packed with practical tips I use daily in real work. Let’s make you a Pivot Table pro! 📊🔥Image
1. What Exactly Is a Pivot Table?
Think of it as a dynamic summary engine. You feed it raw data, and it lets you slice, dice, group, and analyze from any angle without writing complex formulas.
Sales by region? Product trends over time? Customer behavior? Pivot Tables handle it all instantly.
2. Why Every Professional Needs This Skill
In today’s data-driven world, speed matters. With Pivot Tables you can answer business questions in under a minute instead of hours.
Managers notice people who deliver fast insights. Mastering this can seriously boost your career visibility.
Read 22 tweets
Tips Excel Profile picture
Apr 26
Stop wasting ChatGPT and Claude on simple tasks.
There’s a much smarter way: transform them into your personal 24/7 investment intelligence team.
No expensive subscriptions. No bias from financial influencers. Just clear, professional-grade insights tailored to you.
I’ve been using this daily for months. Here are 8 powerful, ready-to-use prompts that deliver real value. Thread 👇Image
1. Activate Your Custom AI Strategist
“Switch into expert investment advisor mode. You have decades of experience managing real money across global markets. My primary objective is [e.g., build long-term wealth / generate monthly income / aggressive growth]. My comfort with risk is [low/medium/high]. Always respond honestly, back everything with logic, and flag red flags immediately.”
2. Full Asset Breakdown
“Examine [ticker/asset name] thoroughly. Explain what drives its value, its strengths and weaknesses compared to peers, current pricing relative to fundamentals, and a direct recommendation: strong opportunity, neutral, or avoid — with supporting reasons.”
Read 13 tweets
Tips Excel Profile picture
Apr 26
Hello Excel friends! @gudanglifehack After four years working in finance and frequently being asked to write impromptu reports, I realized that mastering Excel formulas is a game-changer. I used to Google formulas for every assignment, but now I can complete almost everything in a matter of minutes. This thread contains over 30 of the Excel formulas I use most often in my daily work. Save and bookmark it! 🔥Image
1. MANDATORY BASIC FORMULAS
• SUM → =SUM(A1:A10)
• AVERAGE → =AVERAGE(A1:A10)
• COUNT → =COUNT(A1:A10)
• COUNTA → =COUNTA(A1:A10) (counts that also contain text)
• COUNTIF → =COUNTIF(A1:A100, “>50”)
2. LOOKUP (Super Important)
• VLOOKUP → =VLOOKUP(B2, Sheet2!A:F, 3, FALSE)
• XLOOKUP (new & improved version) → =XLOOKUP(B2, Sheet2!A:A, Sheet2!C:C)
• INDEX + MATCH (most powerful) → =INDEX(C:C, MATCH(B2, A:A, 0))
Read 15 tweets
Tips Excel Profile picture
Apr 26
Hello Excel friends, this time I’m going to talk about 50+ Excel Shortcuts You MUST Master in 2026.

Still using the mouse for everything? This thread will make your work 3x faster. Save now! Image
Don’t forget to save and share this information so your friends can also get this useful information.

1. NAVIGATION
Ctrl + Arrow (↑↓←→) → Jump to the end of the data
Ctrl + Home / End → Return to A1 or the last cell
Ctrl + G → Go To
Ctrl + Page Up / Down → Move between sheets
Alt + Page Up / Down → Scroll horizontally
These are my favorite shortcuts.

2. QUICK SELECTION
Ctrl + Shift + Arrow → Select to the end of the data
Ctrl + A (press twice) → Select the entire sheet
Shift + Space / Ctrl + Space → Select rows / columns
Ctrl + Shift + L → Turn Filter On/Off
Ctrl + Shift + O → Select cells containing comments
Read 19 tweets
Tips Excel Profile picture
Apr 25
You're paying $1200+ for an iPhone and using 30% of it.

The rest sits buried in settings Apple designed you to never check.

I spent 20 minutes digging through mine.

Found 10 features that replace apps I've been paying for.

Here's where to look:
1. Built-in white noise

Stop using YouTube to sleep or focus.

Settings → Accessibility → Audio/Visual → Background Sounds

Rain. Stream. Dark noise.

Works offline. No extra apps.
2. Instant subject cutout

Open any photo → press and hold on the subject

iPhone isolates it instantly.

Copy. Paste. Share anywhere.

No editing apps needed.
Read 12 tweets
Tips Excel Profile picture
Apr 25
Interesting to know: ChatGPT has a secret feature called Learning Mode.

Anyone can learn literally anything, step by step, like a personal tutor.

Here are 5 prompts to access it:
1. Learning Mode Activation

“Act as a highly experienced personal tutor known for teaching complex subjects in the simplest possible way. From now on, whenever I mention a topic, you will teach it step-by-step in structured lessons, starting from basics and gradually moving toward advanced concepts, ensuring I never feel overwhelmed. My learning topic is: [insert topic].”
2. Step-by-Step Learning Path

“Break the topic of [insert topic] into small, logically ordered lessons so that each lesson builds naturally on the previous one and prevents confusion or knowledge gaps.”
Read 6 tweets

Did Thread Reader help you today?

Support us! We are indie developers!

This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us!

Send Email!

:(