Twenty-five years ago, on November 15, 2000, I registered and launched my Contextures.com website. It had a few Excel tutorials, and a small selection of sample Excel files to download.
Continue reading “25 Years of Contextures – 40 Years of Excel”
Category: Excel tips
Happy 40th Birthday Excel September 30 2025
Are you taking the day off, to celebrate Microsoft Excel’s 40th birthday? Or will you have a big party with your co-workers, at the office or remotely?
And what were you doing on September 30, 1985, when the first version of Excel was released, for the Macintosh?
Continue reading “Happy 40th Birthday Excel September 30 2025”
AutoFill Weekdays in Excel: Skip Weekends
You can make quick lists with Excel’s AutoFill feature. In the short video below, I show two tricks for making weekday lists – only the Monday to Friday dates, with no weekend dates included.
Continue reading “AutoFill Weekdays in Excel: Skip Weekends”
Happy Excel Day 45678
Where does the time go? Two years ago, we were celebrating Excel Day 45000, and suddenly it’s Excel Day 45678!
Do you have any special events planned? If not, you could make the office festive, with a few balloons and a magic marker!
How to Split Date and Time in Excel
If your Excel sheet has a column with combined dates and times, you might want to separate date and time into different columns. My short video shows the steps, and there are written steps below.
Quickly Move Sheet in Large Excel File
Do you ever find yourself scrolling through an endless number of worksheet tabs, while you’re working in a large Excel file? It’s happened to me, more times than I can count, while working in my own files, or client workbooks. Here’s a quick tip that might help you save some time!
Spreadsheets in the News 2023-06-29
It’s almost the end of June, and there’s a long weekend coming up! To celebrate, let’s take a look at some of the spreadsheet news from the past month. Here are 3 stories that caught my eye, and let me know if there was other noteworthy news that I missed!
Excel Find and Replace with Wildcard
With the Find and Replace feature in Excel, you can look for specific characters, and replace them with different characters, or replace them with nothing. You can also use wildcard characters in the Find What box, to make the find feature more flexible. The short video below shows you the steps.
Happy Excel Day 45000
Where does the time go? Only 556 days ago, we were celebrating Excel Day 44444, and suddenly it’s Excel Day 45000! And we’re still cleaning up from yesterday’s Pi Day Party! Who says numbers are boring?
Turn Off Grey Watermark Page 1 on Excel Worksheet
Since the beginning of (Excel) time, people have asked questions about the big grey “Page 1” that sometimes appears on a worksheet. How did it get there? Is it a watermark? How do I get rid of it? Will it show up on printed copies? My short video, below, answers those questions for you!
Continue reading “Turn Off Grey Watermark Page 1 on Excel Worksheet”