Copy, paste

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?
 
S

Sheeloo

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...
 
W

Wid

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy/Paste with Hidden Rows/Columns Excel 2007 3
Paste Special Values 2
Copy Formulas 1
COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6
Copy paste data from a column to a row 0
Copy & paste 2
Excel 2007 2
Copy visible cells only 1

Top