Excel Tips, Tricks, and Shortcuts

Is Scroll Lock really bothering you? Check how to solve the turn off scroll lock issue! | Excel Tips

noreply@blogger.com (Michael Leng) — Sun, 13 Jul 2025 09:53:00 +0700

Ever been happily navigating your Excel spreadsheet, just gliding through cells with your arrow keys, when suddenly… BAM! The arrow keys start moving the entire sheet instead of just the active cell? If you've experienced this sudden, disorienting shift, you've likely encountered the infamous Scroll Lock issue in Microsoft Excel. It's one of those minor annoyances that can feel like a major roadblock when you're in the middle of a complex task.

How to Turn Off Scroll Lock in Excel

☺Believe me, you're not alone! Many Excel users, from beginners to seasoned pros, have been stumped by this seemingly random behavior. It disrupts your flow, wastes your time, and can be incredibly frustrating. But here's the good news: fixing the "turn off Scroll Lock" issue is usually quick and straightforward once you know where to look.

Welcome back to "Excel Tips, Tricks, and Shortcuts," your go-to source for demystifying common Excel challenges. Today, we're tackling the Scroll Lock mystery head-on. We'll explore why this happens, how to identify it, and most importantly, provide you with easy, step-by-step solutions to get your Excel navigation back to normal, whether you have a traditional keyboard or a more modern setup. Let's banish that Scroll Lock annoyance for good!

💥Understanding Scroll Lock: The (Often Unwanted) Navigator

First, let's understand what Scroll Lock actually is and why it even exists. The Scroll Lock key, typically found on older, full-sized keyboards, was originally designed for applications like spreadsheets. Its purpose was to change the behavior of the arrow keys.

Scroll Lock OFF (Normal Behavior): When Scroll Lock is off, pressing the arrow keys moves the active cell cursor around your spreadsheet. The sheet itself remains static until the cursor reaches the edge of the visible window. This is the intuitive navigation we all expect.
Scroll Lock ON (Altered Behavior): When Scroll Lock is turned on, the arrow keys no longer move the active cell. Instead, they scroll the entire worksheet up, down, left, or right, while the active cell cursor stays in its current position on the screen. It's like using the scroll bars with your arrow keys.

While this functionality might have had niche uses in a bygone era, for most modern Excel users, it's largely obsolete and often accidentally activated, leading to confusion and frustration. Today, its primary role seems to be generating "help, my Excel is broken!" queries.

👀The Tell-Tale Sign: The Excel Status Bar

Before you start panicking or assuming your Excel is corrupted, the first place to check for the Scroll Lock issue is the Excel Status Bar. This is the thin gray bar at the very bottom of your Excel window.

Look closely at the left or right side of the status bar. If "Scroll Lock" or "SCRL LK" is displayed there, it means the feature is currently active. If you don't see it, right-click anywhere on the status bar, and a list of options will appear. Make sure "Scroll Lock" has a checkmark next to it to display its status. If it's checked and not visible, it means Scroll Lock is off. If it's visible and says "Scroll Lock," then you've found your culprit!

👉Solution 1: The Physical Scroll Lock Key – The First Stop

For many desktop users with full-sized keyboards, the solution is as simple as pressing a single key.

Locate the Scroll Lock Key: On a standard keyboard, the Scroll Lock key is usually found in a block of three keys located above the arrow keys and to the right of the Function keys (F1-F12). It's typically labeled "Scroll Lock" or "ScrLk". It's often next to the Print Screen (PrtScn) and Pause/Break keys.
Press the Key: Simply press the Scroll Lock key once. This acts as a toggle switch.
Check the Excel Status Bar: Look at the Excel status bar again. The "Scroll Lock" indicator should disappear.
Test Your Arrow Keys: Try navigating with your arrow keys. They should now move the active cell cursor as expected.

👍What if your keyboard doesn't have a Scroll Lock key? This is very common with laptops, compact keyboards, or certain wireless keyboards that prioritize space. Don't worry, there are other ways!

Laptop Keyboards (Function Key Combinations): Many laptops map the Scroll Lock function to a combination of keys, usually the Function (Fn) key plus another key. Common combinations include:
- Fn + F12
- Fn + S
- Fn + C
- Fn + K
- Fn + Insert (sometimes marked Ins)
- Fn + Num Lock (if Num Lock LED is on a key)
- Tip: Look for a small "ScrLk" icon or label on your F keys, Insert key, or even Num Lock key that matches a color associated with your Fn key. The exact combination varies greatly by laptop brand (e.g., HP, Dell, Lenovo, Acer, Asus). Check your laptop's user manual or the manufacturer's support website if you're unsure.

👉Solution 2: The On-Screen Keyboard (OSK) – The Universal Fix for Windows Users

If you can't find a physical Scroll Lock key or a function key combination, or if your physical key seems broken, the On-Screen Keyboard (OSK) in Windows is your universal lifeline. This method works on any Windows PC, regardless of your physical keyboard setup.

How to open the On-Screen Keyboard:

Windows 10/11:
- Click the Start button.
- Type "On-Screen Keyboard" in the search bar.
- Click on "On-Screen Keyboard" from the search results.
Using the Run Dialog:
- Press Windows Key + R to open the Run dialog.
- Type osk and press Enter.

Once the On-Screen Keyboard appears:

Locate the "ScrLk" Key: On the virtual keyboard, look for a key labeled "ScrLk" (or sometimes just "ScLk" or "SLK"). It's usually on the right side, near the Num Lock and PrtScn keys.
Click the "ScrLk" Key: Click on this key with your mouse. You'll notice it visually "depresses" or changes color when active.
Check Excel: Switch back to your Excel window. The "Scroll Lock" indicator in the status bar should now be gone.
Close OSK: You can close the On-Screen Keyboard by clicking the "X" in the top-right corner, or by simply minimizing it if you need it again soon.

This is often the most reliable method when other options fail or are unavailable.

Troubleshooting & Quick Checks for Persistent Issues

If Scroll Lock persists or seems to behave erratically, consider these additional troubleshooting steps:

Restart Excel: Sometimes, simply closing and reopening Excel can resolve temporary glitches.
Restart Your Computer: A full system restart can often clear up underlying software conflicts or memory issues that might be affecting keyboard input.
Check for Excel Add-ins or Macros: In rare cases, a poorly designed or conflicting Excel add-in or macro could be inadvertently toggling Scroll Lock.
- Go to File > Options > Add-ins.
- At the bottom of the dialog box, next to "Manage: Excel Add-ins," click "Go...".
- Try unchecking any suspicious or recently installed add-ins and restart Excel to see if the problem resolves. Re-enable them one by one to identify the culprit.
Try Another Keyboard: If you have access to a different physical keyboard, try plugging it into your computer and testing Excel. This helps determine if the issue is with your specific keyboard hardware.
Update Keyboard Drivers: While less common for Scroll Lock, outdated keyboard drivers could sometimes contribute to unusual behavior. Check your computer manufacturer's website for driver updates.

Tips to Prevent Future Scroll Lock Annoyances

While Scroll Lock isn't a malicious feature, it's certainly an antiquated one that causes more confusion than help for most users. Here are a few tips to minimize its future impact:

Always Check the Status Bar: Make it a habit to glance at the Excel status bar if your arrow keys aren't behaving as expected. The "Scroll Lock" indicator is your fastest diagnostic tool.
Be Mindful of Keyboard Areas: If you're using a full-sized keyboard, be aware of the "navigation block" (Print Screen, Scroll Lock, Pause/Break) when reaching for other keys. Accidental presses are common.
Consider a Different Keyboard (if applicable): If your current keyboard's layout makes accidental Scroll Lock presses too frequent, or if it lacks a direct key and relying on OSK is cumbersome, a different keyboard layout might be beneficial.

Regain Control of Your Excel Navigation!

The Scroll Lock issue in Excel, while frustrating, is almost always a simple fix. By understanding what Scroll Lock does, recognizing its presence on the Excel status bar, and knowing how to toggle it off using either your physical keyboard's Scroll Lock key or the reliable Windows On-Screen Keyboard, you can quickly regain normal navigation control.

Don't let a minor keyboard setting derail your productivity! With these tips, you're now equipped to diagnose and resolve this common Excel annoyance swiftly.

🙏Thank you for diving into this practical guide with us! We hope this helps you work more smoothly in Excel. If you found this post helpful, please consider giving it a like and sharing it with your friends and colleagues who might also benefit from these essential Excel tips, tricks, and shortcuts. Your support helps us create more valuable content for our community!

Sources:

