ExcelBanter - How can I lock the gridlines in an excel spreadsheet?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I lock the gridlines in an excel spreadsheet? (https://www.excelbanter.com/excel-discussion-misc-queries/115144-how-can-i-lock-gridlines-excel-spreadsheet.html)

myers0730

How can I lock the gridlines in an excel spreadsheet?

How can I lock the gridlines in an excel spreadsheet, so that, when I copy
and paste an item in the cell, I do not change the formatting of the grid
lines?

willwonka

How can I lock the gridlines in an excel spreadsheet?

Look at doing a paste..special. If it is just values,
Paste...Special...Values.. If it is formulas,
Paste..Special..Formulas... etc..

HTH.

myers0730 wrote:
How can I lock the gridlines in an excel spreadsheet, so that, when I copy
and paste an item in the cell, I do not change the formatting of the grid
lines?

All times are GMT +1. The time now is 11:45 AM.