Here’s our first Excel video tip, for those occasions where you have a spreadsheet full of data and group headings/categories have only been entered once, to make it easy to read. if you want to sort this data to do something with it then you may need to fill in the blank spaces with the value from above. Copying and pasting manually is long and laborious. Here’s a tip for doing it quickly. Click the link to go through to our screencast video.

Filling in blank cells in Excel