Microsoft Support: Turn off Scroll Lock: https://support.microsoft.com/en-us/office/turn-off-scroll-lock-a42e585b-c2e3-4b68-b7c1-0c5a21010313
How-To Geek: What Is the Scroll Lock Key, and What Does It Do?: https://www.howtogeek.com/182608/what-is-the-scroll-lock-key-and-what-does-it-do/
Lifewire: How to Use the On-Screen Keyboard in Windows 10/11: https://www.lifewire.com/on-screen-keyboard-in-windows-10-4685025

Extending the =TODAY() Excel Formula Creatively: Displaying Today, Tomorrow, and Beyond Automatically! (Plus 9 Essential Formulas & 11 Popular Functions You Should Know) 🚀

noreply@blogger.com (Michael Leng) — Sat, 12 Jul 2025 17:44:00 +0700

Hey Excel enthusiasts! 👋 Ever found yourself staring at a spreadsheet, wishing it could just know what day it is (and what days are coming up) without you having to manually type it in all the time? Well, you’re in the right place!

Extend Excel TODAY Function Automatically

Here at "Excel Tips, Tricks, and Shortcuts," we're all about making your life with Microsoft Excel easier, faster, and dare I say, even a little bit more fun. Today, we're going to dive into a simple yet incredibly powerful formula: =TODAY(). You probably already know it – it gives you the current date, automatically updating whenever you open your workbook. Pretty neat, right?

But we’re not stopping there. We’re going to take this humble formula and stretch its legs, showing you how to creatively display not just today, but also tomorrow, the day after, and even create dynamic date series that can seriously boost your planning and organization. Trust me, once you master this, you’ll wonder how you ever managed without it!

And because we’re all about giving you the most bang for your buck (or should I say, the most efficiency for your click?), we’ll also weave in 9 essential Excel formulas that every user should have in their arsenal, along with 11 popular and incredibly useful Excel functions that will take your spreadsheet skills to the next level. Think of this as your mini Excel power-up session! Let's get started, shall we?

The Magic of `=TODAY()`: Your Ever-Present Date

Let’s start with the basics. In its simplest form, just typing =TODAY() into any cell and hitting Enter will give you the current date. What’s fantastic about this is that Excel keeps track of the system date on your computer, so this formula will always show you the actual day you’re opening or recalculating your spreadsheet.

This is super useful for:

Timestamping reports: Automatically adding the current date to the top of a report.
Calculating age: When combined with someone's birthdate. (More on that later!)
Dynamic dashboards: Ensuring your key performance indicators are always reflecting the latest timeframe.

But as promised, we’re going beyond the single date…

Stepping into the Future: Showing Tomorrow and Beyond

Here’s where the creative extension comes in. Excel treats dates as numerical values. Seriously! January 1, 1900, is considered day 1, January 2, 1900, is day 2, and so on. So, to get future dates, all we need to do is add integers to the result of =TODAY().

Here’s the breakdown:

Tomorrow’s Date: In a cell next to or below your =TODAY() formula, type: =TODAY()+1 and press Enter. Voila! You have tomorrow’s date.
The Day After Tomorrow: Similarly, in the next cell, type: =TODAY()+2 and press Enter.
And So On…: You can continue this pattern: =TODAY()+3, =TODAY()+4, and so forth, to display dates further into the future.

Pro Tip: Using Cell References for Efficiency

Instead of typing =TODAY() repeatedly, you can be much more efficient by referencing the first future date.

In cell A1, enter =TODAY().
In cell A2, enter =A1+1.
Now, select cell A2. Notice the small green square at the bottom-right corner? That’s the Fill Handle.
Click and drag this Fill Handle downwards as far as you need to go. Excel will automatically increment the formula in each subsequent cell (A3 will become =A2+1, A4 will be =A3+1, and so on), creating a dynamic series of future dates!

Think about the possibilities! You can create:

Projected deadlines: Easily see what dates fall a certain number of days from your start date.
Event calendars: Quickly list upcoming events based on today’s date.
Shift schedules: Automatically generate a series of workdays.

Going Back in Time: Displaying Past Dates

Just as adding integers takes you into the future, subtracting them takes you into the past:

Yesterday’s Date: =TODAY()-1
Two Days Ago: =TODAY()-2

You can use the same Fill Handle trick here to create a series of past dates as well. This can be useful for tracking historical data or looking back at trends.

Formatting Your Dates for Clarity

You might notice that Excel displays dates in a default format. To make your dates look exactly how you want them, you’ll want to format the cells.

Select the cell(s) containing your date formulas.
Right-click on the selected cells.
Choose “Format Cells…” from the context menu.
In the “Format Cells” dialog box, go to the “Number” tab.
In the left-hand “Category” list, select “Date.”
On the right, you’ll see a variety of date formats. Choose the one you prefer (e.g., “MM/DD/YYYY”, “YYYY-MM-DD”, “dd-mmm-yyyy”, or even more descriptive options like “Monday, July 12, 2025”).
Click “OK.”

Now your dates will be displayed in your chosen style, making your spreadsheets much easier to read and understand.

9 Essential Excel Formulas You Absolutely Need to Know 🚀

Okay, as promised, let's take a quick detour to arm you with some other fundamental Excel formulas that will significantly enhance your spreadsheet prowess. Think of these as your core Excel toolkit!

=SUM(number1,[number2],...): The bread and butter of Excel! This formula adds up all the numbers in a range of cells.
- Example: =SUM(A1:A10) adds all the values in cells A1 through A10.
=AVERAGE(number1,[number2],...): Calculates the arithmetic mean of a range of numbers.
- Example: =AVERAGE(B1:B5) finds the average of the values in cells B1 to B5.
=COUNT(value1,[value2],...): Counts the number of cells in a range that contain numerical values.
- Example: =COUNT(C1:C20) tells you how many cells in C1 to C20 have numbers in them.
=COUNTA(value1,[value2],...): Counts the number of non-empty cells in a range (text, numbers, errors, etc.).
- Example: =COUNTA(D1:D15) counts all the cells in D1 to D15 that aren't blank.
=IF(logical_test,value_if_true,value_if_false): This is a powerhouse formula that lets you perform different calculations or display different values based on whether a condition is true or false.
- Example: =IF(E2>10,"Pass","Fail") checks if the value in cell E2 is greater than 10. If it is, it displays "Pass"; otherwise, it displays "Fail."
=MAX(number1,[number2],...): Returns the largest numerical value in a range of cells.
- Example: =MAX(F1:F12) finds the highest number in cells F1 through F12.
=MIN(number1,[number2],...): Returns the smallest numerical value in a range of cells.
- Example: =MIN(G1:G8) finds the lowest number in cells G1 to G8.
=VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup]): A crucial formula for searching for data in a table based on a key value.
- Example: =VLOOKUP("Apple",A1:B10,2,FALSE) looks for "Apple" in the first column of the range A1:B10 and returns the value from the second column in the same row. The FALSE ensures an exact match.
=CONCATENATE(text1,[text2],...): Combines text from multiple cells into one cell. You can also use the ampersand (&) operator for the same purpose (e.g., =A1&" "&B1).
- Example: =CONCATENATE(H1," ",H2) joins the text in cell H1, a space, and the text in cell H2.

Mastering these 9 formulas will give you a solid foundation for working with data in Excel and will come in handy in countless situations!

11 Popular and Incredibly Useful Excel Functions to Supercharge Your Spreadsheets 🚀

Now, let's move on to some popular and highly effective Excel functions that can help you manipulate data, analyze information, and automate tasks even further. Think of these as your advanced Excel tools!

=LEFT(text,[num_chars]): Extracts a specified number of characters from the beginning (left side) of a text string.
- Example: =LEFT("Excel Tips", 5) returns "Excel".
=RIGHT(text,[num_chars]): Extracts a specified number of characters from the end (right side) of a text string.
- Example: =RIGHT("Excel Tips", 4) returns "Tips".
=MID(text,start_num,num_chars): Extracts a specified number of characters from a text string, starting at a position you specify.
- Example: =MID("Excel Tips", 7, 4) returns "Tips".
=LEN(text): Returns the number of characters in a text string.
- Example: =LEN("Excel Tips") returns 10.
=TEXT(value,format_text): Formats a value (like a number or date) as text in a specific format.
- Example: =TEXT(TODAY(),"MMMM DD, YYYY") might return "July 12, 2025".
=ROUND(number,num_digits): Rounds a number to a specified number of digits.
- Example: =ROUND(3.14159, 2) returns 3.14.
=INT(number): Rounds a number down to the nearest integer.
- Example: =INT(3.99) returns 3.
=DATE(year,month,day): Returns a serial number that represents a specific date. Useful for creating dates based on separate year, month, and day values.
- Example: =DATE(2025, 7, 12) returns the serial number for July 12, 2025.
=MONTH(serial_number): Returns the month (as a number from 1 to 12) of a date.
- Example: =MONTH(TODAY()) will return 7 (for July).
=YEAR(serial_number): Returns the year of a date.
- Example: =YEAR(TODAY()) will return 2025.
=IFERROR(value,value_if_error): Returns a specified value if a formula evaluates to an error; otherwise, it returns the result of the formula. Great for handling potential errors gracefully.
- Example: =IFERROR(A1/B1, "Error: Division by Zero") will return the result of A1 divided by B1, but if B1 is zero, it will display "Error: Division by Zero".

