Keep rules & formatting intact when data is copied to cells

Closed

rchandran1 Posts 2 Registration date Tuesday October 21, 2014 Status Member Last seen October 22, 2014 - Oct 21, 2014 at 10:01 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 28, 2014 at 12:09 PM

Hi,

I have an excel sheet made with few rules and formatting for cells but many times I have the requirement to copy values to these cells from textpad or notepad or different excel sheet. When I do that, the existing rules & formatting of the cells is not getting applied to these copied values. It seems to be getting applied only when I key-in the values. Did anyone faced this issue and have some solution? Please help me if you know.

Keep rules & formatting intact when data is copied to cells
How to be offline in whatsapp when data is on - Guide
Tmobile data check - Guide
Transfer data from one excel worksheet to another automatically - Guide
Apply conditional formatting to the selected cells ✓ - Excel Forum
Based on the values in cells b77 b81 ✓ - Excel Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Oct 21, 2014 at 11:12 AM

Hi Rchandran,

Right-click the destination cell and choose "Paste special". Here you can choose to only paste the values. This will let you keep the format of the destination cell.

Best regards,
Trowa

rchandran1 Posts 2 Registration date Tuesday October 21, 2014 Status Member Last seen October 22, 2014
Oct 22, 2014 at 10:18 AM

Thank You TrowaD! Point is I will have many users who may copy data into this excel and they may or may not use paste special. Is there an option wherein I can lock the rules and formatting and users can copy however they want?

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Oct 28, 2014 at 12:09 PM

When you lock the format of a cell the contents are also locked and therefore pasting won't work.

A workaround could be to re-apply the format after every change made. Could you let me know how your sheets colour layout is (like column A = green, cell D5 = yellow etc.)?

Similar discussions

How to use conditional format based on text?

Highlight cell if another cell contains specific text

AMD data change update new data to DMI

Unlock safe folder without losing any data

Spreadsheet data

Similar discussions

Subscribe To Our Newsletter!