Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
copying cells

ResolvedVersion 2003

Elaine has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Copying cells

When I was on my course we were shown a quick way to copy cells into a large document. I want to copy a formula into a 13000 record set. I can do it drag and drop but wondered if there was a quicker way??
Thanks a lot
Elaine

RE: Copying cells

Hi Elaine, thanks for your query. Can you give me a bit more information about what you're trying to do? You mention a document, a formula and a recordset - which is terminology from three separate applications! What are you trying to achieve?

Anthony

Tue 5 Jul 2011: Automatically marked as resolved.

Excel tip:

New to Excel 2010 - Sparklines!

Excel 2010 includes a new feature called Sparklines which are tiny charts that fit into a single cell and plot data in cells from the worksheet. There are a host of formatting and styles that can be applied to them and they are really quite interesting.

>insert
>sparklines
>Choose any style you want

You will be asked for the range and it will automatically select the cell your in to insert the sparklines.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.