These 11 functions will empower you to manipulate text, work with numbers and dates more effectively, and handle errors in your formulas like a pro!

Tips to Recheck If You're in Good Shape: ✅

Before we wrap up, here are a few quick checks to ensure you've got a good grasp of what we've covered:

Can you explain how =TODAY() works in your own words?
Do you know how to display tomorrow's and yesterday's dates using =TODAY()?
Have you practiced using the Fill Handle to create a series of automatic dates?
Are you familiar with the basic steps to format dates in Excel?
Can you recall at least 3 of the 9 essential Excel formulas and what they do?
Can you name a couple of the 11 popular Excel functions and their uses?

If you can confidently answer "yes" to most of these, then you're definitely in good shape to start using these techniques in your own spreadsheets! Don't worry if some of it feels new; the best way to learn is by doing!

Your Dynamic Date Journey Begins! 🚀

So there you have it! You’ve now unlocked the power to creatively extend the =TODAY() formula in Excel, allowing you to automatically display today’s date, tomorrow’s, and a whole series of dates into the future (or past!). This simple yet effective technique can save you time, improve your planning, and make your spreadsheets more dynamic and insightful.

We also took a valuable detour to explore 9 essential Excel formulas and 11 popular functions that will undoubtedly become indispensable tools in your daily Excel adventures. By incorporating these into your workflow, you'll be well on your way to becoming an Excel whiz!

Thank you so much for joining me on this Excel journey! If you found this post helpful, please like it and share it with your fellow spreadsheet warriors! Your support helps us continue to create more tips, tricks, and shortcuts to make your Excel experience even better.

Happy Excelling! 😊

Sources:

Microsoft Office Support: Link to Microsoft's official documentation on the TODAY function
Exceljet: Link to a relevant Exceljet page explaining date formulas or functions

📊 12 Examples of Excel IF Function Made Simple: Step-by-Step Guide

noreply@blogger.com (Michael Leng) — Tue, 8 Jul 2025 10:40:00 +0700

If you’ve ever wondered how to use the IF function in Excel without confusion, you’re in the right place. This step-by-step guide will show you 12 practical examples of how to use the IF function in everyday Excel tasks—made simple and easy to follow.

Whether you’re new to Excel or looking to sharpen your skills, these tips will help you work smarter, save time, and boost your productivity.

📊 12 Examples Excel IF Function Made Simple: Step-by-Step Guide

🌟 What is the Excel IF Function?

The IF function is one of Excel’s most powerful tools. It allows you to create logical comparisons—asking Excel to check if something is true or false, and then take different actions based on the result.

👉 Basic Syntax:
=IF(logical_test, value_if_true, value_if_false)

Before we dive into how to use the IF function, let’s first take a look at its syntax and what it does.

The IF function checks whether a condition (logical_test) is true or false and returns one value if true, another if false.

Breakdown of Each Part:

logical_test
- A condition you want to check (e.g., A1 > 10, B2 = "Yes").
- Must evaluate to TRUE or FALSE.
value_if_true
- The result if logical_test is TRUE.
- Can be a number, text (in quotes), formula, or cell reference.
value_if_false
- The result if logical_test is FALSE.
- Optional (if omitted, returns FALSE by default).

✅ 12 Practical Examples of Using IF Function in Excel:

1. Basic IF Example: Pass or Fail

=IF(A1>=50, "Pass", "Fail")

2. IF with Text Values

=IF(B2="Yes", "Approved", "Denied")

3. Nested IF for Multiple Conditions

=IF(A2>90, "A", IF(A2>80, "B", "C"))

4. IF with AND Function

=IF(AND(A1>50, B1>50), "Pass", "Fail")

5. IF with OR Function

=IF(OR(A1>50, B1>50), "Pass", "Fail")

6. IF for Blank Cells

=IF(A1="", "Missing", "OK")

7. IF for Errors using ISERROR

=IF(ISERROR(A1/B1), "Error", A1/B1)

8. IF with Dates

=IF(A1<TODAY(), "Past Due", "On Time")

9. IF for Conditional Formatting

Example: Color cells based on IF result.

10. IF with Checkboxes

Example: Apply IF based on ticked checkboxes.

11. IF and SUM

=IF(SUM(A1:A5)>100, "High", "Low")

12. IF with COUNTIF

=IF(COUNTIF(B2:B10, "Yes")>5, "Majority Yes", "Majority No")

📝 9 Essential Formulas Every Beginner Should Know:

=SUM()
=AVERAGE()
=COUNT()
=IF()
=VLOOKUP()
=HLOOKUP()
=INDEX()
=MATCH()
=CONCAT()

🔧 11 Popular Functions to Boost Productivity:

NOW()
TODAY()
LEN()
LEFT()
RIGHT()
MID()
PROPER()
LOWER()
UPPER()
ROUND()
TRIM()

💡 Pro Tips to Stay on Track:

Double-check your formula syntax.
Use Formula Auditing to trace and fix errors.
Apply Conditional Formatting to visually spot results.

The Excel IF function is incredibly versatile. From grading systems to project management, once you master these examples, you’ll be able to handle almost any logical task in Excel.

Thank you so much for reading! 😊
👉 If you found this article helpful, please like, comment, or share it to help others.
I’d love to hear your feedback!

Sources:

09/11 Essential Formulas & Functions to Save Hours Every Week! No More Struggling with Excel?

noreply@blogger.com (Michael Leng) — Mon, 7 Jul 2025 21:50:00 +0700

Have you ever felt overwhelmed while working in Excel? You're not alone! Many people—whether students, office workers, or business owners—spend hours struggling with Excel tasks that could be done in minutes if they knew the right formulas and functions.

Master These 09/11 Essential Formulas & Functions to Save Hours Every Week!

In this post, I'm going to share 09 essential formulas and 11 popular functions that will not only save you time but also boost your productivity like a true Excel pro. So grab a cup of coffee, and let's dive in!

👉 Read more: Excel Shortcuts to Work Faster

📌 Why You Should Master Excel Formulas & Functions

✅ Save hours every week
✅ Reduce manual errors
✅ Impress your boss or colleagues
✅ Automate repetitive tasks

🔢 09 Essential Excel Formulas You Must Know

SUM
Formula: =SUM(A1:A10)
Add up numbers quickly without using a calculator.
AVERAGE
Formula: =AVERAGE(B1:B10)
Calculate the average of a range easily.
IF
Formula: =IF(C2>50,"Pass","Fail")
Make decisions based on conditions.
VLOOKUP
Formula: =VLOOKUP(lookup_value, table_array, col_index_num, FALSE)
Find values from a specific table column.
HLOOKUP
Formula: Similar to VLOOKUP but searches horizontally.
INDEX
Formula: =INDEX(array, row_num, [column_num])
Get values based on row and column numbers.
MATCH
Formula: =MATCH(lookup_value, lookup_array, 0)
Find the position of a value within a range.
COUNTA
Formula: =COUNTA(D1:D20)
Count non-empty cells.
ROUND
Formula: =ROUND(E2,2)
Round numbers to the desired decimal place.

🔥 11 Popular Excel Functions to Save Your Time

TEXT
Format numbers or dates into text.
Example: =TEXT(TODAY(),"dd-mm-yyyy")
CONCATENATE / CONCAT
Join text or values.
Example: =CONCAT(A2, " ", B2)
LEFT / RIGHT
Extract characters from text.
Example: =LEFT(F2,5)
LEN
Count characters in a cell.
Example: =LEN(G2)
NOW()
Insert current date and time.
TODAY()
Insert the current date only.
PROPER / UPPER / LOWER
Change text case.
Example: =UPPER(H2)
ISERROR / IFERROR
Handle errors gracefully.
Example: =IFERROR(VLOOKUP(...),"Not Found")
SUBTOTAL
Calculate subtotals dynamically.
RAND / RANDBETWEEN
Generate random numbers.
TRIM
Remove unwanted spaces.
Example: =TRIM(I2)

💡 Quick Tips to Improve Your Excel Game

✔ Practice using one formula per day until it sticks.
✔ Use color coding to highlight cells with formulas.
✔ Create a “Cheat Sheet” of your most-used formulas.
✔ Remember: Google and Microsoft Support are your best friends.

📝 Self-Check: Are You Excel-Ready?

