How to select all the cells in a formula? For example, cell G5 has the formula (=+trial!G100+trial!G102+trial!G103) and I want to copy values in the original cells and arrange them on another sheet. Is there any way to do this?


Copy the cells as you normally would.

Then rather than pressing Ctrl+v you should press Ctrl+Alt+v to initiate the Paste Special command.

This will allow you to paste the values rather than the formulas.

Otherwise you can Ctrl+v as normal and then you will see a box pop up with Ctrl in it. If you press Ctrl then it will pop up with a list of paste options, one of those will be the option to paste values, it will be the little number icon you want.

enter image description here

If you right click before pasting then underneath the "Paste" option then will be a similar list of icons in 2007 or above.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.