Results 1 to 6 of 6

How to stop adding automatic reference to cell when I click on it after I wrote a formula

Threaded View

  1. #1
    Registered User
    Join Date
    05-03-2021
    Location
    US
    MS-Off Ver
    2016
    Posts
    18

    How to stop adding automatic reference to cell when I click on it after I wrote a formula

    When I'm writing a formula in a cell then click on another cell it adds a reference to that cell. How do I stop this from happening?
    For example--when I have copied the contents of a cell, and I am trying to simply paste it into another cell, it will instead try to add the contents of that cell to the first cell (=$A$9 or something like that will appear in the second cell while $A$9 is added to the formula in the first cell) and I will have to press Esc, which sometimes works (other times it goes back to selecting the first cell), and then paste it.
    When I google this most of the results are about the unrelated question of keeping absolute values when you paste into another cell. This is what I am talking about: how-to-get-excel-out-of-select-cell-mode superuser
    Last edited by reagr; 05-03-2021 at 04:54 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 08-24-2020, 10:37 AM
  2. [SOLVED] Stop Automatic Cell formatting to a date.
    By Noobulon in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-12-2017, 07:01 AM
  3. Replies: 5
    Last Post: 01-15-2016, 06:16 PM
  4. Click Button to start/stop a Stop Watch
    By Aeneren in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-14-2016, 01:25 PM
  5. [SOLVED] VBA Codes who insert the automatic worksheet when click a cell and all datas of its
    By PRADEEPB270 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-14-2013, 03:32 AM
  6. STOP automatic cell formatting
    By justinb2 in forum Excel General
    Replies: 6
    Last Post: 08-02-2011, 12:14 AM
  7. [SOLVED] Right click on cell to set formula reference as absolute
    By Neil in forum Excel General
    Replies: 1
    Last Post: 03-14-2006, 03:10 PM

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