Where is "Paste Values" in Maverick's Numbers

Question

Level 4

2,104 points

Where is "Paste Values" in Maverick's Numbers

This is not good. With the new Maverick upgrade my long standing Numbers spreadsheets use has taken a turn for the worse.

My newest concern -- I can no longer "Paste Values" from the edit menu. This is a major issue.

Other concerns:

My old large spreadsheets automaticlally zoom to 125% with no way to set the default zoom to where it should be (100%).

The Inspector shows up covering a large part of my spreadsheet with no way to set hide in the defaults.

Help. I really hate the idea of going back to Excel.

iMac, OS X Mountain Lion (10.8)

Posted on Oct 24, 2013 1:17 PM

Reply

Answer 1

Best reply

SGIII

Level 8

35,276 points

Oct 24, 2013 1:23 PM in response to Bob H.

The paste values functionality is there, under a shiny new name. It appears after you "copy" a cell (or cells) containing a formula.

SG

Reply

Answer 2

Oct 24, 2013 1:28 PM in response to Bob H.

Bob,

You can relax about the Paste Values, it just got a name change. It's now Paste Formula Results and has the logical Keyboard Shortcut Shift-Command-V. This is a big improvement because Paste Values never had a shortcut.

Jerry

Reply

Answer 3

Bob H. Author

Level 4

2,104 points

Oct 24, 2013 1:36 PM in response to Bob H.

Thank you SGIII and Jerrold for your quick responses. SGIII -- you got the "Solved" because of being first, but Jerrold you got a "Helped" kudo anyway. I owe myself one also. I just discovered that "Paste and Match Style" works. I don't think that would have worked in the past, but I am not sure. I know just a "Paste" would have messed things up good.

Reply

Answer 4

Oct 24, 2013 1:59 PM in response to Bob H.

Paste and Match Style is a very helpful feature. It's by far the best way insert data into a document without having to reformat it after it lands. It's worked in all versions.

Jerry

Reply

Answer 5

Bob H. Author

Level 4

2,104 points

Oct 24, 2013 6:47 PM in response to Jerrold Green1

Jerry -- Thanks again. What I have been doing is a csv download into a Numbers spreadsheet followed by copying one column of numbers and doing a "Paste Values" into another spreadsheet. Using "Paste" somehow messed up the receiving spreadsheet (not just a format problem). Therefore I had assumed that "Paste and Match Style" was going to do the same.

Reply