How to Copy Above Cell in Excel (3 Easy Ways)

The sample dataset contains the Department and Joining Month of some employees in the range B4:D10.

In the empty cells, we need to copy the above cell.

how to copy above cell in excel


Method 1 – Using Keyboard Shortcut

Press Ctrl + Shift (quote) keys together. For example to copy the value of Cell C5 into Cell C6, select Cell C6 > press Ctrl + Shift (quote) keys.


You can also press the right Ctrl + D to copy the above cell but it will also copy the cell formatting.

Method 2 – Using Go To Special Feature


  • Select the range where you want to copy the above cells. Here, we have selected the range C5:D10.Copy Above Cell with Go To Special Feature
  • Press Ctrl + G to open the Go To box > select Special.
  • Select Blanks from the Go To Special box > OK.
    Excel will select the blank cells.Copy Above Cell with Go To Special Feature
  • Enter the following formula in the first blank cell of the selected range, =C5 in Cell C6.
  • Press Ctrl + Enter to get values in all blank cells.
  • The empty cells will contain formulas. To change them to values, select the range C5:D10 and press Ctrl + C to copy them.
  • Copy Above Cell with Go To Special FeatureSelect Cell C5 and go to the Home tab > Paste option > Paste Values.
    The formulas will be removed and Excel will store the values only.

Method 3 – Using VBA Code


  • Select the relevant range.Apply VBA to Copy Above Cell in Excel
  • Go to the Developer tab > Visual Basic.
  • In the Visual Basic window, select Insert >> Module.
  • Copy the code below and paste it into the Module window:
    Sub Copy_Cell_Above()
    Dim i As Range
    For Each i In Selection.Cells
        If i.Value = "" Then
        End If
    Next i
    End Sub
  • Press Ctrl + S to save the code.
  • Go to the Developer tab > Macros.
  • In the Macro window, select the desired code and Run it.
  • The code will copy the above cells into the blank cells.

Read More: How to Copy Multiple Cells to Another Sheet in Excel

Download Practice Workbook

You can download the practice workbook from here.


Frequently Asked Questions

What is the difference between copying the value and copying the formula from the cell above?

Copying the value duplicates the static content while copying the formula replicates the dynamic calculation or operation from the cell above.

How can I copy the visible cell above when working with filtered data in Excel?

Select the target cell, press Ctrl + Shift + Up Arrow to navigate to the visible cell above, and then use Ctrl + D to copy its content.

Related Articles

<< Go Back to Copy a Cell | Copy Paste in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Mursalin Ibne Salehin
Mursalin Ibne Salehin

Mursalin Ibne Salehin holds a BSc in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. Over the past 2 years, he has actively contributed to the ExcelDemy project, where he authored over 150 articles. He has also led a team with content development works. Currently, he is working as a Reviewer in the ExcelDemy Project. He likes using and learning about Microsoft Office, especially Excel. He is interested in data analysis with Excel, machine learning,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF