Breaking a formula on a Numbers tab

"My instructions are:

• highlight data in columns x through x
• right click and select copy
• without moving data selection or clicking anywhere else, right click and select "paste as" or "paste special"
• select "values" from pop up menu. Click ok"

The same instructions, written for Numbers would be:

• Select the cells containing the data you wish to preserve.
• Press command-C to Copy the formulas and their results in those cells.
• Go to the Edit menu and choose Paste Formula Results.

(There is a keystroke combination 'shortcut' that will 'Paste Formula Results', but it involves three modifier keys and the usual paste key (v).

           shift-option-command-v

You might use that if you were doing this every day, but for processes done once a year, the trip to the Edit menu is easier to remember.

Regards,

Barry

Hi Lisa,

Perhaps you want Menu > Edit > Paste Formula Results.

Regards,

Ian.