UK Karting - Notice Board (Chat) : Re: Anyone good with Excel please?

Notice Board (Chat)

Re: Anyone good with Excel please?
Posted by 'davidmc' on 06 Apr 2010 @ 16:51

| View Message Thread | Reply to this message |

davidmcJoined: April 2003
Total Posts: 2
[ View User Profile ]

It all depends what you are copying, what you want to keep (values, formatting, comments, formulae etc) and what you are pasting into (Excel, Word etc).

Assuming it's a straight forward, Excel to Excel copy with no formulae, simply copy (Ctrl C or Edit -> Copy), highlight the starting cell where you wish to paste, then Edit -> Paste Special, select "values", click OK. If it includes formulae, the same process applies but I can't recall the options to exclude formatting.

If it's Excel to Word, a Paste Special in Word will reveal all the copying options too. If copying into non-MS Office apps, your guess is as good as mine.

If all else fails, a Macro or VBA script will do it.

Dave

Message Thread:

Anyone good with Excel please? by 'alanrr' (06 Apr 2010 @ 16:02)

Re: Anyone good with Excel please? by 'DavyBoy' (06 Apr 2010 @ 16:32)

Re: Anyone good with Excel please? by 'jfracing' (06 Apr 2010 @ 16:36)

Cheers Peeps! Done and dusted. (nt) by 'alanrr' (06 Apr 2010 @ 16:47)

Re: Anyone good with Excel please? by 'itpro' (06 Apr 2010 @ 16:37)

Re: Anyone good with Excel please? by 'davidmc' << You are here!

Re: Anyone good with Excel please? by 'SimonS' (06 Apr 2010 @ 18:25)

That's what we did first Simon. Great Minds :) by 'alanrr' (06 Apr 2010 @ 19:30)

Post a Reply:

You may post a direct reply to this message which will appear in this thread.
To post a new or unrelated message use This Form. Top of Page
Notice Board Index

[ UK Karting Main Index ]


News	Karts & Karting	Notice Board	Market Place	Companies Directory	Tracks Directory	Events Calendar	Race Results	Photo Gallery	Links