I work for a small mortgage company and we keep a Google spreadsheet active at all times with each officer’s open loans so that everyone has access to loan numbers and we can all keep track of where each one is in the process. Once a loan is funded it is cut and pasted to a new page labelled “funded” and then again when paid.

The issue I am having is that nearly every time I go to add a new loan, even if all of the rows above it are correct, half the entries suddenly lose their alignment. I have it set so that every entry in column C is aligned left, but then when I go to write in a new loan (manually-- I don’t import), the data for just that cell in column C aligns right. So I select the entire column again and set it to align left. Three loans later and I have to do it over again. It’s not that much effort but it is aggravating as hell and I just want my alignments to stay as I assign them.

My meager understanding is that when someone is cutting and pasting, they’re taking the data AND the formatting with them. How do I prevent this? Is there code I can use in the script? Is there a different way to get the data from one page to another without taking the formatting with it that I can harangue my processors about until they do that instead?

  • 1
    Welcome to [webapp.se]. What do you mean by " Is there code I can use in the script? " Are you already using a script? Have you using scripts before?
    – Rubén
    Nov 19 at 20:44
  • I am not using a script, nor have I before but I'm willing to learn should I need to. I've seen in other help forums where people have used code to alter or add to the appscript I believe? Similar to this one
    – Reznikov91
    Nov 19 at 20:50
  • If you want to learn about using scripts in Google Sheets, please start by reading developers.google.com/apps-script/guides/sheets. If you need further help, please show what you have tried and add a brief description of your search efforts related to this specific question as is suggested in How to Ask.
    – Rubén
    Nov 19 at 20:56
  • Is that data that should be left-aligned numerical (true numbers)? Or strings? In any case, you can try pasting with key combination Ctrl-Alt-V (i.e., "Paste Special") as opposed to just Ctrl-V (regular Paste) and then choosing "Values only" from the clipboard icon that appears lower left. It's difficult to give solid suggestions when we can't see the sheet in question or try to reproduce what you're experiencing. I invite you to make a copy and share the link. "View only" permission is fine.
    – Erik Tyler
    Nov 19 at 21:14
  • This question is a copy of How to preserve formatting when cut and pasting across pages that has an answer. Nov 20 at 9:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.