Which formula calculates the average?
a) SUM
b) AVERAGE
c) COUNT
How do you remove extra spaces?
a) TRIM
b) LEN
c) CONCAT

(Answers: 1-b, 2-a)

🔗 Credible Sources:

Mastering these 09 essential formulas and 11 popular functions will transform the way you work with Excel—saving time, reducing errors, and boosting your confidence. Keep practicing, and you'll soon be the go-to Excel guru in your team!

🙏 Thank you for reading!
If you found this article helpful, please like, share, and leave a comment below.
👉 Read more: Boost Your Productivity with Excel Shortcuts

📊 Can’t Copy Excel as a Picture in SharePoint? Here’s the Fix (Desktop & Web Workarounds)

noreply@blogger.com (Michael Leng) — Mon, 7 Jul 2025 16:08:00 +0700

Hi there! 👋 If you’ve ever tried to copy an Excel chart or range as a picture into SharePoint and hit a wall, you’re not alone. Many Excel users—both beginners and seasoned pros—have faced this annoying issue.

In this post, I’ll walk you through why this happens and how you can fix it easily—whether you're using Excel for Desktop or the Web version inside SharePoint.

Let’s dive in!

💡 Why Can’t You Copy Excel as a Picture in SharePoint?

This issue typically comes down to:

Compatibility between Excel Desktop and SharePoint Online
Browser limitations
Security or permission settings in SharePoint
Clipboard function issues

🛠 Desktop Workarounds (Microsoft Excel App)

Use “Copy as Picture” in Excel Desktop:
- Select the cells or chart.
- Go to Home > Copy > Copy as Picture.
- Choose “As shown on screen” & “Picture”.
- Paste into Word or PowerPoint, then save as an image.
Screenshot Shortcut:
- Press Windows + Shift + S to take a quick screenshot.
- Paste directly into SharePoint or any document.
Save as Image File:
- Paste your copied image into Paint or any image editor.
- Save as .PNG or .JPG and upload to SharePoint.

✅ Tip: Always double-check your Excel and Office versions—older versions can behave differently.

🌐 Web Workarounds (Excel Online + SharePoint)

No Built-in “Copy as Picture” in Excel Web:
- Use Snipping Tool or Print Screen.
- Paste into Paint or another app, then save.
Office Clipboard:
- Try using the Office Clipboard (not the system clipboard) for better compatibility.
Export to PDF:

Save the Excel file as PDF, then extract images for SharePoint.

✅ Quick Troubleshooting Checklist:

Are you using the latest Office version?
Is SharePoint updated and accessible?
Do you have the correct permissions to edit the SharePoint page?
Try using a different browser (Chrome, Edge).

Copying Excel as a picture into SharePoint isn’t always straightforward, but with these practical workarounds, you can get the job done—whether on Desktop or Web. Don’t let tech hiccups slow you down!

🙏 Thank you for reading!
👉 If you found this helpful, please like, share, and follow this blog for more Excel tips, productivity hacks, and tech solutions.

Got questions? Drop them in the comments—I’m happy to help!

How to Use VLOOKUP in Excel: Quick Tips, Tricks, and Easy Examples📝

noreply@blogger.com (Michael Leng) — Sun, 6 Jul 2025 19:37:00 +0700

Have you ever found yourself lost in an ocean of Excel data, wishing there was a faster way to find exactly what you need? You're not alone. Many Excel users—beginners and even seasoned professionals—often struggle with looking up information in spreadsheets efficiently.

That's where VLOOKUP comes in!

In this guide, I’ll walk you through everything you need to know about how to use VLOOKUP in Excel, step by step, with easy examples, helpful tips, and shortcuts to make your work smoother and faster.

What is VLOOKUP in Excel?

VLOOKUP stands for Vertical Lookup. It's an essential Excel function used to search for a value in the first column of a table and return a value in the same row from another column.

It’s like asking Excel:
📌 "Hey, find this item in my list and tell me something about it."

The Basic VLOOKUP Syntax:

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

lookup_value: The value you want to search for.
table_array: The range of cells containing the data.
col_index_num: The column number to return the value from.
range_lookup: TRUE (approximate match) or FALSE (exact match).

Practical Example (Step-by-Step):

Imagine you have this table:

Product	Price
Apple	$1
Banana	$2
Orange	$3

To find the price of Banana:

=VLOOKUP("Banana", A2:B4, 2, FALSE)

✅ Result: $2

Common VLOOKUP Mistakes (and How to Fix Them):

#N/A Error ➡ Check if the lookup value exists.
#REF! Error ➡ The column index might be higher than the number of columns in your range.
Wrong Match Type ➡ Always use FALSE for exact matches unless approximate is truly what you need.

Quick Tips & Tricks:

✅ Use Named Ranges to make formulas cleaner.
✅ Combine with IFERROR:

=IFERROR(VLOOKUP("Apple", A2:B4, 2, FALSE), "Not Found")

✅ Remember: VLOOKUP only looks to the right. If you need to search left, use INDEX-MATCH.

VLOOKUP vs XLOOKUP: (2024 Update)

Newer versions of Excel support XLOOKUP, which is more flexible and powerful. If you’re using Office 365, consider learning XLOOKUP too.

VLOOKUP for Multiple Sheets:

You can even use VLOOKUP across different sheets:

=VLOOKUP("Apple", Sheet2!A2:B10, 2, FALSE)

VLOOKUP Limitations:

Can’t look to the left.
Slower with very large data.
Fails with dynamic data unless tables are updated.

Additional Resources:

Before You Go: Quick Recheck Tips:

✅ Double-check for typos in lookup values.
✅ Ensure your data range is correct.
✅ Use absolute references ($) if copying the formula.

Mastering VLOOKUP doesn’t have to be intimidating. With these tips, tricks, and easy examples, you can confidently use VLOOKUP to find data faster and work smarter in Excel.

👉 Thank you for reading! If you found this helpful, please like, comment, or share this post to help others who are learning Excel too.

9 Easy-to-Understand Examples of Using VLOOKUP - Just Follow Along and You'll Get It Right Away | exceltip

noreply@blogger.com (Michael Leng) — Tue, 7 Nov 2023 19:15:00 +0700

Deal the VLOOKUP in an easy way right here

Hello, my name is Leng. Today I would like to share an essential formula for office workers or decision-makers who need to measure and control numerical data.

The VLOOKUP formula has the following structure:

=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

Meaning of each parameter:

lookup_value: The value you want to search for in the table.

table_array: The data range you want to search within.

col_index_num: The column number that contains the data you want to display.

range_lookup: TRUE (or 1) if you want an approximate match or FALSE (or 0) if you want an exact match.

Example: Simulate data in an Excel table.

| Data for filling out the formula

A B C

1 Product ID Product Name Price

2 101 Laptop 800

3 102 Smartphone 500

4 103 Tablet 300

5 104 Desktop 1200

6 105 Smartwatch 150

Suppose you want to find the price of "Tablet," which has a product code of 103 using the VLOOKUP formula:

=VLOOKUP(103, A2:C6, 3, FALSE)

lookup_value: The value you want to search for is 103 (product code).

table_array: The data range you want to search within is A2:C6 (columns A to C and starting at cell A2).

col_index_num: The column that contains the data you want to display is 3 (price).

range_lookup: We use FALSE for an exact match.

The above formula will search for the product code 103 in the table and return the price of "Tablet" (code 103), which is 300.

Next, I will show how to enter values to get different results:

VLOOKUP Basics:

In the product table, use VLOOKUP to find the price of "Tablet" (product code 103):

=VLOOKUP(103, A2:C6, 3, FALSE)

Result: 300

VLOOKUP with TRUE (Approximate Match):

Use VLOOKUP to find the price of a product with the code "A102" (approximate match):

=VLOOKUP("A102", A2:C6, 3, TRUE)

Result: 500

VLOOKUP with FALSE (Exact Match):

Use VLOOKUP to find the price of "Laptop" (exact match):

=VLOOKUP("Laptop", A2:C6, 3, FALSE)

Result: 800

VLOOKUP as Text:

Use VLOOKUP to find the price of a product with the name "Smartphone" (as text):

=VLOOKUP("Smartphone", A2:C6, 3, 0)

Result: 500

VLOOKUP Searching a Value Stored in a Cell:

Use VLOOKUP to find the price of a product with the code in cell A2:

=VLOOKUP(A2, A2:C6, 3, FALSE)

Result: 800

VLOOKUP from the Leftmost Column:

Use VLOOKUP to find the price of "Tablet" using columns starting from the leftmost:

=VLOOKUP(103, A2:C6, 1, FALSE)

Result: 103

VLOOKUP for Sorted Lookup:

Use VLOOKUP to find the price of "Tablet" using CHOOSE to specify the starting column:

