Microsoft Office Forums - View Single Post - filling in blank cells with data from cell above

Thread: filling in blank cells with data from cell above

View Single Post

Old

01-12-2017, 04:14 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

Try this...

Fill range with values from cell above

Highlight range from first cell to last
Select F5 >> Special >> Blanks >> OK
Press “=” sign one time then up arrow one time
Press Ctrl + Enter
Highlight range >> copy >> paste special as value

Reply With Quote