Results 1 to 3 of 3

Copy Paste of precedent cell [B3] w/ formula cell [C5] (=$B$3) acts differently 2003vs2016

Threaded View

  1. #1
    Registered User
    Join Date
    03-08-2005
    Posts
    1

    Copy Paste of precedent cell [B3] w/ formula cell [C5] (=$B$3) acts differently 2003vs2016

    In Excel 2003, copying
    B3 which contains 23 and C5 which contains =$B$3 and pasting seven rows down gave
    B10 which contains 23 and C12 which contains =$B$12
    In other words, when the precedent cell and the formula were copied at the same time, the new pair had the same spatial relationship as before, looking two up and one cell to the left

    In Excel 2016, the same copy and paste gives
    B3 which contains 23 and C5 which contains =$B$3 and pasting seven rows down gave
    B10 which contains 23 and C12 which contains =$B$3
    In this case the pasted formula ignores the cell two up and one to the left, and instead looks nine rows up and one to the left.

    Microsoft thought they were solving a flaw, but I had found it very useful in transferring things as a group without having to redefine the spatial relationship. How can I emulate the behavior from Excel 2003 in Excel 2016???
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy - Paste entire table into one cell using active cell formula
    By alexgoaga in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-08-2017, 10:14 AM
  2. [SOLVED] Macro acts differently when ran directly or through a command button
    By Caturne3 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-08-2015, 09:28 AM
  3. Copy, Paste formula output from one cell to another cell with values
    By MEYYAPPANS in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-04-2015, 01:34 PM
  4. [SOLVED] Formula: Paste value to cell and copy itself to cell below
    By MIGARDEIN in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-18-2015, 09:31 AM
  5. [SOLVED] Copy/Paste cell above the formula or active cell
    By hockeysimo09 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-15-2014, 10:35 AM
  6. Excel Macro Acts Differently on Different Computers, even with same version
    By dbaft in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-24-2011, 07:58 AM
  7. FORMAT SECTIONS OF CELL FORMULA DIFFERENTLY
    By Takeadoe in forum Excel General
    Replies: 3
    Last Post: 07-13-2006, 11:25 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1