How do I copy a Formula in Excel

How do I copy a Formula in Excel

As a Virtual PA, I get asked for advice on how to use or do a simple function within a Microsoft package, today I have been asked how do I copy a formula in excel.  For those of us who use the software all the time, it is almost second nature and can be difficult to explain.  Nevertheless, some people don’t use Microsoft packages daily and need a little more help.  Most Virtual PAs ask you to send the document to them so they can do the work for you.

Therefor, today I will be explaining how to copy a formula in excel from one cell to another.  Any experienced Virtual PA will be able to do this for you in about 15 seconds.  This would include opening the document, making the change, and then saving and returning the document to you.  This does not, however, teach you how to do the task yourself and can cause hours of distress and frustration. 

For this reason, myPA Virtual Services have decided that we are going to run a series of blog posts that will teach you how to do these tasks.  We hope that you will find the instructions easy to understand and increase your knowledge of Microsoft.

HOW DO YOU DO THAT?

Question:

How do I copy a formula in Excel from one cell to another?

  1. Open the Excel Document and locate the cell with the formula. 

    A cell is an individual area on an excel sheet, a square, highlighted in the table below.  From this image below we have highlighted cell A1.  In an Excel document, you will have a Workbook, a Sheet, Columns, and Rows.  A cell is contained in a workbook, which is on a sheet that is located in one column and one row.
Excel Cells, what is a cell in excel
How do I copy a formula in excel
  • Select the cell you want to copy – A1 for example.
  • On your keyboard select CTRL button and C at the same time, see the image below.
How do I copy a formula in excel and how do I copy.

Alternatively, right click on your mouse and a new screen will appear.  From here select copy.  You have now copied the cell sum/information

How do I copy a formula in excel and I copy in excel
  • Move the cursor to the cell you wish to put the formula.
  • On your keyboard select CTRL button and V.

Alternatively, right click on your mouse and select Paste

How do I copy a formula in excel and how do I Paste.

You have now copied the sum/formula you wanted.

Excel Thesaurus

  • Workbook        The whole excel document
  • A Sheet           Within the document you can have some sheets.  Look at the bottom left of your workbook; you will see the word Sheet1.  This is your first sheet.  To add a new Sheet select the + button to the right.
How do I copy a formula in excel and what is a sheet in excel
  • A column         A column is the vertical lines in the workbook and are annotated with Letters.
How do I copy a formula in excel and what is a column in excel
  • A Row             A row is the horizontal lines in the workbook and are annotated with numbers.
How do I copy a formula in excel and what is a row in excel