E-tech Academy

Best way to autofit cells in Microsoft Excel (Video) To autofit a cell in Excel , which means automatically adjusting the row height or column width to fit the content, here’s how you can do it: Autofit a Column (Width) Option 1: Using the Ribbon Select the column(s) you want to autofit (e.g., click on column letter A ). Go to the Home tab. In the Cells group, click on Format . Choose AutoFit Column Width . Option 2: Using a Double Click Move your mouse to the right edge of the column header (e.g., between A and B ). When the cursor turns into a double arrow ⇔ , double-click . Autofit a Row (Height) Option 1: Using the Ribbon Select the row(s) you want to autofit. Go to the Home tab. Click Format in the Cells group. Choose AutoFit Row Height . Option 2: Using a Double Click Move your mouse to the bottom edge of the row number. When the cursor changes to a double arrow, double-click . Autofit Multiple Rows/Columns at Once Se...

Steps to Create a WhatsApp Link in Excel WhatsApp provides a simple link format: https://wa.me/<phone-number>/?text=<your-message> <phone-number> must be in international format (no + , no spaces, no dashes). Example: 2348012345678 (for Nigeria). <your-message> can be plain text. Use %20 for spaces. Example: Hello%20I%20am%20interested . Method 1: Manually Create a Hyperlink Select a cell (e.g., A1). Press Ctrl + K (or right-click → Insert Hyperlink ). In the Address box, type: https://wa.me/2348012345678/?text=Hello Click OK . Now, when you click the cell, WhatsApp (app or web) will open a chat with that number. Method 2: Use a Formula (Dynamic WhatsApp Links) If you have phone numbers in column A, you can generate links in column B. Example: A (Phone) B (WhatsApp Link) 2348012345678 =HYPERLINK(" https://wa.me/"&A2&"?text=Hello%20there","Chat Now") Formula in B2...

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...