=VLOOKUP(103, CHOOSE({1,2,3}, A2:A6, B2:B6, C2:C6), 3, FALSE)

Result: 300

VLOOKUP Using INDEX to Retrieve Data:

Use VLOOKUP to find the price of "Smartwatch" using INDEX:

=VLOOKUP("Smartwatch", INDEX(A2:C6, , 2), 0)

Result: 150

VLOOKUP Searching in a Named Range:

Use VLOOKUP to find the price of "Laptop" using the named range "ProductTable":

=VLOOKUP("Laptop", ProductTable, 3, FALSE)

Result: 800

I hope these 9 examples help you understand how to use VLOOKUP in Excel better!

...Share with you!!!

Thanks for spending your time with us.

Bye,

Posted by: Michael Leng

I've known, then I've grown.

See more articles:

5 Alternative Shortcut Ways Minimize Your Excel Workbook, Read It Now! | ExcelTip2Day

noreply@blogger.com (Michael Leng) — Sat, 19 Jun 2021 01:42:00 +0700

Do you use Microsoft Excel?

If yes, stay with me—I’ll show you how to manage your Excel workbook effortlessly.

Hello, I’m Michael Leng. Today, I’m excited to share five ways to minimize an Excel workbook to an icon.

Tip Quiz

What to do if your monitor screen upside down?

These methods apply to Excel 2013 (the version I use) and are for Windows operating systems.

I’ve discovered and tested five different techniques, which I’ll explain below.

5 methods minimize Excel workbook.

⟴ Use shortcut keys "Ctrl" and "F9"

⟴ Use shortcut keys "ALT", "Spacebar" and "F9"

⟴ Click on the "Minimize workbook" square box.

⟴ Clicking on the "Minimize" command in the "Quick Access Toolbar"

⟴ Use shortcut keys "Window Logo" and "M"

To make you more ease seeing all the four pictures clearly, I have made the construction of all the methods for you to follow any of them below.

👉 1st method:

Use shortcut keys "Ctrl" and "F9" together.

Windows shortcut

CtrlF9

👉 2nd method:

Use shortcut keys "ALT", "Spacebar" and "N" together.

Windows shortcut

ALTSpace barN

👉 3rd method:

Click on the little square box as shown in the figure immediately below.

👉 4th method:

Click on the "Minimize" command in the "Quick Access Toolbar" at the top left of the workbook as shown in the figure immediately below.

👉 5th method:

Use shortcut keys the "Window logo key" button and "M" letter key

Windows shortcut

Do you know?

I really hope today's post helps you work with Excel more efficiently. Excel has a ton of useful functions, but many users aren’t aware of them.

For example, in my post, I shared five tips on minimizing an Excel workbook from full screen to an icon.

Not everyone knows all five methods—most people only use one or two. Even if someone is familiar with these five techniques, they might not recognize or use every one of them.

I’m the same way—I usually stick to the method I find easiest. However, I love learning new things, and whenever I discover something useful, I make sure to share it.

That’s why I’ve posted this guide: "5 Alternative Shortcut Ways to Minimize Your Excel Workbook"—so you can benefit from these tips too!

If you want to become a smarter Excel user, stay connected with our blog, ExcelTip2Day. We’ll keep searching for shortcuts, tips, tricks, and anything Excel-related that can help you—and share them here!

Thanks for spending time with us.

Bye,

Posted by: Michael Leng

I've known, then I've grown.

See more articles:

Ctrl+Shift+& Excel Shortcut Apply Border The Selected Cell Outline | Exceltip2day

noreply@blogger.com (Michael Leng) — Thu, 10 Jun 2021 11:52:00 +0700

Hello there.

I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about how to use the shortcut:

Ctrl+Shift+&

Tip Quiz

Do you know how to undo last action (multiple levels) Excel shortcut key?

Link recommended👉 : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'

Link recommended👉 : English Numbers In Words 1 to 1000000

In Microsoft Excel Office Program, it's very simple to be made a quick square border to the selected cell(s) in Excel spreadsheet.

Method:

Select the active cell(s) where you want to apply the border (e.g. as the image below is B3 : D6)
Press the "Ctrl" button on your keyboard and keep holding it.
Press the "Shift" button and keep holding it as well.
Then press the "&" button.

Then release all the three buttons.

Instantly, the square outline border of the currently selected cells is going to be displayed.

Note:

This shortcut will help you to make the only single one square border. If you select the active cell more than one cell, it will work for outline border.

Shortcut for: Apply the outline borderlines on to the selected cells in the Excel spreadsheet.

Windows shortcut

CtrlShift&

Figure: Shortcut key to handle the outline of cells.

Tip Answer

Before I am about to say goodbye to you, I hope that what I have posted and shared with you today. They will be beneficial for you, your company, and any relevant.

If you love it, I will be happy. If you share this with your friends, I will be shiny.

I hope to receive any feedback from you guys. Because they will be such treasures--any error in this blog--for future improvement.

Thanks for reading.

Bye,

Posted by: Michael Leng

I've known, then I've grown.

See more articles:

Excel Trick Press A Couple Of [Arrow Key] Move One Cell Diagonally | Excetip2day

noreply@blogger.com (Michael Leng) — Thu, 10 Jun 2021 11:41:00 +0700

Hello there!

I'm Michael, and today on my blog, “Exceltip2day,” I’m going to share a useful tip:

👉 How to move diagonally from one cell to another in Excel using shortcut keys.

Tip Quiz

Do you know what is the shortcut of deleting Cell(s) in Excel Worksheet?

How Do You Move Diagonally in Excel Using Shortcut Keys?

Let’s say your current active cell is F10. You want to move diagonally to G9, H8, I7, and so on.

Here’s a simple trick to help you move diagonally from one cell to another using keyboard shortcuts.

🚀 4 Quick Ways to Move Diagonally in Excel:

1️⃣ Move Up and Right:
Press Up Arrow → then Right Arrow.

2️⃣ Move Up and Left:
Press Up Arrow → then Left Arrow.

3️⃣ Move Down and Right:
Press Down Arrow → then Right Arrow.

4️⃣ Move Down and Left:
Press Down Arrow → then Left Arrow.

By using these simple key combinations, you can move diagonally across your worksheet quickly without using your mouse.

Look at the image immidiately above, then to just press the bottoms below at the same time for the thick no. 1 to no. 4.

👉 Trick no. 1

To move one cell pointer diagonally from F10 to G9

Up ArrowRight Arrow

👉 Trick no. 2

To move one cell pointer diagonally from F10 to G12

Down ArrowRight Arrow

👉 Trick no. 3

To move one cell pointer diagonally from F10 to E9

Up ArrowLeft Arrow

👉 Trick no. 4

To move one cell pointer diagonally from F10 to E12

Down ArrowLeft Arrow

Hope this trick helps you with dealing an Excel workload.

Tip Answer

👉 Recommended Links:

🔗: Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'

🔗: English Numbers In Words 1 to 1000000

Before I say goodbye, I truly hope that what I’ve shared with you today will be useful for you, your work, your company, or anyone who needs it.

If you enjoyed this post, I’d be very happy!

And if you share it with your friends, I’ll be even happier—it will feel like I’m shining with a big smile 😊.

I’d love to receive any feedback or suggestions from you. Your comments are like treasures that help me improve this blog for everyone’s benefit.

Thank you for reading!
Bye for now,

Posted by: Michael Leng

I've known, then I've grown.

See more articles:

Ctrl+0(Zero) Excel Shortcut Key To Hide The Selected Column | ExcelTip2Day

noreply@blogger.com (Michael Leng) — Fri, 7 Sep 2018 11:58:00 +0700

Hello there!

I'm Michael Leng. Welcome to my blog, “Exceltip2day”.
Today, I’m going to share a useful Excel shortcut key:

👉 Ctrl + 0 (Zero) — This shortcut hides the selected column in Excel.

Tip: Quiz

Do you know what is the shortcut key to insert the current date in any cell of a worksheet?

In this article, I’ll explain:
✅ How to use the Ctrl + 0 shortcut to hide columns in an Excel worksheet.
✅ Why this shortcut can help you work faster and more efficiently.

Tabs to Explore:

🔗 Learn Thai By Sentences
🔗 En Numbers In Words

In this article, it consists of how to use the shortcut keys to hide the selected column in an Excel sheet.

Here is the table of the shortcut key buttons to proceed to hide the column.

Shortcut for: Hide the selected column.

Windows shortcut

Ctrl0(Zero)

Now, I'll tell you the step by step of using the shortcut key buttons.

👉 Use your mouse click into any cell of the column you want to hide.

👉 Press the Ctrl+0 key buttons at the same time.

👉 Release your fingers out of the buttons.

See the snapshot below which is showing how to operate it.

