Use copy and paste to copy grid data from one location to another.
You can copy either a single cell, or multiple cells, and paste the data in another location. You can paste to:
You can paste the value from a single cell into multiple cells. You can paste data into a maximum of 10,000 cells.
Alternatively, you can copy your selection across or down all cells.
If cells are breakback-enabled and held, you still overwrite those cells when you paste. If you paste into cells, breakback distribution applies to the other detail cells that you have not selected to hold.
To copy and paste data from a grid:
You can paste into multiple editable cells. If you paste into Breakback summaries, any detail cells paste first and are held, while the difference to the pasted summary value distributes across the remaining detail cells in their existing proportions. If you paste with Enable paste into detail cells only enabled, only detail values paste and their summaries recalculate. Learn more about Breakback.
To enable paste into detail cells only, either:
With Enable paste into detail cells only enabled, a message displays in a banner under the toolbar. Select Paste to paste only the detail cells, so summaries recalculate.
To deactivate Paste into detail cells only, follow any of these steps:
The message under the toolbar no longer displays.
We update Anapedia content regularly to provide the most up-to-date instructions.