How do I add a row and keep cell formatting?
I've set up this sheet with columns having varying formatting. Columns A, B, and C have a pop-up, column D has a slider, and column E ordinary text.
When I add rows below, as in 20 and 21 in the screenshot, the formatting isn't copied. I only get blank cells with automatic fomatting set by default.
Is there a way to
1. Add a row, keeping all the formatting of the row above? or
2. At least copy the formatting and paste it into the other cells? I've tried Copy, copy style, paste, paste style, but none of these seem to work.)
When I add rows below, as in 20 and 21 in the screenshot, the formatting isn't copied. I only get blank cells with automatic fomatting set by default.
Is there a way to
1. Add a row, keeping all the formatting of the row above? or
2. At least copy the formatting and paste it into the other cells? I've tried Copy, copy style, paste, paste style, but none of these seem to work.)
Mini Core 2 Duo 2.4 GHz, MacBook Air 1.6 GHz, Mac OS X (10.6.4), Newer Ministack External HD's
