Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy, paste
Excel 2007
I have a spread sheet with formulas and hidden columns. I would to copy and paste only the numbers in the shown cells. When I do this now, Excel paste all the formulas and hidden columns - how do I get only the numbers to show up? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy, paste
Press F5
Click on 'Visible Cells only' Press CTRL-C Go to your detination cell Right-Click and choose PASTE SPECIAL and click on Values and Click OK This will also copy the numbers in visible cells which are the result of formulas... Your post seem to suggest that you only wanted numbers... "George" wrote: Excel 2007 I have a spread sheet with formulas and hidden columns. I would to copy and paste only the numbers in the shown cells. When I do this now, Excel paste all the formulas and hidden columns - how do I get only the numbers to show up? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy, paste
select the range of cells to be copied
Before you copy Select the HOME Tab Click "Find & Select" Click "Go to Special" select the "Visable cells only" button and click OK then copy Paste as normal "George" wrote: Excel 2007 I have a spread sheet with formulas and hidden columns. I would to copy and paste only the numbers in the shown cells. When I do this now, Excel paste all the formulas and hidden columns - how do I get only the numbers to show up? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Copy, paste without file name referenced after paste | Excel Discussion (Misc queries) | |||
Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) |