How to Open VCF File in Excel?
A VCF (Virtual Contact File), or vCard, is a standard format for storing contact information. It is commonly used to exchange contact information between various devices and applications. Sometimes you …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
Excel Crashes When Opening File – Reasons + Fix!
Sometimes when you are opening an Excel file, Excel crashes and displays the message “Microsoft Excel has stopped working”: There are various reasons that may make Excel crash when opening …
How to Filter Cells with Notes in Excel?
Notes are used in Excel to make notes or annotations about the data, like in the example below: A small red triangle in the top right corner of the cell …
How to Enable Manual Calculation in Excel?
In Excel, manual calculation refers to a setting where Excel does not automatically recalculate formulas in your worksheet every time you make a change. Instead, you must initiate the calculation …
How to Delete Multiple Rows in Excel?
One of the most common tasks that many Excel users do on a daily basis is to delete multiple rows of data. While deleting one single row is quite straightforward, …
Can’t Insert a Row in Excel – How to Fix!
As we work with Excel, we may need to insert a row in a dataset for several reasons. For example, we can insert a row to accommodate new data, improve …
Data Types in Excel
In Excel, there are five basic data types. These are Number, Date and Time, Text, Logical (boolean), and Error. As an Excel user, knowing the different data types is important …
How to Get Sheet Names in Excel?
You may want to get the worksheet’s name while working with Excel. For example, when creating a report that includes multiple worksheets, you may have the sheet name as a …
How to Add Leading Zeros in Excel?
We usually need to enter zeros before phone numbers, zip codes, product codes, and account numbers. Even if we enter leading zeros when we type in Excel, all leading zeros …
How to Remove Add-Ins from Excel?
Microsoft Excel already has some amazing features and functionalities that come in-built with it. To add to it, you can also add some add-ins that can further enhance the functionality …
How to Generate Random Names in Excel
When creating sample data, you may be required to generate random names. You will find that this is a fairly routine task. In this tutorial, I will show you how …
Excel Fill Series Not Working
The Excel Fill Series feature allows you to automatically fill in data in the cells, based on the value or patterns in other cells. This is a useful feature that …