Copy, paste

  • Thread starter Thread starter George
  • Start date Start date
G

George

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?
 
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...
 
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
 
Back
Top