How to Remove Blacked-Out Cells in MS Excel

Microsoft Excel is the spreadsheet application that is included with most versions of the Microsoft Office suite of programs. It is primarily used to store and compare data, but presents a useful table structure that is helpful for many types of data organisation.

For this reason, it can be used in a variety of environments, such as those where sensitive data might be stored in a spreadsheet. Sometimes it is necessary to black out this type of data so that others can't see it. It is possible to remove this blacked out data entirely.

Navigate to the location of your Excel spreadsheet, then double-click on the file icon to open it.

Click on a blacked-out cell to select it. To select multiple contiguous cells, click on one cell, then hold down the mouse button and drag the cursor until all desired cells are selected.

Right-click on your selected cell(s) to bring up the secondary menu. If your mouse or touch pad does not have a right-click button, press "Ctrl+Shift+F10."

Select the "Delete" option to bring up the "Delete" dialogue window.

Specify whether you would prefer Excel to "Shift cells left" or "Shift cells up," then click the "OK" button.