Figure no.1 shows cell Column "C" before getting hidden.

Figure no.2 shows the cell Column C after getting hidden

That brings me to the end of my posting.

So, from now on, if you would like to hide any column in your Excel sheet, you know to use the shortest way to handle your task quicker than the regular method.

Tip: Answer

Link recommended👉 : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'
Link recommended👉 : English Numbers In Words 1 to 1000000

Before I say goodbye,

I truly hope that what I’ve shared with you today will be helpful for you, your company, or anyone else who finds it useful.

If you enjoyed this post, I’d be very happy to hear that!

And if you think this article could help others, please feel free to share it—I’ll be smiling widely knowing that you’ve helped spread this Excel tip and shortcut to more people.

I would love to receive any feedback from you. Your comments and suggestions are like treasures that can help me improve this blog for the future.

Thank you so much for reading!

Bye for now!

Posted by: Michael Leng

I've known, then I've grown.

See more article:

Ctrl+; Shortcut Excel To Insert The Current Date In Any Cell Of A Worksheet | ExcelTip2Day

noreply@blogger.com (Michael Leng) — Mon, 27 Aug 2018 21:24:00 +0700

Hello there.

I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about:

Ctrl + ; To Insert The Current Date.

Figure no.1 Shown how to proceed with the shortcut key "Ctrl" + " ; "

Tip Quiz

What is the shortcut to delete cell(s) in Excel Worksheet?

Yes, it's not complicated at all if you are trying to insert the current date into any cell in an Excel worksheet.

Just follow the step by step Keyboard Excel and Shortcut key as below:

In the cell B4, just press and hold down the " Ctrl " key button.

While holding, pressing the other key, it's the " ; " button.

Then the cell B4 will turn out the result of the current date as shown as figure no. 2 as below. (The date 25/8/2018 is the date that I have input the formula and prepared it for adding onto this post)

Figure no.2 Shown the result of the current date.

** To correct the mistaken words in the figure no.2 from "C4" to "B4"

Shortcut for: Insert the current date.

Windows shortcut

Ctrl ;

***

Now, you can check the answer for the tip quiz right below;

Tip Answer

Ctrl+'(apostrophe) To Fill Cell Formulas Down From The Adjacent Cell Above | Exceltip2day

noreply@blogger.com (Michael Leng) — Fri, 10 Aug 2018 14:35:00 +0700

Hello there.

I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about:

Ctrl + ' (apostrophe)

Tip Quiz

What is the shortcut key to select the entire worksheet or the data-containing area?

In Excel worksheet, if you have filled some formulas into a cell. And if you want to use those formulas again, but for the cell which is beneath them.

You just only the 2 keys as the shortcut to operate it as the instruction as follows:

Shortcut for: To fill cell formulas down and edit.

Windows shortcut

Ctrl '

To let you see more in the clear picture, take a look the figures describe all steps below:

👉 In the cell B2, it contains the formula syntax " =1+1" (Take a look the figure no. 1)

Figure no. 1 Show the formula = 1+1 in cell B2

👉 In this step, pay attention to the cell B3. For this step, just press the 2 keys Ctrl + ' into the cell B3 and move your fingers out of them.

Figure no.2 Show how to use the shortcut key Ctrl + ' in the cell B3

👉 In this last step, take notice in the cell B3. You will see the formula which is the same as the cell B2.

Figure no.3 Show the result of the same formulas as the above cell.

Tip Answer

Link recommended👉 : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'

Link recommended👉 : English Numbers In Words 1 to 1000000

That brings me to the end of my posting.

Before I am about to say goodbye to you, I hope that what I have posted and shared with you today. They will be beneficial for you, your company, and any relevant.

If you love it, I will be happy. If you share this with your friends, I will be shiny.

I hope to receive any feedback from you guys. Because they will be such treasures--any error in this blog--for future improvement.

Does it help?

Thanks for reading.

Bye,

Posted by: Michael Leng

I've known, then I've grown.

See more articles:

Ctrl+G Excel Shortcut Tip 2day.

[Ctrl+Shift+O(letter)] Excel Insert Comment Shortcut Way With Key Button

Ctrl + Shift + * (Asterisk) Excel Keyboard Shortcut Select Active Cells

4 Aspects Deleting: How To Use Keyboard Shortcut Ctrl+-(Minus) For Deleting Cell, Row, Column | ExcelTip2Day

noreply@blogger.com (Michael Leng) — Mon, 23 Jul 2018 22:04:00 +0700

Hello there!

I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about:

How to use "Ctrl" + "-"(Minus)

Tip Quiz

How to delete all the objects in an Excel worksheet? (Check answer at the end of this post)

In my article today, I'm going to show you how to use the shortcut key and its 4 deleted options for Excel users to select according to his/her aspects.

All the 4 options are as following;

Delete "Shift cell left"

Delete "Shift cell up"

Delete "Entire row"

Delete "Entire column"

Notify:

Please use it with care, it may cause your related data, such as formulas, table, border...

In case of wanting to resume your last action, you can redo (Ctrl + Y) and undo (Ctrl + Z) to fix it.

My article consists of 4 parts.

👉 1st part:

In the first part, you will see the "Tip Quiz" box questioning the benefits of an Excel tip. Of course, I guess you have seen it already as it is in the prior paragraph above.

👉 2nd part:

On the second part, now I will show you the shortcut excel keys to use for deleting cells, columns, and rows in 4 different purposes.

Windows shortcut

Ctrl -

👉 3rd part:

Refer to the shortcut from the 2nd part, here I'll describe and also show you all 4 purposes of deleting works.

Figure number 1. This is the scenario figure that I have prepared for you to be understood more easily.

It contains the 10 rows and 5 columns. In the mid, cell d5:d7, is the mark for future proceeding the "Ctrl" + "-".

Figure no. 1

Let' have a look the figure no.2 below, once I have pressed the "Ctrl" + "-" buttons, the square box " Delete?" will instantly show as you can see it in the image.

Then, I have selected the choice "Shift cells left"

Figure no. 2

Figure no. 3 shows us the result after I clicked on the "OK" button. The 3 cells from left columns move to replace the previous cells d3:d7.

Figure no. 3

Let's move to figure no. 4. In this image, I have selected the round checkbox "Shift cells up".

Figure no. 4

Figure no. 5. You can see the result after I deleted by "Shif cells up". The figure explains it very well, right?

Figure no. 5

Figure no. 6 below shows us how to delete by the "Entire row".

Figure no. 6

What's the figure no. 7 tell us. Good job! The row no. 4-6 have gone.

Figure no. 7

This is the last deleting aspects. It's the "Entire column" delete.

Figure no. 8

Hooyah, the entire column no. 3 has been disappeared. And the meantime, all the columns from the left moved and replaced respectively.

Figure no. 9

👉 4th part:

The tip answer, this is for you to find your best choice. Also, you can check both its answer and data source.

Tip Answer

Link recommended👉 : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'
Link recommended👉 : English Numbers In Words 1 to 1000000

Now, that's the end of my presentation.

Thanks for reading.

Bye,

Posted by: Michael Leng

I've known, then I've grown.

See more articles:

How Can I Calculate Any Date In Excel Worksheet? - Check Formula “=today()” | Exceltip2day

noreply@blogger.com (Michael Leng) — Mon, 1 Jun 2015 11:03:00 +0700

Hello there.

I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about:

How to calculate "date" in Excel?

Tip Quiz

If you want to redo your last action (Multiple Levels) in your Excel sheet, what are you going to do?

YOU! Do you know that in Excel office program having a function calculate “DATE”?

Yes, the function of date value calculation is formed with the syntax “=today()”

A formula to calculate any date in Excel

=today()

The benefits of this formula:

It will give an automatically value of the “CURRENT DATE” whenever it is loaded,-auto refresh.

The following is the step handling the function:

👉 Click into any cell in your Excel worksheet.

👉 Fill out the syntax formula =today().

👉 Edit the formats to display as your determine.

Fill out =today() into any cell.

The result is given as the DATE shown.

The "Format Cell" function for edit your format.

Does it help?

Hopefully, this today's formula post is beneficial for you.

Tip Answer

Link recommended👉 : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'

Link recommended👉 : English Numbers In Words 1 to 1000000

Before I am about to say goodbye to you, I hope that what I have posted and shared with you today. They will be beneficial for you, your company, and any relevant.

If you love it, I will be happy. If you share this with your friends, I will thank you for a million to you.

See you again.

Thanks for reading.

Posted by:Michael Leng

I've known, then I've grown.

See more other tips:

How To Use "=NOW()" Formula And Get Current Date And Time (Varies) In Excel | Exceltip2day

noreply@blogger.com (Michael Leng) — Sun, 31 May 2015 22:10:00 +0700

