E-tech Academy

Freeze Panes in Excel When working with large spreadsheets, scrolling up and down (or left and right) can make you lose track of headers or important information. That’s where Freeze Panes comes in. It’s like pinning certain rows or columns so they always stay visible , no matter how much you scroll. Where to Find Freeze Panes Go to the View tab on the Ribbon . Look for the Freeze Panes option in the Window group. Options in Freeze Panes Excel gives you three main options: 1️⃣ Freeze Panes Freezes both rows and columns above and to the left of the selected cell . Example: If you click cell C5 and choose Freeze Panes , rows 1–4 and columns A–B stay locked while you scroll. 2️⃣ Freeze Top Row Keeps only the first row visible as you scroll down. Handy for spreadsheets with column headers. 3️⃣ Freeze First Column Keeps only the first column visible as you scroll sideways. Useful when row labels are in the first column. Example Use Cas...

What is the CLEAN Function in Excel? The CLEAN function in Excel is used to remove non-printable characters from text. Sometimes when you copy data from the web, databases, or other applications into Excel, it brings along “hidden” characters—things like line breaks, control characters , or symbols that you can’t see but that mess up your data. That’s where CLEAN comes in—it acts like a broom, sweeping away those invisible characters so your text is neat and usable. Syntax =CLEAN(text) text = the cell or text string you want to clean. Example Let’s say you copied this messy text into Excel: Cell A1: Hello ▯World (That little square ▯ is a non-printable character.) Now, if you use: =CLEAN(A1) The result will be: Hello World The unwanted character disappears! Common Uses of CLEAN Imported Data – Cleaning up messy data copied from websites or databases. Removing Line Breaks – Text copied from PDFs or Word often has hidden line breaks that CLEAN can fix. ...

Creating WhatsApp Links with Microsoft Excel WhatsApp has become one of the easiest ways to connect with friends, clients, or business contacts. But did you know you can generate WhatsApp chat links directly from Microsoft Excel ? This simple trick saves time when you have a list of phone numbers and want to quickly create ready-to-use links. 🔹 What is a WhatsApp Link? A WhatsApp link lets someone start a chat with you without saving your number. The format is: https://wa.me/<PhoneNumber> For example: https://wa.me/2348132627521 When clicked, it opens WhatsApp and starts a conversation. 🔹 Why Use Excel? If you have many contacts (say, for a business campaign or class reminders), typing links one by one is time-consuming. With Excel, you can create all links automatically in seconds. 🔹 Step-by-Step Guide Open Excel and enter your phone numbers in Column A (without spaces or special characters). Example: A1 → 2348132627521 A2 → 2347012345678 In Column B...