How to Swap Cells in Excel (3 Easy Ways)
Have you ever wondered if there’s an easy way to swap cells in Excel? Well, you’re in luck! This article is all about swapping cells in Excel without any hassle …
Steve Scott
Useful Excel VBA Macro Codes Examples
VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft. It is primarily used to automate repetitive tasks in Microsoft Office applications like Excel, Word, …
What is an XLK File?
Did you come across an XLK Excel file extension and now wondering what it means? I have been using Excel for more than ten years now, and I’ve recently learned …
Split Text to Rows in Excel
Excel has many built-in tools and functions to split text into columns (including a dedicated Text to Columns feature). But what if you want to split text into rows instead …
Excel Hyperlink Cannot Open the Specified File – Fix!
In Excel, hyperlinks enable users to access particular files stored on the local drive, network server, intranet, or the internet. At times, when you try to open a hyperlink in …
Alt + Enter Not Working in Excel
Alt + Enter is a keyboard shortcut that creates a new line in a Microsoft Excel cell. The Excel shortcut comes in handy when, for instance, you want to create …
VBA Macro Codes to Filter Data In Excel
Excel offers a lot of built-in filtering options. You can do a lot of basic and advanced filtering using the in-built options. But with VBA, you can take the filtering …
How to Create Custom Lists in Excel?
Excel has a fantastic feature called Custom Lists that lets you create your own lists and quickly apply them in various ways. When you create a custom list in Excel, …
#REF! Error in Excel
An error in Excel called “#REF!” (with REF standing for reference) happens when a formula refers to an invalid cell. This usually occurs when cells referenced by formulas are deleted …
How to Write Scientific Notation in Excel?
Scientific notation is commonly used by mathematicians, engineers, and statisticians when they are writing very large numbers or very small numbers. MS Excel offers some built-in features to work with …
Extract Last Word in Excel
As you work with data in Excel, you might need to extract the last word in a cell, for example: This tutorial shows five techniques for extracting the last word …
Convert Number to Percentage in Excel
In Excel, we frequently calculate and enter growth rates, efficiency rates, success rates, discount rates, tax rates, interest rates, etc. In general, we have to give those as percentages. Then, …