Here are a few shortcuts for selecting columns, rows or entering today’s date….
Here are two more Ctrl shortcuts that you might want to know….
Here are a few shortcuts using the Ctrl key to help you with formulas….
In a previous post we learned how to use TRIM to remove spaces that are in front of or after a entry. But what about when the space is in the middle of the data? Here’s how SUBSTITUTE can help….
How do you get rid of those extra spaces in your text when trying to do a LOOKUP or similar function? How about a TRIM? Here’s how that works…..
Do you ever have a large table and know there are duplicate entries, but need an easier way to find them? Excel has the answer! Here’s how…..