Excel tips and tutorials
Do you hit the Save button frequently, while you work in Excel? And do you make backup copies of your Excel files, especially before making major changes? Or, do you only think about saving, right after Excel crashes?
Continue reading “Excel File Auto Backup When Workbook Saved”
Make it easy to enter valid data in an Excel workbook. Choose “Fastener” in one combo box drop down. The next combo box shows a list of fastener parts, with part ID and part name.
This video shows how to use this simple data entry tool, and you’ll get a peek behind the scenes, on how it works.
Continue reading “Video: Dependent Combo Boxes – Excel Data Entry”
When you’re printing financial reports in Excel, do you set them up to print one page wide? That feature saves paper, but it can make the header and footer text too small to read, especially if it’s in a small font size already. Here’s how you can avoid that problem. And there’s a macro to create a custom worksheet footer too!
Continue reading “Excel Footer Font Fix and Custom Footer Macro”
Every morning, I use Excel to keep track of the projects I’m working on, and organize my tasks for the day. Of course, things don’t always go as planned, but it helps to know where I’m headed!
Continue reading “Excel Macro to Increase Amount in Multiple Cells”
Keep track of Excel worksheet discussions, with a detailed list of threaded comments and replies. Just click a button, to run a macro, that makes the list for you. And I’ve fixed the macro!
Continue reading “Excel Threaded Comments and Replies List Details-Macro”
Happy December! We’ve almost made it to the end of this year, and you’re probably getting reading for next year’s tasks and projects. If you need to set up monthly workbooks for next year, or automatically add sheets to existing workbooks, these Excel macros can help you!
Continue reading “Excel Macros Create Monthly Workbooks Entire Year”
There’s an Excel UserForm that you can download from my Contextures site, and use it to search, view, and edit records in an Excel table. The two short videos below show how the UserForm works, and how you can put flexible criteria in the search boxes.
And remember – it’s almost Spreadsheet Day – we’ll celebrate on Monday, October 17th!
Continue reading “Search Transaction Records with Excel UserForm”
Whether you’re scheduling players for a golf tournament, or assigning employees for daily shifts, Excel can make the job easier. There’s a Golf Tee Off Times example on my site, and you could adapt it for building other types of schedules. This week, I uploaded a second version of the file – it gives you more flexibility in assigning people to specific times.
Continue reading “Excel Workbook for Golf Tee Off Times Update”
If you have a list of names or topics in Excel, here’s how you can quickly create PowerPoint slides from that list. Unlike most of my macros, these run in PowerPoint, to pull the data from Excel. That was easier than writing Excel macros to make things happen in PowerPoint!
In Excel for Office 365, there are threaded comments, where you can have discussions with your co-workers. Or, reply to your own threaded comments, with updates on the data. The old-style comments are now called Notes, and they still work the way they always did. Here are a couple of macros that you can use to work with the new Excel threaded comments.
