Forum Discussion
greshoff
Jun 10, 2024Copper Contributor
Grey lines inside grid lines
Hi I have some lines inside the grid lines on some of the cells on my spreadsheet. What are they and how do I remove them just leaving the grid lines? Many thanks
Martin_Angosto
Iron Contributor
Have you probably pasted data from another source into that spreadsheet?
You can delete these borders by going to the Home tab of the ribbon > Borders > No border
Alternatively, select a cell without any format, click on the Format Painter on the left of the attached image above and then select the cells with these greyed borders in order to apply the former selected format and delete these borders.
greshoff
Jun 10, 2024Copper Contributor
Many thanksMartin_Angosto much appreciated
- Martin_AngostoJun 10, 2024Iron Contributor
So glad you could solve it, greshoff
Please consider leaving this discussion as solved by marking the answer as a solution to help future users.