Forum Discussion
cut and paste in excel
When I cut the data from a cell or row of cells, then paste them in a different cell I lose of the formatting from the first cell, (borders, shading, etc) This has not happened in previous files, (a...
Could you upload a sample of your file?
Just off the top of my head, though, I can’t help but wonder why you need to be cutting and pasting in the first place. If this is a check register, as it appears, there are other methods in Excel, to extract date from one place to another. So I’m wondering whether re-thinking how you use Excel might be more helpful.
I’m speaking as one who has not only a check register, but also a register of several credit card transactions—all integrated in one large register—from which I extract summary reports of spending by category. The extraction in my case is through the Pivot Table capability, which also allows drilling down to underlying particulars.
So let’s see if we can help you re-think your design.
Just off the top of my head, though, I can’t help but wonder why you need to be cutting and pasting in the first place. If this is a check register, as it appears, there are other methods in Excel, to extract date from one place to another. So I’m wondering whether re-thinking how you use Excel might be more helpful.
I’m speaking as one who has not only a check register, but also a register of several credit card transactions—all integrated in one large register—from which I extract summary reports of spending by category. The extraction in my case is through the Pivot Table capability, which also allows drilling down to underlying particulars.
So let’s see if we can help you re-think your design.
Here is a copy of my check register. This format has served me for years as my financial profile is really very simple and again for years this has taken me away from a paper checkbook.
I load future transactions as listed down a few rows in the checkbook. When a transaction hits my bank I simply cut and paste it up with my check register. This process has worked very well for quite a few years without deleting formatting in the cut and paste process.
When I copy and paste excel allows me to paste just the numbers without the cell formating. Not when I Cut and paste as I always have done before.
Thanks for taking a look at this.
Thx
Lee