Fix Excel Gridlines and Cell Selection Disappearing After Paste Special
Question details
The user needs to restore worksheet gridlines and the visible cell selection border after using Paste Special between Excel worksheets.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Copying cells between worksheets and using Paste Special causes worksheet display elements to appear missing.
- Observed behavior
- Gridlines or the visible selection border temporarily disappear, although the cell formatting may be unchanged.
Check whether the worksheet uses a fill color, since filled cells can hide gridlines. Keep the View tab available so you can verify the Gridlines setting after refreshing the worksheet.
Refresh the Excel worksheet view after Paste Special
Use this solution when gridlines or the selection border disappear temporarily after copying and pasting between worksheets.
This behavior can be a display refresh issue rather than a change to cell formatting. Refreshing the sheet view often restores the gridlines and selection border without changing the pasted content.
Click another worksheet tab at the bottom of the Excel window, then click the original worksheet tab to return to it.
Click inside the worksheet and press Page Down, then press Page Up to force Excel to redraw the visible area.
Open the View tab, choose a different workbook view such as Page Layout, and then select View > Normal.
Enable gridlines and remove fills that hide them
Use this solution when gridlines remain missing after refreshing the worksheet or are hidden by display settings.
Use WPS Spreadsheet for a Lightweight Alternative to Excel
WPS Spreadsheet provides a familiar worksheet interface for copying cells, using Paste Special, controlling gridlines, and switching views. It is free and lightweight, supports common Microsoft Excel formats, and makes migration from Excel straightforward.

Frequently Asked Questions
Why do Excel gridlines disappear after Paste Special?
Excel may not redraw the worksheet correctly after Paste Special, so the display can temporarily hide gridlines or the selection border even when the cell data and formatting are still present.
How can I refresh Excel after gridlines disappear?
Switch to another worksheet and back, press Page Down followed by Page Up, or open the View tab, change the workbook view, and select View > Normal.
Where do I enable gridlines in Excel?
Open the View tab, find the Show group, and select Gridlines. This setting applies to the active worksheet, so check each affected sheet separately.
Can cell fill color hide Excel gridlines?
Yes. A fill color can cover the gridlines in selected cells. Select the cells, go to Home > Fill Color, and choose No Fill to reveal the gridlines.




