How to Turn Autosave in Excel

How to Turn Autosave in Excel

Even though Microsoft Excel has improved over the years, it is still possible to crash when working with a large data set. Factors outside Excel such as power failure could cause it to crash. You may easily lose your data if your work was not saved in the first place. However, Excel has an AutoSave … Read more

Excel How to Freeze the Top Row and First Column

How to Freeze the Top Row and First Column

When we are using our worksheet, at some point, we need to see the heading of columns and the titles in the first row. We need to freeze the first column and the first row to do this. After freezing the two, you will always see the first row and the first column when you … Read more

How to copy Excel Table to MS Word- 3 Easy Ways

How to copy Excel Table to MS Word- 3 Easy Ways

While working with MS word, you may need to import a table from excel and use it in your word document. Unfortunately, no feature or tool can be used to convert Excel tables to word tables. However, you can copy or insert the excel table into your MS word. In this article, we shall discuss … Read more

How to find circular reference in Excel

How to find circular reference in Excel

A circular reference in Excel will indicate that the formula calculation in a certain cell directly or indirectly refers to its cell once or several times hence creating an infinite loop. Despite it being unintended, a circular reference can slow down your spreadsheet. A direct circular reference occurs in Excel when a formula directly refers … Read more

In Excel, How to add plus sign before the number in Excel

How to add plus sign before the number in Excel

Excel is a great management tool that makes it easier to work with documents and large data files. Despite this, there are a few features in excel that may irritate you sometimes. One of these is adding a plus sign before a number. Microsoft Excel displays the negative numbers with a minus sign while the … Read more

How to convert CM to inches in Excel

How to convert CM to inches in Excel

Microsoft Excel offers powerful conversion functionality to the user. In this way, one can easily convert cm to inches without any difficulty. It offers features that you can apply simple equations across ranges of data to quickly produce new figures. It only applies to; Microsoft ®Excel® 2010,2013,2016,2019 and 365(windows). Here's a detailed way of how … Read more

How to convert pound to Kgs in Excel

How to convert pound to Kgs in Excel

The pound is the name of several units of mass, ranging from 300 to 600 grams. Kilogram KG is the SI unit for mass. 1 lbs (pound) = 0.45359 kgs or 1Kg= 2.20462. Having known how kilograms and pounds relate, it is easy to convert from one unit to the other. Conversion using excel Conversion … Read more

How to fix memory/disk space error in Excel

How to fix memory/disk space error in Excel

Usually, it is so annoying when memory/ disk space error messages keep popping on your excel sheet when you still have a lot to do. Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space. Sometimes you might have deadlines to meet, so you should know … Read more

How to fix unable to close Excel

How to fix unable to close Excel

There are times when working with spreadsheets from Excel you encounter difficulties. Some are pretty much manageable, while others are daunting as you are left wondering whether you will lose all your data or not. Trying to close an Excel worksheet is one of them. At times, after completing data entry in Excel, when you … Read more