Copying data that is not set in a specific pattern

  • Thread starter Thread starter Zita du Toit
  • Start date Start date
Z

Zita du Toit

I have to put data in a column but to do that I have to
manually type in =B18; =B53; =B88 etc. for aLOT of data
points. The data is wregularly separated by 35 rows. Is
there a shorter way of doing this?
 
Hi!

Copy the formula, hold down CTRL and select all cells where you want to put
the formula, then paste the formula using Ctrl+V or Edit, Paste.


Best regards


Stefan Hägglund
Microsoft
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove $ from formulas 4
Excel Help to copy information from one row at a time to another sheet 1
... I need some help with a formula ... 3
Ctrl D with formulas 3
How to adjust chart auto'ly as new data is entered? 2
Formulas 2
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Copy paste data from a column to a row 0

Back
Top