Never mind. It is the same I guess as for microsoft office: place cursor in the row number “cell”, type ctrl-c (copy), then shift-spacebar (selects entire row), then ctrl-shift-v (paste special), and then enable copying only formats from the resulting menu and click “OK”.
On the other hand, let me know if there is an easier way.
thanks,
-eric