A couple of things happened this week that reminded me of the good old days of spreadsheets. There are some good memories, but I really don’t want to go back to those days. How about you?
Category: Excel tips
Excel Problems, Fixes and Webinars
Did you get hit by the disappearing Excel add-in affliction recently? After a long couple of weeks, that frustrating Excel problem is finally solved. After spending countless hours on that issue (details below), I was happy to get back to more productive work, updating my website and sample files. I hope the rest of the summer goes smoothly!
Numbers Change to Dates in Excel
Have you ever copied football scores, such as 3-2, and pasted them into Excel, where they magically change to dates? It’s certainly annoying when a nice list of numbers change to dates in Excel, but fortunately there’s an easy way to prevent that from happening.
Create an Excel Hyperlink With Drag and Drop
In a big Excel file, it’s handy to have hyperlinks that take you from one sheet to another. Maybe you need a table of contents, or a single link on a summary sheet that takes you to a data entry sheet. You can use the Insert Hyperlink command on the Ribbon, but it’s even quicker to create an Excel hyperlink with drag and drop. Here are a couple of ways to do that.
And there are a couple of Excel announcements too.
Continue reading “Create an Excel Hyperlink With Drag and Drop”
Excel Roundup 20160321
In this week’s roundup, Data Analysis, Power BI, combining functions, and more Excel tips.
Excel Sheet Selector With No Macros
If you’re setting up a workbook for other people to use, they’ll appreciate it if you make it easy to move around in the file. You can create a table of contents on the first sheet, and that will get them off to a good start. But then what?
Once they’re on one of the other sheets, how can they get back to the table of contents, or go directly to a different sheet? We’ll add a drop down list of sheets, to make it easy to go to the one that you need.
Excel Roundup 20160314
Happy Pi Day! In this week’s roundup, troubleshoot large Excel files, free webinars, reporting tips, and much more.
Excel Roundup 20160307
In this week’s Excel roundup, you’ll find fun with Power Map, trouble with Excel formula errors, different types of cell references, and more.
Excel Roundup 20160229
Happy Leap Year Day! According to my calculations, the next time that Leap Year Day falls on a Monday will be in 2044. By then, Excel will be 58 years old. Do you think that Excel will still be around, or will it have retired early?
This week, cool tricks with the new TEXTJOIN function, tell a story with your charts, create a calendar for Power Query, and more.
Excel Roundup 20160222
In this week’s roundup, Slicer trick, pivot charts, slow workbooks, dashboards, and more.