microsoft excel training in london - formulas

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

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

microsoft excel training in london - Formulas

resolvedResolved · Low Priority · Version 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:

Display developer tab - Excel 2010

a. In Excel, click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the box next to Developer in the list of tabs on the right hand side of the dialog box. When ticked the Developer tab will be visible.
e. Click OK to apply your changes

View all Excel hints and tips


Server loaded in 0.08 secs.