Excel.Xpress

Excel.Xpress Excel_Xpress is dedicated to helping individuals and organizations build a solid foundation in Micro

27/05/2025

πŸ§ πŸ’‘ Excel Scroll Hack - The Secret Key That Fixes Broken Scrolling!

Ever had your Excel arrow keys suddenly start scrolling the ENTIRE sheet instead of moving cell by cell? 😩

This exact question came up during our AI Enhanced Excel For Business & Analytics training session:

"Sir, why is my arrow key scrolling the whole sheet instead of moving cell by cell?" 😩

Here's the truth: 99% of the time, it's the sneaky SCROLL LOCK key! πŸ”“
This tiny troublemaker is the most underrated villain on your keyboard, and it's probably been messing with you without you even knowing it exists!

🎯 In this Excel Scroll Hack video, I reveal:
βœ… The real reason this happens (hint: it's not broken Excel!)
βœ… 10-second fix that works every time
βœ… Special solution for laptops WITHOUT a Scroll Lock key
βœ… Pro prevention tips so this never catches you off guard again

Stop letting this simple issue slow down your productivity! Master this fix and get back to crushing your Excel tasks like a pro. πŸ’ͺ

Watch | Like | Share | Follow | Comment | on Excel.Xpress Excel_Xpress

What's the most frustrating Excel glitch you want me to tackle next? Drop it in the comments below! πŸ‘‡


~ Acha Linus

Guess The Year & Win a FREE Excel Class! πŸ“Š - Excel_XpressHey friends! A few years ago, I embarked on a career and person...
15/05/2024

Guess The Year & Win a FREE Excel Class! πŸ“Š - Excel_Xpress

Hey friends! A few years ago, I embarked on a career and personal life transformation, and I can confidently say that the time and resources invested have been worthwhile. However, I've learned that the journey of transformation is a continuous process of learning and growth because "The skill it takes to start anything is not the skill it takes to remain, last, and outlast." So, whatever level you are, you need to Learn! Learn!! Learn!!!

I'm feeling nostalgic today and decided to share three throwback pictures with you all. πŸ“· Can you guess what year Picture 2 was taken? πŸ€” If you get it right, you'll win a FREE Excel class with me - Excel_Xpress πŸŽ‰

Here's the deal:
πŸ” Picture 1: A blast from the past, 8 years ago! Can you believe how time flies?
πŸ”’ Picture 2: This one's a mystery, waiting for your detective skills to crack!
πŸ•°οΈ Picture 3: Captured in 2023, a glimpse into more recent memories.

To enter this challenge:
πŸ‘ Like this post and follow me!
πŸ” Take your best guess at the year Picture 2 was taken!
πŸ’¬ Leave your guess in the comments below!

To maximize the class, you MUST:

- Be ready and eager to learn Microsoft Excel (either at Basic, Intermediate, or Advanced levels).
- Have access to a Personal Computer (PC)
- Have a Strong Internet connection for an Online class.

Ready to sharpen your Excel skills further? Whether you're an individual looking to enhance your proficiency or a corporate organization seeking tailored training solutions, I'm here to help! With years of experience in training individuals and organizations on Excel, I offer comprehensive courses that cater to your specific needs and objectives.

Tag your friends to join the fun! The winner(s) with the correct guess will receive a FREE class with Excel_Xpress. Let's see who's got the sharpest eye for detail! πŸ”ŽπŸ’Ό

πŸ“ŒπŸ“ŒPlease note: This offer is valid until 11:59 PM on May 16th, 2024.

28/04/2021

Hello Excel Enthusiasts

What are your 3 most frequently used Excel Functions and Formulas?
Share with us - Excel_Xpress

ACCESSING YOUR WORKBOOK STATISTICSWorkbook Statistics is an amazing feature in Excel that provides you with the counts a...
21/04/2021

ACCESSING YOUR WORKBOOK STATISTICS

Workbook Statistics is an amazing feature in Excel that provides you with the counts and other information about your current worksheet and the entire workbook.

For instance, if you receive a workbook from a colleague and you want to know how many sheets it contains without scrolling through, try Workbook Statistics and get the result in splits of seconds.

STEPS:
1. Select the "Review" tab as highlighted on the attached image

2. Select "Workbook Statistics" which is directly under the "Insert" tab

Automatically, the information displays.

Shortcut Keys: Ctrl + Shift + G

NOTE: This same method of accessing Workbook Statistics is not available in Excel 2013 and older versions.

Try this out and share the valuable information you got about your workbooks/worksheets.

19/04/2021

To expressly view your workbook statistics, simply hit Ctrl + Shift + G

Hello Excel EnthusiastsDo you know you can EXTRACT FORMULA FROM A CELL AS TEXT?An Excel FORMULATEXT function helps you e...
02/04/2021

Hello Excel Enthusiasts

Do you know you can EXTRACT FORMULA FROM A CELL AS TEXT?

An Excel FORMULATEXT function helps you extract Formula as a Text string from a cell. This has been introduced in Excel for almost a decade now.

For instance, if a formula is used in a cell(s) and I want to show the formula array or the synthax to my students in a text form, then FORMULATEXT is the best deal in the game.

Looking at the image here, Column D (Full Name) contains CONCATENATE function which is the combination of Column B (Last Name) and Column C (First Name).
Then Column E (FORMULATEXT) displays the formula in Text form.

The synthax is very simple. Just one argument πŸ‘Œ

=FORMULATEXT(reference)

Where reference is the cell that contains the formula of your interest.

TRY THIS: Copy a formula in one cell and paste in another cell. What happens there will help you appreciate more the magic of FORMULATEXT.

Trust this is helpful or do want to know more about it?
Kindly share your views and questions with us.



Excel_Xpress Excel.Xpress

29/03/2021

Dear Excel Enthusiasts

We receive a lot questions and problems to solve on Excel privately.

Please note that your comments, questions and enquires here on the Community platforms - Excel_Xpress & Excel.Xpress will receive express attention than private messages except for sensitive documents that cannot be shared with the public.

Let's have a super interactive time together so that many can learn from the interactions.

Thank you!
@

29/03/2021

There are basically 2 types of References in Excel. Relative and Absolute References. To expressly switch between Relative and Absolute, use F4 key.

Address

Lagos

Website

Alerts

Be the first to know and let us send you an email when Excel.Xpress posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Share