Special paste column widths is not coming up in Excel 2007?

G

Guest

In Excel 2007 I am trying to paste the column widths from another area. I
have done this many times with 2006 or earlier but with 2007 I try to go to
special paste and get a bunch of weird stuff (ie options to paste as a
bitmap, office excel 8.0 format, XML, etc) and not the usual things (ie
formulas, formats, column widths etc). Has anyone else encountered this??
 
N

Nick Hodge

In copying the data you are also copying an object. Image, chart, shape
whatever. Make sure you do not include this in the selection and all should
be well. the functionality hasn't changed between 2003 and 2007

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/
 
G

Guest

Thanks!

Nick Hodge said:
In copying the data you are also copying an object. Image, chart, shape
whatever. Make sure you do not include this in the selection and all should
be well. the functionality hasn't changed between 2003 and 2007

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/
Click to expand...
 

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

Paste Special Values 2
Paste Special not working 4
Copy column, paste special formulas & number formats doesn't work 3
Paste special for formulas 4
excel 2007 pivot table: how to paste special formats? 1
Paste Special in Excel 2003 6
No "Comments" in Paste Special 5
Stop Excel 2007 from Changing Column Widths 4

Top