Antonia has attended:
Excel Intermediate course
Copy data
If I need to copy a piece of data, eg the same date, 1000 times on a spreadsheet, is there a quicker way than highlighting all the cells etc?
RE: Copy data
Hi Antonia,
Thank you for the forum question.
You will have to select the data you want to copy, but there is different ways of selecting data. You may also find it useful depending on how your data are structured to use a filter to help you fast doing your selections.
You can use a number of short cuts to select faster, and VBA coding can automate a task like this.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Copy data
Hello Antonia,
Here is a quick and easy way I use to copy data from one cell to many other cells (no scrolling required).
Step 1 – Select the cell with the data item (e.g. A1)
Step 2 – Click in the Name Box (top left above the column headers)
Step 3 – In the Name Box, type the cell address of the last cell in the paste range (e.g. A1000)
Step 4 – Press and hold the Shift key and also press Enter (this will select from A1 to A1000)
Step 5 – Press Ctrl + D (this will copy the data in A1 down into all the selected cells)
If you want to copy across columns, press Ctrl + R. If you want to copy into multiple columns and rows, press Ctrl + D then Ctrl + R.
Kind regards
Marius Barnard
Microsoft Office Trainer
