![]() Use the mouse to grab the reference tab of the column you want to search, and drag it upward until you see it separate from the rest of the table. On the original table, click on any cell to make the table active and show the column and row reference tabs. Starts the same way, but this time select and delete the table that comes with the New Sheet. ![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |