How do I display what is in the cell above a selected cell?

ZOwNER

Board Regular
Joined
Nov 10, 2003
Messages
121
Book1
ABCD
1Name123
2Name123
3Name
4Name456
5Name456
6Name
7Name789
8Name789
9Name789
Sheet6


Here is an example of what I have. I was going to auto filter to only display Blank cells in columb B. I then want a formula so that when I show all the cells again it will input whatever is above the blank cell. So using the example listed B3 would look up and grab the 123 from B2 and then input it into B3. How would I go about doing this?
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

btadams

Well-known Member
Joined
Jan 6, 2003
Messages
1,942
Turn off the filtering to display all data. Select column B and go to Edit -> Go To .... Click on the Special button and choose Blanks.

Then hit the = key and then the Up Arrow key and then Ctrl + Enter
 

ZOwNER

Board Regular
Joined
Nov 10, 2003
Messages
121
Ahh very easy. Thanks a ton. Never used the Go To feature. It should come in handy doing other things as well. Thanks again :biggrin:
 

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
if you put your autofilter on and select blanks, then go to the first empty cell and put in the formula
=b2 (or whatever the previous cell range is)
then copy that formula
highlight the remaining blanks and select F5, special --> click Visible cells only --> OK
then paste

Now turn auto filter off
 

Forum statistics

Threads
1,141,734
Messages
5,708,166
Members
421,549
Latest member
Dtcfire

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top