See how to use "NOW()" formula in Excel

Figure 1. Shown the prospect cell to show the current date and time

In this post, you will see how to use the "=NOW() Formula"

Previously, if someone questioned me, “How will I get such as the "Updating Current Date And Time" as the mention above?” I would doubt.

How about you?

Don't worry. Today I'm going to show you how to obtain it.

Hello everyone. My name is Leng, You can see me and my posts about Excel tips, shortcuts, and how to fix any error here--through my blog "ExcelTip2Day"

Tip Quiz

What to do if your monitor screen upside down?

In the Excel office program, there are many formulas and functions to help users to handle their job easily.

Today, this blog, “Exceltip2day”, is going to describe to you the method of how to find out the “Current Date and Tine” with formula in an Excel worksheet.

The following is the syntax of Excel formula to use for sending out the result of “Current Date and Tine”

=now()

The benefits of this formula:

It will give the automatically updating date and time whenever that Excel sheet file is opened, - auto refresh.

How to use it step by step below:

👉 1 step:

Select your prospect cell in your Excel spreadsheet (See figure no.1)

👉 2 step:

Fill out the formula immediate below inside it (See figure no. 2)

=now()

See the image below for more easier understanding.

Figure 2. Shown the "=now" syntax formula is entered in cell B3

Figure 3. Shown the return of a Date Value.

There, you will see the result, the Current Date shown in the cell B3 already. Yet, if you would like to show more the Current Time as well. Thus, you have to custom your format cell to dd/mm/yyyy h:mm as per the figure no. 4 below.

Figure 4. Shown how to custom the Current Time.

Right here, the final result of our tips on how to use the "=NOW()" Formula, showing you the completed Date and Time actively.

Figure 5. Shown the Current Date and Time.

Hope the tip on how to use "=NOW()" Formula will be useful for you accordingly.

Tip quiz: Answer

Link recommended 👉: How Can I Calculate Any Date In Excel Worksheet?

Link recommended 👉: Trick To Selecting All Active Cells In A Range Of Excel Spreadsheet

Does it help?

What do you think?

Before I am about to say goodbye to you, I hope that what I have posted and shared with you today. They will be beneficial for you, your company, and/or any relevant.

If you love it, I will be happy. If you share this with your friends, I will be shiny.

And, I hope to receive any feedback from you guys. Because they will be such treasures--any error in this blog--for future improvement.

See you again.

Thanks for reading.

Posted by: Michael Leng

I've known, then I've grown.

See more other tips:

Ctrl+" Quick Way To Copy and Paste The Entered Data To The Immediate Underneath Cell | Exceltip2day Blog

noreply@blogger.com (Michael Leng) — Sun, 22 Feb 2015 17:15:00 +0700

Hello there.

I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about:

Ctrl + "

Tip Quiz

What is the shortcut to erase the selected lines border of the cells?

In Excel worksheet, if you want to make the copy and paste function the entered data of the above cell to the adjacent below cell.

The Exceltip2day blog has already described to you the quickest ways and illustrated image for understanding and follow it by yourself.

Shortcut for: To Auto fill cell values down and edit from the cells above.

Windows shortcut

Ctrl "

Do the below steps;

👉 1] Find the cell you want to copy. For example, you will see the image below supposing to copy the entered data from the cell B3.

👉 2] Go to the immediate underneath cell you want to paste data into. In here, it's the cell B4.

👉 3] Press the button, [ Ctrl ] and [ "(Quotation mark) ]. Then, suddenly the data will appear in the cell B4 as the same as the data of the cell B3 above.

Tip Answer

Link recommended👉 : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'

Link recommended👉 : English Numbers In Words 1 to 1000000

Before I am about to say goodbye to you, I hope that what I have posted and shared with you today. They will be beneficial for you, your company, and any relevant.

If you love it, I will be happy. If you share this with your friends, I will be shiny.

I hope to receive any feedback from you guys. Because they will be such treasures--any error in this blog--for future improvement.

Thanks for reading.

Bye,

Posted by: Michael Leng

I've known, then I've grown.

See more articles:

Little Known Ways: Simply Deleting Cell(s) in Excel Worksheet - [Ctrl] + [-](Minus button)

noreply@blogger.com (Michael Leng) — Thu, 19 Feb 2015 11:43:00 +0700

Let’s come together to see the simple task but it’s very beneficially for everybody who uses Excel office or love to learn more new way to deal with it.

Here I am going to tell you how to delete empty cell(s) or cell(s) with the data entered.

Do the following:

Selecting any cell(s) to be deleted
Press the keyboard button "Ctrl" and "-"(Minus button)
Click to select any deleting type (Shift cells left, Shift cells up, Entire row, Entire column)
Then click to “OK” button

See more images below for more clear.

Selecting the cell A5 and click Ctrl, - together

Select one of the 4 choices above as you desired

Image of the completion after the task done.

Bye,
Micheal Leng.

See more other tips:

How To Use "Select Object" Selecting All The Rectangular Region Of Pictures And Deleting | Exceltip2day

noreply@blogger.com (Michael Leng) — Sat, 11 Oct 2014 21:08:00 +0700

Hello there.

I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about:

How to use the “Select Object” tool in Excel?

Tip Quiz

What is the shortcut key to select the entire column?

The “Select Object” tool is a very good function to handling all about the object like pictures, shapes,
SmartArt…

In this article, I am going to tell you how to use the “Select Object” for SELECTING multi-objects and delete them all.

Do the following:

On the ribbon bar, click the “Find & Select”

Click over the “Select Object” tool.

Press and hold down the SHIFT button.

Drag mouse to select all over the objects you want.

Press the “Delete” button.

To be more understood, you can see all the methods step by step through all the images respective below.

Figure no.1 Click the "Select Object."

Figure no.2 Drag over the objects.

Figure no.3 All objects are selected.

Figure no.4 Empty cell after deleting.

Tip Answer

Link recommended👉 : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'

Link recommended👉 : English Numbers In Words 1 to 1000000

Thanks for reading.

Bye,

Posted by: Michael Leng

I've known, then I've grown.

See more articles:

How To Format The Entire Cells In A Workbook With Just Only A Single Click | Exceltip2day

noreply@blogger.com (Michael Leng) — Sun, 5 Oct 2014 17:00:00 +0700

Hello there.

I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about:

How to re-format the multiple data entered in an Excel sheet.

Tip Quiz

Do you know what is the Excel shortcut key for call out "Insert Function" Dialog Box?

Do you know the very shortest way to format the entire cells in a worksheet?

Fortunately, this following method is the best trick as far as I have ever known. It helps you to format the entire cells in a workbook to be the only one unique format. More, it does not complicate at all.

Here comes the step-by-step shortcut:

Select the original format cell as wanted. (Ex. Cell “B3”).

Click on the “Format Painter” icon on the top left corner.

Press the “Ctrl” “A” buttons on your keyboard.

Done! The outcome should be the same as the images beneath.

Figure no.1 Shows the format of the entered data with none arrangement.

Figure no.2 Shows the format of the entered data after arrangement.

Tip Answer

Link recommended👉 : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'

Link recommended👉 : English Numbers In Words 1 to 1000000

Before I am about to say goodbye to you, I hope that what I have posted and shared with you today. They will be beneficial for you, your company, and any relevant.

If you love it, I will be happy. If you share this with your friends, I will be shiny.

I hope to receive any feedback from you guys. Because they will be such treasures--any error in this blog--for future improvement.

Thanks for reading.

Bye,

Posted by: Michael Leng

I've known, then I've grown.
See more articles:

Trick To Copy With “Format Painter” With A Single Click But Unlimited Multiple Pastes | Exceltip2day

noreply@blogger.com (Michael Leng) — Wed, 1 Oct 2014 13:43:00 +0700

Hello there.

I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about:

How to use “Format Painter”

Tip Quiz

Is there any trick to exscape away Header and Footer?

How can I use “Format Painter” for unlimited multiple pastes?

As you might know that using the “Format Painter” Excel function is very useful and save time.

Nevertheless, not many people know the trick and enjoy using it in a very simple way.

Trick is:

1] Select the specific cell(S) that you want to copy the format. (Ex. as the image below is cell "A2")

2] To click twice quickly without moving the mouse (Double-clicking) onto the “Format Painter” function button.

3] Click to any cell(s) you want to paste the format.

4] Click on the “Format Painter” again to inactivate the task regards no more use.

Before "Format Printer"

Processing "Format Printer"

After "Format Printer"

Tip Answer

Link recommended👉 : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'

Link recommended👉 : English Numbers In Words 1 to 1000000

Thanks for reading.
Bye,

Posted by: Michael Leng

I've known, then I've grown.

See more articles:

Compare Percentage Result Between Excel Formula [Average] And [Averageif Exclude "0"]

