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

In this article, we will learn to copy the above cell in Excel. Sometimes, users need to copy the value of the above cell to fill a cell in Excel. For example, when you are working with a large dataset, you may need to copy the group, department, or month name from the above cell. Today, we will show 3 easy methods. Using these methods, one can easily copy the above cell in Excel. So, without further delay, let’s start the discussion.


Download Practice Workbook

You can download the practice workbook from here.


3 Easy Ways to Copy Above Cell in Excel

To explain the methods, we will use a dataset that contains the Department and Joining Months of some Employees. But some cells are empty. In those cells, we need to copy the above cell. So, we will use the methods to fill the Department and Joining Months for Sophie, Paul, and Alexa.

how to copy above cell in excel


1. Use Keyboard Shortcuts to Copy Above Cell in Excel

In the first method, we will use keyboard shortcuts to copy the above cell in Excel. You can use this method when you have a small dataset and need to copy a few numbers of cells.

Let’s follow the steps below to see how we can use keyboard shortcuts to copy the above cell.

STEPS:

  • First of all, select Cell C6 to copy the value of Cell C5.

Use Keyboard Shortcuts to Copy Above Cell in Excel

  • Now, press the Ctrl + Shift + " keys together on the keyboard.
  • Alternatively, you can also press the right Ctrl + D to copy the above cell.
  • As a result, you will see the result in Cell C6.

  • Finally, repeat the above steps to get the value in each empty cell.

Read More: How to Copy a Cell in Excel Using Formula(7 Methods)


2. Copy Above Cell with Go To Special Feature

If you have a large dataset and need to copy the above cell for many empty cells, then you can use the Go To Special feature in Excel. Let’s pay attention to the steps below to learn the whole method.

STEPS:

  • In the first method, select the range C5:D10.

Copy Above Cell with Go To Special Feature

  • Secondly, press Ctrl + G to open the Go To box.
  • Select Special from there.

  • After that, select Blanks from the Go To Special box.
  • Click OK to proceed.

Copy Above Cell with Go To Special Feature

  • As a result, Excel will select the blank cells.
  • Now, type the formula below in Cell C6:
=C5

  • In the following step, press Ctrl + Enter to get values in all cells like the picture below.

  • After completing the above steps, the empty cells will contain formulas.
  • That is why we need to change them to values.
  • For that purpose, select the range C5:D10 and press Ctrl + C to copy them.

Copy Above Cell with Go To Special Feature

  • Finally, select Cell C5.
  • Now, click on the Paste option in the Home tab. A drop-down menu will appear.
  • Select Paste Values only from there.
  • As a result, the formulas will be removed and Excel will store the values only.

Read More: How to Copy Multiple Cells to Another Sheet in Excel (9 Methods)


Similar Readings


3. Apply VBA to Copy Above Cell in Excel

In the last method, we will apply VBA to copy cells in Excel. This process is simple. You can copy multiple cells in this case. You just need to write a few lines of code. So, let’s follow the steps below to learn the way to apply VBA in Excel.

STEPS:

  • Firstly, select the range C5:D10.

Apply VBA to Copy Above Cell in Excel

  • Secondly, go to the Developer tab and select Visual Basic. It will open the Visual Basic window.

  • In the Visual Basic window, select Insert >> Module to open the Module window.

  • Now, 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
        i.FillDown
    End If
Next i
End Sub

Apply VBA to Copy Above Cell in Excel

  • Press Ctrl + S to save the code.
  • Now, go to the Developer tab and select Macros to open the Macro box.

  • In the Macro window, select the desired code and Run it.

  • As a result, you will see the values in the empty cells.

Read More: Excel VBA: Copy Cell Value and Paste to Another Cell


How to Copy Cell Formatting in Excel

In this section, we will learn to copy cell formatting in Excel. To explain the procedure, we will use the dataset below. You can see Cell D5 is formatted. We will copy the cell formatting down using Format Painter in Excel.

How to Copy Cell Formatting in Excel

So, let’s follow the steps below to learn the way to copy cell formatting in Excel.

STEPS:

  • First of all, select Cell D5.
  • Then, go to the Home tab and select Format Painter.

  • As a result, the cursor will change into a fat plus and brush sign like the picture below.

  • Now, place the cursor in the middle of Cell D5 and drag it down.

  • Finally, you will be able to copy cell formatting in Excel.

How to Copy Cell Formatting in Excel

Read More: How to Copy Conditional Formatting Color to Another Cell in Excel


Conclusion

In this article, we have demonstrated 3 easy ways to Copy the Above Cell in Excel. I hope this article will help you to perform your tasks efficiently. Furthermore, we have also added the practice book at the beginning of the article. To test your skills, you can download it to exercise. Also, you can visit the ExcelDemy website for more articles like this. Lastly, if you have any suggestions or queries, feel free to ask in the comment section below.


Related Articles

Mursalin Ibne Salehin

Mursalin Ibne Salehin

Hi there! This is Mursalin. I am an Excel and VBA content developer at ExcelDemy. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I am currently working and doing research on Microsoft Excel. Here I will be posting articles related to Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

5 Excel Tips
You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo