Previous Topic Next Topic

Keep rules & formatting intact when data is copied to cells

Closed
rchandran1 Posts 2 Registration date Tuesday 21 October 2014 Status Member Last seen 22 October 2014 - 21 Oct 2014 à 10:01
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 28 Oct 2014 à 12:09
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.
Related:

1 response

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
21 Oct 2014 à 11:12
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 21 October 2014 Status Member Last seen 22 October 2014
22 Oct 2014 à 10:18
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 12 September 2010 Status Contributor Last seen 27 December 2022 555
28 Oct 2014 à 12:09
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

Hosted app data will not clear
Woody_3336 -
woody_3336 -

7 responses
Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses