Too many rows

[Richard]

I copied 200 rows and 3 columns from an excel spread sheet with 2,000 rows
and 3 columns. Now all my comments are hanging down around 1700 and 1800
row. What can I do to correct this?

Richard

 

[Dave Peterson]

You can use a macro to put them back to their original position:

http://contextures.com/xlcomments03.html#Reset
(From Debra Dalgleish's site)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm