Why is Merge and Center Grayed Out?
To ensure a formatted and symmetrical look in our worksheets, we often need to merge a few cells together and center the contents of the merged cell. For example, you …
Steve Scott
How to Sum Positive Numbers in Excel (Formula)
For someone fairly comfortable with Excel, summing up a list of cells is as easy as pie. But when it comes to summing up cells based on a particular condition, …
How to Count Negative Numbers in Excel (Formula)
Counting cells in a range of data is fairly easy, even if you are a beginner at Excel. But when it comes to counting only the cells that contain a …
How to Remove Macros from Excel?
Macros provide a great way to automate repetitive tasks. In this way, they help get things done quickly, but there may be times when you want to remove macros from …
How to Convert Date to Day of Week in Excel?
When working with date-specific information, there might be instances where you need to find the day of the week corresponding to a date. For example, instead of the date, you …
How to Convert Serial Numbers to Date in Excel
When you bring in data from other sources, it is not uncommon to get the dates in the form of serial numbers, like 42088. Moreover, Excel inherently stores dates in …
How to Remove a Specific Character from a String in Excel
A big part of processing data involves the cleaning of the data. Most data you bring in to Excel often comes from various sources. Many times they are converted from …
How to Convert Date to Month and Year in Excel
Whenever you enter a date in a cell, Excel automatically recognizes the format and converts the cell to a date cell. So, Excel knows which part of the date you …
How to Move a Chart to a New Sheet in Excel
Charts are a great way to get a visual representation of your data. Excel provides a host of options to create and customize charts. It usually displays your created chart …
How to Add Text to the Beginning or End of all Cells in Excel
There may be instances where you need to add the same text to all cells in a column. You might need to add a particular title before names in a …
How to Remove Text after a Specific Character in Excel?
When editing or cleaning data in your worksheet, one often needs to trim and remove certain parts of strings, either for formatting consistency or to make the dataset look neat …
Count How Many Times a Word Appears in Excel (Easy Formulas)
One common requirement when working with large datasets is counting how many times a particular word or value appears. You may need to know how many times the word appears …