Excel sorely needs a date picker. In a previous video, I showed you the add-in from Sam Rad that has a date picker. In this video, take a look at the Date Picker included with the DOSE for Excel add-in.
I also take a look at their reading view, which essentially draws crosshairs to help you find the active cell.
Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose
Holly has a data set with Subtotals. She needs to insert a blank row after each subtotal row and add a calculation to those blank rows.
Table of Contents
(0:00) Welcome
(0:15) Go To Special Tricks?
(0:47) Subtotals
(1:10) Helper column on Total rows
(1:50) Move 1’s down a row
(2:28) Select just 1’s & Insert Rows
(3:00) Select blank cells
(3:32) Entering the formula
(4:30) Favorite Go To Special
Sometimes in Excel, you need checkboxes. Many checkboxes.
If you are designing a form and need checkboxes, this video will help.
All the way back in video 1871, I showed one method for getting checkboxes in Excel.
Today, I show how you can do this quickly and easily with the DOSE for Excel add-in.
In a perfect world, those Checkboxes would be tied to a set of cells, so you could use formulas to reach which ones are checked.
Also in this video, how to convert text in cells to an option buttons – this allows people to choose exactly one option, but not Continue reading “Excel How to Add Checkboxes – 2508F”
Back in episode 2444, I had Tommy Tutone singing a crazy formula to reverse text in Excel. Today, a less musical way, but a much easier way.
Using the DOSE for Excel add-in, you can easily reverse text, making “ABCDEF” change to “FEDCBA”. However, Dose does even better, offering an option to take “Jenny Jenny I’ve Got Your Number” and changing it to “Number Your Got I’ve Jenny Jenny”.
Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose
Your manager asked you to double-space your data in Excel. In other words, he wants you to add a blank row between each row.
In a past video, I showed a Bob Umlas trick for double-spacing data.
Using the DOSE for Excel Add-In, you can double-space or triple space your data.
Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose
How can you convert a number to words spelled out?
Microsoft has a SpellNumber function in an ancient knowledge base article.
Rather than copying that code to your Personal Macro Workbook, the DOSE for Excel Add-In will allow you to quickly convert numbers to words.
Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose
How can you select every other row in Excel? This video shows how to use the DOSE for Excel add-in to solve the problem quickly.
Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose
You have a list of cells. You want to add a sequential number before the text in each cell.
This video shows how the DOSE for Excel add-in solves the problem. They actually add the sequential number into the cell. You can specify that the number should be separated from the existing text with a space hyphen space.
Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose
Do you regularly need to sort Excel worksheet tabs by sheet name?
The DOSE for Excel add-in makes this very easy, without any VBA.
Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose
Back in the days of COBOL, we called it Greenbar paper. There would be four rows of green and four rows of white. It helps your eye to follow the data across the page.
Today, Microsoft calls this banded rows.
Previously, we did this with conditional formatting and the MOD function.
Today, I am showing you a faster way using the DOSE for Excel add-in.
Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose
Danny from Stuart Florida noticed that when you group all worksheets in an Excel workbook, you can not protect or unprotect the worksheets. This episode offers two very short VBA macros that you can use to unprotect all sheets and then re-protect them with a password.
Holly from Vero Beach gets a report each week with Member ID. She needs to pull in the Member Name from last week’s report. This involves doing a VLOOKUP from one workbook to the other – Holly’s employers is on Excel 2016 instead of 365.