![]() ![]() ![]() If you want to copy just values, please use the Paste Special option from the context menu or the CRTL+ALT+V key shortcut. If you use the key shortcuts CRTL+C / CRTL+V or the Copy / Paste options from the context menu, you copy not only formulas or values, but the format of the cells as well. Alexander Trifuntov (Ablebits Team) says:.The problem is, the border were also copied. I only want to copy the number inside a certain cell to the other cell having different border format. I want to sellect certain number from the column and delete the rest. I want to retain certain data based on their column number and delete the rest Reply How to show gridlines when cells are filled woth colour? They always disappear when i fill with colour Reply It turned out that my Conditional Formatting for those cells was the problem - I had told the cells to turn white instead of having them change to no colour. I had gridlines disappear from cells after I removed those cell's borders. ![]() Start with opening the worksheet where cell lines are invisible. In this case you need to check one of the following options in the Excel 2016 - 2010 Ribbon. Suppose you want to see gridlines in the entire worksheet or workbook, but they are just turned off.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |