My former co-worker thought it was a good idea to hide all of the whitespace below our Excel data and managed to hide a million rows and 16000 columns. How can I unhide something at the edge of the worksheet?
Category: Power Query
How To Delete Blank Rows At Bottom Of Excel – 2436
“My spreadsheet must be haunted” is a great opening line to an Excel question sent in just before Halloween. You have 1510 rows in Excel. You try to Delete Sheet Rows from A1511 to A1048576, but the rows keep coming Continue reading “How To Delete Blank Rows At Bottom Of Excel – 2436”
Arrays As Arguments To Application WorksheetFunction in Excel VBA – 2435
How to use XMATCH with Application . WorksheetFunction in Excel VBA? Today, a question from Hydrogen Peroxide. How can you refer to an array inside of a formula in Excel VBA.
This workbook takes a look at how to simulate Continue reading “Arrays As Arguments To Application WorksheetFunction in Excel VBA – 2435”
Excel MAX Across All Worksheets – 2434
Can you use the MAX function in Excel to find the largest value across all worksheets? You can use a 3-D Reference or a spearing formula. In this episode, I will show you an easier way to create 3D Continue reading “Excel MAX Across All Worksheets – 2434”
Excel Add A Blank Row After Each Subtotal – 2433
Your manager asks if you can add a blank row after each subtotal. Episode 2433 shows you how to do this in Excel.
The first way, is clearly cheating: Increase the height of each row.
But the second way is the Continue reading “Excel Add A Blank Row After Each Subtotal – 2433”
Excel Add Subtotals To Only One Category – 2432
Geert asks: “in my experience the datasets are non-uniform in the sense that only a subpart of the data needs subtotals. (categories of data are sequentially listed and only 1 category has a further breakdown that needs subtotals – the Continue reading “Excel Add Subtotals To Only One Category – 2432”
Excel Removing Subtotals – 2431
A co-worker sent you a file with subtotals. How do you get rid of them?
Why are there 3 numbered buttons to the left of column A in Excel?
Why are there minus buttons and vertical lines to the left of column Continue reading “Excel Removing Subtotals – 2431”
Excel Subtotals Are Awesome – 2428
Accountants love the subtotals feature in Excel. We love to see details but add a little summary information. I have a lot of friends who think Subtotals should be deprecated and that anytime you use subtotals, you should be using Continue reading “Excel Subtotals Are Awesome – 2428”
Easy Frequency Distribution For Bingo Numbers in Excel – 2430
Candace is using a third-party Bingo app to generate numbers for a bingo game. Some people are complaining that the app is not fair and that it is calling some numbers too frequently. Candace manually keyed the numbers into Excel Continue reading “Easy Frequency Distribution For Bingo Numbers in Excel – 2430”
Minute by Minute Stock Price Arrows In Excel – 2429
Broadway Gypsy asks if there is a way to create a “minute by minute changing up/down stock price arrow in Excel”?
In this video, Bill shows how to use Icon Sets and the SIGN function to add up/down arrows next to Continue reading “Minute by Minute Stock Price Arrows In Excel – 2429”
Excel Changing Formula References By Dragging The Mouse – 2427
Check out the finals of the Financial Modeling World Cup: https://www.youtube.com/watch?v=TaW8zwnOA7M
I was a host for an Excel Competition that aired live on YouTube. Besides being one of the nerdiest & geekiest things I’ve been involved in, it Continue reading “Excel Changing Formula References By Dragging The Mouse – 2427”
Better ESPN Fantasy Draft Recap In Excel Free Download – 2426
This weekend, Fantasy Football teams will be doing their draft. If you are using the ESPN website to manage your draft, the Draft Recap Report could use some formatting.
Download our free Excel template from: http://www.mrexcel.com/download-center/2021/08/BetterESPNDraftRecap.xlsx
Watch the video Continue reading “Better ESPN Fantasy Draft Recap In Excel Free Download – 2426”