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 …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
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 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 …
How to Remove Dotted Lines in Excel
The topic for this tutorial is slightly fuzzy because what one may see as a dotted line may actually be a dashed line or even a light-colored solid line. Whatever …
How to Center the Worksheet Horizontally on the Page in Excel
When you start out using Microsoft Excel, you’ll notice that printing Excel sheets do not quite feel the same as printing an MS Word document. The idea of ‘What You …