training microsoft excel - copy function
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training microsoft excel - Copy function

training microsoft excel - Copy function

resolvedResolved · Low Priority · Version Standard

replyReply Fri 21 Dec 2007, 17:02Delegate Iain said...

Iain has attended:
Excel Advanced course

Copy function

How can I stop permanently the COPY panel from popping up each time the CTRL C & V funtions are used twice in a row. The options settings on the panel seem to get overridden each time they are set for the panel not to pop up?

For upcoming training course dates see: Pricing & availability

replyReply Wed 2 Jan 2008, 09:21Trainer Pete said...

RE: Copy function

Hi Iain, Thank you for your post, I hope you had a good break over the holiday season, in answer to your question I am assuming you mean the Paste Options button if this is correct then follow these steps:

Excel displays the Paste Options button on the worksheet to provide you with extra options, such as Keep Source Formatting and Match Destination Formatting, when you paste cells.

On the Tools menu, click Options.
On the Edit tab, clear or select the Show Paste Options buttons check box to hide or display the Show Paste Options button on the worksheet.

I hope that helps , regards Pete

 

Excel tip:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

See also: Autonumber in Excel forum post.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard