+ Reply to Thread
Results 1 to 4 of 4

What to do when the function defination pop up blocking the cell I want to click?

  1. #1
    Registered User
    Join Date
    10-17-2022
    Location
    toronto
    MS-Off Ver
    2021
    Posts
    40

    What to do when the function defination pop up blocking the cell I want to click?

    blocking.JPG


    Thx for your knowledge.

    Please see the picture attached. For example, I am not able to click K3 cell, how do I resolve this?

    I understand I can type in the function bar, but is there better way?
    Last edited by fatkinglet; 10-23-2022 at 08:52 AM.

  2. #2
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,483

    Re: What to do when the function defination pop up blocking the cell I want to click?

    this is a downside of editing in the cell.

    If you have to reference neighboring columns it could be wise to edit them in the formula bar instead of the cell itself.

    you could even turn of editing in cell so you always edit the formula in the formulabar.

    https://support.microsoft.com/en-us/...c-4de0a8cf86d6

  3. #3
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: What to do when the function defination pop up blocking the cell I want to click?

    catch and move then select your cell

    dm.png
    Last edited by sandy666; 10-23-2022 at 09:09 AM.

  4. #4
    Registered User
    Join Date
    10-17-2022
    Location
    toronto
    MS-Off Ver
    2021
    Posts
    40

    Re: What to do when the function defination pop up blocking the cell I want to click?

    Thx All :D

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. searchable dropdown blocking blocking invalid data
    By Balazs Batta in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 01-28-2020, 03:19 AM
  2. Function to click cell and highlight row
    By eberns65 in forum Excel General
    Replies: 1
    Last Post: 07-19-2019, 04:09 PM
  3. [SOLVED] Worksheet_SelectionChange is blocking copy pastespecial function ..please help
    By wellous in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-13-2014, 01:01 PM
  4. How to have a date function when click on a cell
    By Helpme2010 in forum Excel General
    Replies: 1
    Last Post: 10-24-2010, 10:20 AM
  5. blocking a cell from going any further??
    By jacklindsay in forum Excel General
    Replies: 2
    Last Post: 10-02-2007, 09:27 PM
  6. [SOLVED] EssV functions Defination/Meanings
    By sujay in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-05-2006, 02:20 AM
  7. [SOLVED] Blocking entry of data in a cell
    By Rob in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-05-2006, 11:45 AM

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