It is a little-known feature that you can automatically break the text in an Excel Textbox into multiple columns. Here is how to find the setting.
Category: Power Pivot
Excel Fix 2029 Rule for 2-Digit Year – 2458
If you type a date with a two digit year, Excel treats anything up to 29 as being 2029. Once you get to 30, though, they assume you mean 1930. With 2030 only eight years away, it might be time Continue reading “Excel Fix 2029 Rule for 2-Digit Year – 2458”
Reaction Video To Duel 58 Sort With A Formula – 2373
Duel 195 is scheduled for next Friday. For those of you who don’t want to go a week without a Dueling Excel podcast, Bill tries a reaction video to Duel 58 – Excel Sort by Formula – from December 2010.
Download Continue reading “Reaction Video To Duel 58 Sort With A Formula – 2373”
Excel Illegal Filter Hack – South Region Over $5K – 2372
Three ways to filter a pivot table and two of them you might not have known about. Daniel Bula asks if the trick from episode # 2359 can be used in a pivot table. Here is a great pivot table Continue reading “Excel Illegal Filter Hack – South Region Over $5K – 2372”
Download a Free Excel Macro to Spin The Wheel – 2371
Do you need to randomly select someone from your department to win a prize? This awesome free macro from Rob Collie at PowerPivotPro.com will do the trick. Download for free from: http://mrx.cl/spinwheel20
Rob had an idea of Continue reading “Download a Free Excel Macro to Spin The Wheel – 2371”
Have There Really Been Someone On The ISS For The Last 20 Years – Episode 2377
Exploring the Microsoft/NASA Day of Data Dataset from https://techcommunity.microsoft.com/t5/day-of-data/bd-p/DayofData
Today (November 1, 2020) marks 20 continuous years of having a human on the International Space Station (ISS). For today’s video, I explore the NASA data set to see: Continue reading “Have There Really Been Someone On The ISS For The Last 20 Years – Episode 2377”
Answers to Day Of Data Space Trivia Questions
To play along, read the trivia questions and download the data set here: https://techcommunity.microsoft.com/t5/day-of-data/space-trivia/m-p/1781544
In case you have problems solving any of the trivia questions, I’ve created a video showing the answers. Jump to the section for any Continue reading “Answers to Day Of Data Space Trivia Questions”
Excel Page Break by Rows with VBA
Tina C asks if there is a better way to add a page break every 35 rows. Way back in episode 360, I showed a few methods. But today, one line of VBA in the Immediate Window seems much easier. Continue reading “Excel Page Break by Rows with VBA”
Excel VLOOKUP In Pivot Table Calculated Field? – 2456
Evil Angel on YouTube asks if you can do a VLOOKUP in a Pivot Table Calculated Field. I am fairly sure this won’t work in a regular pivot table based on the pivot table cache. But if you build a Continue reading “Excel VLOOKUP In Pivot Table Calculated Field? – 2456”
Excel Easily Choose Which Currency – 2455
Today a question from someone who frequently uses three currency styles in Excel: USD, EGP, and SAR. Excel makes it easy to choose USD, GBP, EUR, CHF but if your currency is not in that drop-down, then you are scrolling Continue reading “Excel Easily Choose Which Currency – 2455”
Red Gridlines In Excel – 2454
My courses on Retrieve: https://mrexcel.retrieve.com/store/#/
For a special holiday-week treat, change the color of the gridlines in Excel to red. It could drive your co-workers insane.
Actually, as time goes by, the gridlines are becoming more faint. Changing the Continue reading “Red Gridlines In Excel – 2454”
Excel Sort Left To Right – 2453
Today, a quick tip for sorting left to right in Excel.
With the correct headings, it is a faster way to rearrange columns.
Check out all 12 expert tricks at: https://www.youtube.com/watch?v=nOIEeUHyye0
My course on Retrieve: https://mrexcel.retrieve.com/