Fill Blank Cells in Excel With Value from Above




About this tutorial:

Video duration: 2:26
Visit this page to download the sample file, and for written instructions and a macro to fill blank cells.

Some sheets have blank cells, so headings are easier to read. If you want to sort or filter the list, you need to fill in the blanks, by copying the value from above.

This video shows a quick way to select and fill all the blanks, and use a mouse shortcut to change the formulas to values.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

Leave a Reply

Your email address will not be published. Required fields are marked *