How to Copy & Paste an Empty Cell
Spreadsheet programs like Microsoft Excel are excellent tools for manipulating large amounts of data. Data in spreadsheets is arranged in rows and columns of cells, which may be empty, contain a value, or contain a formula to dynamically update the value of the cell. The contents of cells can be copied and then pasted into other cells, replacing any contents that cell may have previously had. Pasting an empty cell over a cell that is not empty will delete all the contents of that cell.
Other People Are Reading
Instructions
-
-
1
Click the empty cell you wish to copy.
-
2
Hold down the "Ctrl" key and press "C."
-
-
3
Click the cell you would like to paste over.
-
4
Press the "Enter" key.
-
1
Tips & Warnings
To keep the empty cell in the clipboard after pasting it, hold down "Ctrl" and press "P" instead of pressing the "Enter" key.
