Forum Discussion
Excel copy and paste
Hi, I use excel spread sheets for AIA invoicing in which I have one made up already with the info I need so all I have to do is copy and paste then rename and add the needed info to the spreadsheet also added in a new folder. Lately when I copy and paste the original spreadsheet gets changed even when I add under new name and folder it never did this before, is there an update that changed how this works?
1 Reply
By default when you copy (or cut) and paste in Excel, everything in the source cell or range—data, formatting, formulas, validation, comments—is pasted to the destination cell(s). This is what happens when you press CTRL+V to paste. Since that might not be what you want, you have many other paste options, depending on what you copy.
For example, you might want to paste the contents of a cell, but not its formatting. Or maybe you want to transpose the pasted data from rows to columns. Or, you might need to paste the result of a formula instead of the formula itself.
More informations in the upper link.
