How to Use Absolute Reference in Excel (Step-by-Step) Excel is a spreadsheet of cells – and each sheet has 17,179,869,184 cells. That’s 17.2 billion. A big number 🤯 You can use these cells to populate data and then refer them around your worksheet or workbook by using their cell reference. A cell reference [...]
How to Add in Excel: Simple Guide for Beginners (2024) Adding up in Excel is a child’s play. However, there's not a single method for how you can add numbers in Excel. Many methods and smart shortcuts to achieve the sum of a given set of numbers in Excel await you in the [...]
How to Split Text in Formula (TEXTSPLIT Function) This guide is going to be about splitting text in Excel. But we have been doing it before as well – either using the Text-to-Columns feature or the Flash Fill tool. Yes, okay. But this time we are going to do it using a function. [...]
How to Expand All Columns in Excel At Once (Easy) The easiest but often the most important part of your spreadsheet tasks is resizing column widths. Whether you received a workbook with narrow columns all over it or you see clipped text in your worksheet, you know you need to fix the column [...]
How to Add Yes or No Options in Excel (Drop-down & Box) When you're setting up a workbook to share with others or for other collaborative purposes, you often want to control the information others can input. It could be a defined range of data, certain numbers or text strings, and sometimes, just [...]
How to Count Words in Excel (Fast & Easy Example) Unlike Word, Microsoft Excel does not have a built-in tool for counting the number of words. However, this doesn’t mean Excel can’t. 😎 By combining several Excel functions to make complex formulas, anything is almost possible in Excel including how to count words. [...]
How to Use Excel's HYPERLINK Function (Examples) Creating hyperlinks to another webpage in Excel is straightforward. Copy the link to that webpage and paste it into a cell, Excel will make it a hyperlink. However, some URLs might be very long and convoluted so you might not want them to appear on your [...]
How to Add Text to Excel Formula (Before, In, After) When working with Excel formulas, have you ever wondered how to add text to them? Excel formulas offer a lot of features that make writing formulas easier. But sometimes, you need to add some prefix at the start of the formula or some [...]
How to Lock Formulas in Excel (But Allow Data Entry) When you are sharing an Excel file with other users to work on, accidental changes in your Excel sheets are bound to happen. 😬 Other users could delete or overwrite the important data and formulas in your Excel sheet. And that’s something we [...]
How to Remove Characters From Left in Excel (Easily) Cleaning text data from the left (or the beginning) of text strings is one of the most time-consuming tasks in Excel. 😩 However, when you know what the correct Excel formulas to use, it doesn’t have to be. You can easily remove characters from [...]