Excel Video 277 has another quick Go To Special shortcut to fill blank cells with data. If you download PM data or EHR data from your system, or if you download data from an outside source, this video may be very helpful for you. Sometimes data downloaded into Excel will only list columns once, leaving cells below the data in the same column blank. To use VLOOKUP or to create a Pivot Table, you need data in every cell. Here’s a quick trick to fill those blank cells with the data above the cell in the column.
I learned this trick from Rebecca in the Excel Users Community. It’s a great shortcut. Kudos to Rebecca for sharing it.
Please remember that all of the blank cells are now filled with formulas. I’d make a habit of immediately copying and pasting values so that your data doesn’t get scrambled when you sort the data.
