problem filling in blank cells with data above -

  • Thread starter stumped-in-excel
  • Start date
S

stumped-in-excel

Excel isn't cooperating - I'm trying to fill in blank cells with the data
above but it's only filling in one box at a time- the one I entered the =A*

Heres the steps I've taken -

Highlited the section of colum A that I need to fill in -

File - Go To - Special - Values - OK

type = uparrow

enter -

Although the column is highlighted only the cell with the =Cell# is filling
in.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Publisher is filling blank lines with data 2
Custom filling of cells 2
Filling in blank cells with information from cells above it 1
How To Have A Cell Be Blank If... 2
Filling an empty row with the data in row above it 2
reverse pasting rows with alternate blank cells 0
prevent blank cells in excel 0
Fill in Blanks with immediately above cell value 4

Top