Assuming this is possible, how do I add the same comment to multiple cells in Numbers ’09? The prospect of having to add them one at a time gives me a headache just thinking about it.
Unfortunately, it is impossible to add a comment to multiple cells automatically in Numbers. If, however, your comments are being stored in spreadsheet cells instead of the Comments feature in Numbers, there is an easy way to repeat the data stored in these cells.
Dragging the fill handle left/right or up/down will copy the data in the original cell to the other cells.
One way to do it is to use a little-known spreadsheet feature called Fill Handle. This feature can be used when you are adding the same data to consecutive row or column cells. Type your data into the first cell, and then click and drag on the little bubble at the bottom-right of the cell. When you drag up/down or left/right from the original cell, the consecutive cells will be filled with the same data.
GOT A TECH QUESTION OR A HELPFUL TIP TO SHARE?
Email ask@maclife.com or write to Mac|Life,
4000 Shoreline Ct, Suite 400, South San Francisco, CA 94080
