-
Solution 1: Hide cells. Hide the cells in columns A and B, move the mouse to the line in the middle of the two cells with A and B, and hold down the left mouse button to move to the left until A is out of sight.
Solution 2: Office clipboard. There are some differences between office versions, take office2003 as an example, don't delete the content in a and b, check the content in c to keep the copied content, and press the above-> office clipboard.
At this time, an office clipboard dialog box pops up on the right, which contains the content you just selected to copy, select the cell you want to paste, for example, d, and double-click the content you want to copy in the office clipboard dialog box. (If you haven't copied or cut before, the Office clipboard dialog should only be what you just copied in, and you can paste it all at this point).
-
My solution: first re-enter the value of column C in column C with the keyboard to overwrite its value. That is, if "56" is displayed in a cell in column C, use the keyboard to re-type "56" into the cell.
In this way, when the data in columns A and B is deleted, the numbers in column C will not change. It's a bit clumsy, but I think it's quite useful.
-
I don't know a more direct way, but you can: select column C, press Ctrl C twice, that is, copy it to the pasteboard on the right, and then paste it in one place (click on the pasteboard on the right to paste, don't use Ctrl V), and delete the original content casually.
-
Because the value of column C is obtained by adding column A to column B, when you delete column A and column B, column C will also become O...
The only solution is to re-enter the resulting values!!
-
After calculating the result of column C, select column C to copy, and then right-click Paste Selective Value OK.
-
Haha, listen to me!
I've just tried it successfully, deleting the data in the A and B columns can't work, you first create a new execl, you have to cut the data in the A and B columns into the new execl, and the value of c will not change!
-
You can hide the ab column and say, so that you can change it if the data changes in the future.
-
Select column C directly. Shear.
And then keep it separately, theoretically because it should be like this.
The first multi-computer was born in 1985, and its main function refers to the combination of audio, graphic images and computer interactive control for comprehensive processing. >>>More
How to cook headphones.
Using an FM radio, tune the radio to a channel with no signal and keep the volume below 20. At this time, the sound of zzi is equivalent to the white noise disc we usually use to burn the machine. It takes about 8 hours a day to boil the new headphones for a week to two weeks. >>>More
1.The main frequency is the working frequency.
2.It doesn't matter if the two cores add up or the main frequency does not matter with the core, or whether the two cores : it is the frequency of the two cores alone. >>>More
No, if you have a recorder on your computer, you can burn the disk, Jianxing, it's an old brand, it's better, first of all, you're ** a burning software, oops, if you buy a recorder, it should drive the disc to you, steps, look at what you burn, the software interface is introduced, you should get started quickly, come on, hehe.
According to the provisions of the Consumer Law, it is the consumer who purchases the goods and receives the service, and the operator shall ensure the personal safety and property safety of the consumer. Therefore, the above tips can only exempt the operator from part of the liability, but not all of the liability. >>>More