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

microsoft excel training in london - formulas

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training in london - Formulas

microsoft excel training in london - Formulas

ResolvedVersion Standard

Michael has attended:
Excel Intermediate course

Formulas

When copying cells with formulas from one sheet to another, how do i solve this so the numbers come across rather than blank cells?

RE: Formulas

Hi Michael,

Thanks for using the forum.

I suggest you use the Paste special option. Highlight the data you want to copy and click copy and then go to the edit menu and click Paste special and when you get the dialog box come up click "Values" so only the numbers come across.

Hope that helps

Tracy

Excel tip:

Finding your worksheets quickly

The arrows to the left of the worksheets are used to move between one sheet at a time or first / last worksheet, but if you right click on the arrow buttons it gives you all worksheets in your workbook.

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.1 secs.