How to make a cell inactive in MS Excel

Inactivating cell(s) in ms excel is pretty easy. Making the cell(s) inactive prevents the user from editing it, overwriting, or changing the content present on that particular cell. Through this…

Comments Off on How to make a cell inactive in MS Excel

How to create a placeholder in excel

Placeholders can be easily created on excel. If you are working with a big worksheet with many graphics or working on a document that the user can add and delete…

Comments Off on How to create a placeholder in excel

How to insert special characters in Excel

Most Excel spreadsheets involve the use of numbers or texts in a cell. When you want to customize your Excel sheet, you can introduce characters and symbols into the sheet.…

Comments Off on How to insert special characters in Excel

How to limit decimal places in Excel

When working with excel spreadsheets, sometimes we encounter decimals. Some data entries may have a lot of decimals such that it cannot fit in a cell. How may I limit…

Comments Off on How to limit decimal places in Excel

How to add a hint in excel

Excel hints are awesome, especially when you are creating a worksheet for someone to use. Excel hints can be described as small windows that pop up when one selects a…

Comments Off on How to add a hint in excel

How to add a footnote in Excel

Most people have encountered situations where they need to use an Excel spreadsheet. It is used to store, organize and manipulate data. You might have used it to track your…

Comments Off on How to add a footnote in Excel

How to do case sensitive lookup

A case-sensitive lookup can be done using an array of functions like INDEX, MATCH, and EXACT. Always remember that you need to enter the formula with the array of functions…

Comments Off on How to do case sensitive lookup

How to divide one cell to several cells

Microsoft excel, developed by Microsoft Corporation, is a spreadsheet for Windows, iOS, and Android that features graphing tools, calculation, and pivot tables. Excel is mainly utilized in organizing data in…

Comments Off on How to divide one cell to several cells

How to present data in Excel

Data are available to researchers in raw format. Excel is a powerful tool when it comes to data presentation. It enables its users to analyze, summarize and present these data…

Comments Off on How to present data in Excel