Feedback by UserVoice

How can we improve Excel for Mac?

After selecting cells, the context menu should contain a "Convert from formulas to values" item. It would save so many clicks!

3 votes
Sign in
(thinking…)
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

Bo Green shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Anil commented  ·   ·  Flag as inappropriate

    You can do so with one click:
    Select the range
    RightClick to drag elsewhere;
    WITHOUT letting go, bring it back to original location.
    Shortcut menu has a "Copy here as values only" choice.

  • Richard commented  ·   ·  Flag as inappropriate

    I agree that it would be nice, but meanwhile, you can do this with a macro. I made one that copies, pastes values, and converts any n/a to 0. So after a lookup, I press the three key combination and my column is ready.
    I probably do this 50 times a week, if not more.

Feedback and Knowledge Base