Office Settings & Configuration

Fix Excel Gridlines and Cell Selection Disappearing After Paste Special

Ayan MasoodAyan Masood Nov 12, 2026 869 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Switch worksheets

Click another worksheet tab at the bottom of the Excel window, then click the original worksheet tab to return to it.

2
Refresh with Page Down and Page Up

Click inside the worksheet and press Page Down, then press Page Up to force Excel to redraw the visible area.

3
Return to Normal view

Open the View tab, choose a different workbook view such as Page Layout, and then select View > Normal.

Check the display before repasting: If the gridlines and selection border return after the view refresh, the pasted data usually does not need to be changed.
Free Microsoft Office alternative

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.

Use familiar worksheet tools for Paste Special, gridlines, and view controls.Open and edit Microsoft Excel XLS and XLSX files with strong format compatibility.Work in a free, lightweight office suite with a familiar interface.Move existing Excel workbooks to WPS with minimal workflow changes.
microsoft office alternative - wps office

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.