How can I create a macro in Excel?

A macro helps to automate tasks that you do repeatedly in excel. Take it as an algorithm with a set of instructions to follow and can be run several times.…

Comments Off on How can I create a macro in Excel?

How to save Excel as a Read-only

We activate the Read-only feature in a workbook when we do not want any sensitive information modified by other end-users. The feature protects your whole workbook from being edited or…

Comments Off on How to save Excel as a Read-only

How to separate numbers and texts in Excel

When working in Microsoft Excel, you may encounter a situation where a cell's text is all jumbled up. Such a cell will contain numbers and texts, making it hard to…

Comments Off on How to separate numbers and texts in Excel

How to make an Inventory List in Excel

Any retailer, salesperson, and wholesaler have to have an inventory management system. Keeping track of stocks without the help of professional software can be very tedious. Most people will look…

Comments Off on How to make an Inventory List in Excel

How to add a button in excel

When we mention buttons in Excel, anyone who is not a consistent user will wonder what that means. Yes, Microsoft Excel does have Macros buttons which are the most advanced…

Comments Off on How to add a button in excel

How to quickly delete empty rows in Excel

Using the excel sheets to record data does not necessarily mean that all the rows or columns must have data in them. At times we may fail to collect data…

Comments Off on How to quickly delete empty rows in Excel

How to pull data from another sheet in Excel

When working with excel sheets, you may have similar data that you are working with and which are in different excel sheets. Such data can be pulled from one of…

Comments Off on How to pull data from another sheet in Excel

How to make a row always visible in Excel

When using excel sheets you will always come across rows and columns. A row in Google sheets is a line of entries going from left to right. It also may…

Comments Off on How to make a row always visible in Excel