noreply@blogger.com (Michael Leng) — Mon, 29 Sep 2014 21:16:00 +0700

Do you know the result of percentage not the same if there is the number “0” within the Range of "Average" Formula?

Therefore, how do you solve this problem?

To obviously visible what the difference between using Average Formula between the range of the number “Include 0” and “Exclude 0”.

1] Let us have a look at the first sample. We have the table for the whole year of the sales amount.

However, there are the two months, which are with the “0” sales amount(Empty cells), July and August.

We use Excel formula “=AVERAGE(AB5:AB16)” to calculate the percentage average from January-December. The outcome is 76.11%. That would be true?

2] The second sample, we use all the same data as the number one. On the other hand, we have changed the formula to use “=AVERAGEIF(AB5:AB16,"<>0")” instead. Here we gain 91.33%

It does not matter what our calculation criteria is, here, my article is just only to show you how the two formulas work in a different way. You can pick any of them and use it as you want.
Thanks for reading.

Bye,

Posted by: Michael Leng

I've known, then I've grown.

See more other tips:

How To Align Number To Be At The Center Of Active Cell(S) In Excel's Workbook.

noreply@blogger.com (Michael Leng) — Fri, 26 Sep 2014 23:52:00 +0700

Cell is with the decimal number inside it. The number usually keeps at the right of the border. Anyway, if you want to format those figures to be in the middle of cell's border. It is not too difficult at all to do that.

Hereafter is the step-by-step format cell to center the figures being in the middle:

Select the cells to be centered. (Cell "B5" ex. image below).
Click on the Format Cells > Number > Custom > To type #,##0.00 into the code box. (Type the among of digit as same as the data entered)

Before

Process

After

If it doesn't work. Align the format cell by clicking the center like below image.

See more other tips:

Would you like to surf my other blogs?

How To Escape Away From Header And Footer To Normal View | Exceltip2day

noreply@blogger.com (Michael Leng) — Thu, 25 Sep 2014 12:51:00 +0700

With my real experience about using “Header and Footer”, function. I have been frustrated looking around for how to escape away from the view’s status of “Header and Footer”.

Firstly, I thought it should have the way out by clicking on the bottom of itself, “Header and Footer”.

After I had searched it for a while. I could make it out and want to share you all as bellow:

Method of away out from “Header and Footer” view to Normal view.

1] Hover your mouse to the “View” tab and click on it.
2] Click on any cell that out of the “Header and Footer” blank space.
3] Click on the “Normal” tab.
4] Immediately, save your file.

Header and Footer Status

Select cell A2 which is out of Header blank space

Become to Normal View

Then, try to close and re-open your file again. It should show you with the normal view. If not, repeat the method above again. (Do not forget to save your file immediately after your page become to “Normal View” status.)

See more other tips:

Would you like to surf my other blogs?

Technical Tip To Select Or Copy Data Entered Between Range Of The Particular Cells And Uppermost Cell (A1) | Exceltip2day

noreply@blogger.com (Michael Leng) — Sun, 21 Sep 2014 20:20:00 +0700

Hello there.

I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about:

How to select the cells range

Tip Quiz

What is the shortcut to minimize an Excel workbook?

One technical tip of Excel using of today that I want to share you all, it is the only private trick that I have tried many times to discover the simple way to copy the data entered between the range of particular cells and an uppermost cell (A1).

Eventually, I found the ideal way to copy or select the desired group of cells as follow:

As per the screenshot for an example to show, you right here. Suppose to select and/or copy the wanted cells, which begins from the cell “E13” and the cell “A1”. Including all cells in the range to the upward, cell “E1”, and to the leftward, cell “A13”

1] Hover your mouse to cell "E13" and "Click" on it. (In yellow)

2] Press "Ctrl" "Shift" "Home" buttons at the same time together.

Get Done! Now, you can do whatever as you desire such copy, delete, format,...

Tip Answer

Link recommended👉 : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'

Link recommended👉 : English Numbers In Words 1 to 1000000

Before I am about to say goodbye to you, I hope that what I have posted and shared with you today. They will be beneficial for you, your company, and any relevant.

If you love it, I will be happy. If you share this with your friends, I will be shiny.

I hope to receive any feedback from you guys. Because they will be such treasures--any error in this blog--for future improvement.

Thanks for spending your time with us.

Bye,

Posted by: Michael Leng

I've known, then I've grown.

See more articles:

Excel Tips, Tricks, and Shortcuts

Is Scroll Lock really bothering you? Check how to solve the turn off scroll lock issue! | Excel Tips

💥Understanding Scroll Lock: The (Often Unwanted) Navigator

👀The Tell-Tale Sign: The Excel Status Bar

👉Solution 1: The Physical Scroll Lock Key – The First Stop

👉Solution 2: The On-Screen Keyboard (OSK) – The Universal Fix for Windows Users

Troubleshooting & Quick Checks for Persistent Issues

Tips to Prevent Future Scroll Lock Annoyances

Regain Control of Your Excel Navigation!

Extending the =TODAY() Excel Formula Creatively: Displaying Today, Tomorrow, and Beyond Automatically! (Plus 9 Essential Formulas & 11 Popular Functions You Should Know) 🚀

The Magic of =TODAY(): Your Ever-Present Date

Stepping into the Future: Showing Tomorrow and Beyond

Going Back in Time: Displaying Past Dates

Formatting Your Dates for Clarity

9 Essential Excel Formulas You Absolutely Need to Know 🚀

11 Popular and Incredibly Useful Excel Functions to Supercharge Your Spreadsheets 🚀

Tips to Recheck If You're in Good Shape: ✅

Your Dynamic Date Journey Begins! 🚀

📊 12 Examples of Excel IF Function Made Simple: Step-by-Step Guide

📊 12 Examples Excel IF Function Made Simple: Step-by-Step Guide

🌟 What is the Excel IF Function?

Before we dive into how to use the IF function, let’s first take a look at its syntax and what it does.

Breakdown of Each Part:

✅ 12 Practical Examples of Using IF Function in Excel:

1. Basic IF Example: Pass or Fail

2. IF with Text Values

3. Nested IF for Multiple Conditions

4. IF with AND Function

5. IF with OR Function

6. IF for Blank Cells

7. IF for Errors using ISERROR

8. IF with Dates

9. IF for Conditional Formatting

10. IF with Checkboxes

11. IF and SUM

12. IF with COUNTIF

📝 9 Essential Formulas Every Beginner Should Know:

🔧 11 Popular Functions to Boost Productivity:

💡 Pro Tips to Stay on Track:

Sources:

09/11 Essential Formulas & Functions to Save Hours Every Week! No More Struggling with Excel?

📌 Why You Should Master Excel Formulas & Functions

🔢 09 Essential Excel Formulas You Must Know

🔥 11 Popular Excel Functions to Save Your Time

💡 Quick Tips to Improve Your Excel Game

📝 Self-Check: Are You Excel-Ready?

🔗 Credible Sources:

📊 Can’t Copy Excel as a Picture in SharePoint? Here’s the Fix (Desktop & Web Workarounds)

💡 Why Can’t You Copy Excel as a Picture in SharePoint?

🛠 Desktop Workarounds (Microsoft Excel App)

🌐 Web Workarounds (Excel Online + SharePoint)

✅ Quick Troubleshooting Checklist:

🔗 Read More:

How to Use VLOOKUP in Excel: Quick Tips, Tricks, and Easy Examples📝

What is VLOOKUP in Excel?

The Basic VLOOKUP Syntax:

Practical Example (Step-by-Step):

Common VLOOKUP Mistakes (and How to Fix Them):

Quick Tips & Tricks:

VLOOKUP vs XLOOKUP: (2024 Update)

VLOOKUP for Multiple Sheets:

VLOOKUP Limitations:

Additional Resources:

Before You Go: Quick Recheck Tips:

9 Easy-to-Understand Examples of Using VLOOKUP - Just Follow Along and You'll Get It Right Away | exceltip

Deal the VLOOKUP in an easy way right here

5 Alternative Shortcut Ways Minimize Your Excel Workbook, Read It Now! | ExcelTip2Day

Do you use Microsoft Excel?

Tip Quiz

Windows shortcut

Windows shortcut

Do you know?

Ctrl+Shift+& Excel Shortcut Apply Border The Selected Cell Outline | Exceltip2day

Ctrl+Shift+&

Tip Quiz

Do you know how to undo last action (multiple levels) Excel shortcut key?

Windows shortcut

Excel Trick Press A Couple Of [Arrow Key] Move One Cell Diagonally | Excetip2day

Tip Quiz

Do you know what is the shortcut of deleting Cell(s) in Excel Worksheet?

The Magic of `=TODAY()`: Your Ever-Present Date