Select the column, Copy, return to the original, Select the column, Paste. Then go back to the 'current sheet', select the column, and Copy.Ĭlick on the new sheet to bring it to the front, click on the top body cell (B2) of the empty table that came with that sheet and Paste.ĭo Find/Replace, restricting the action to the Current Sheet. I would recommend making duplicates of your file to use when trying each of these methods. To use that, you'll have to isolate the column (or it's contents) on a separate sheet, and make that the 'active sheet.' Of the three choices, the one that seems most immediately useful in 'on the active sheet.'
Welcome to Apple Discussions and the Numbers '09 forum.
