Excel Tips and Tricks – Technical Forum

Excel 2010/2013: Hiding a worksheet while disabling the Unhide command

When you are working with an Excel workbook, you might find it essential to hide worksheets. This is very useful when a worksheet contains a standard set of data or static data or those data that does not change so frequently. One example is a price table of goods or merchandise, hourly rate of workers, and others that you want it protected from an unwanted and accidental editing. The normal or default way of hiding worksheets is to right click on the Sheet that you want to hide, in the… Read More

How to extract whole numbers from decimal digits in Microsoft Excel

How Tos MS Office Tips Tips & Tricks October 28, 2023

In daily spreadsheet tasks, you will encounter various types of data. Suppose you have a column of numeric data of formatted in 3 decimal points like the table below: Suppose you need to use the WHOLE number parts of the data in column C (Average) in the table above, how would you do it? Using the Round Function If you vaue the decimal digits of your data and want to include them in the computation of the resulting whole numbers, you need to use the ROUND() function. In Excel, the… Read More

How to extract the unique values or data in a column with duplicate data

How Tos MS Office Tips Tips & Tricks October 28, 2023

Suppose you have a spreadsheet at work and one of the columns contain a huge list of account numbers being exported from your company’s accounting system that contains a lot of duplicates. And you are tasked to extract the UNIQUE account numbers in this huge list. If the list is just a short one, like 50 rows or 100, you can easily use the Conditional Formatting that highlights all duplicates, then you can manually delete the highlighted duplicates until no marked cells are left. This can be done easily with… Read More

Microsoft Excel: Using Data Validation to provide drop-down selection menu

How Tos MS Office Tips Tips & Tricks October 8, 2023

In Excel, there are various ways to provide a drop-down menu in a form or in cells. With drop-down menus, also called combo boxes, you can select an option based on pre-selected data. Samples of data where drop-dowm menus will be useful are gender (Male and Female options), Status (Single, Married, Divorced, etc options) and many others. The major reasons for providing a combo box or drop-down selection menu includes the following: On the other hand, combo boxes or drop-down selection menus are only applicable when: In this article, I… Read More