Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2000 copy, edit, paste spacial, value. How Excel 2007 ??
How can I conver a formal like =3*4 to a number 12 (basically hide the
equation) in Excel office 2007? In excel office 2000, it is simple, copy, select edit, then Paste Spacil, then Value and the result will show the number 12. Thanks you very much, Boaz Amir |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2000 copy, edit, paste spacial, value. How Excel 2007 ??
It still works the same if you're using the right click menus.
Select the cell in question Right clickCopy Right clickPaste SpecialValuesOK Using the ribbon commands: Select the cell in question Home tabClipboard groupCopy iconPaste drop downPaste values Here's how I do it: I put the Paste values icon my QAT I right clickCopy Then click the Paste values icon on the QAT -- Biff Microsoft Excel MVP "Boaz Amir" <Boaz wrote in message ... How can I conver a formal like =3*4 to a number 12 (basically hide the equation) in Excel office 2007? In excel office 2000, it is simple, copy, select edit, then Paste Spacil, then Value and the result will show the number 12. Thanks you very much, Boaz Amir |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy and paste in Excel 2007 slow | New Users to Excel | |||
how can i turn on the copy/paste functionality in excel 2000 | Excel Discussion (Misc queries) | |||
Excel 2000 freezes when I try to Copy & Paste after start-up. | Excel Worksheet Functions | |||
EXCEL 2000 - COPY & PASTE FUNCTIONS! | Excel Discussion (Misc queries) | |||
How do I edit, copy and paste text in excel cells? | New Users to Excel |