+ Reply to Thread
Results 1 to 3 of 3

Auotmatic highlighting of a neighbouring cell

  1. #1
    Registered User
    Join Date
    05-26-2014
    Posts
    2

    Auotmatic highlighting of a neighbouring cell

    I have built a spreadsheet for my business which has an annoying feature I can't get rid of. When I click in a cell I want to enter data in the spreadsheet automatically highlights that cell and the neighbouring cell. I have to move away then back with the arrow keys to get back to the single cell I want to enter data in. has anyone struck this problem and have a solution?

    thanks

    Andy

  2. #2
    Forum Contributor
    Join Date
    06-24-2005
    Location
    excelliot.com
    MS-Off Ver
    2007
    Posts
    325

    Thumbs up Re: Auotmatic highlighting of a neighbouring cell

    Hi Go to excel option, then advance & untick extend data range & format...See attached Image..

    auto format cell.jpg

  3. #3
    Registered User
    Join Date
    05-26-2014
    Posts
    2

    Re: Auotmatic highlighting of a neighbouring cell

    thanks very much for your help

+ 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. [SOLVED] How to add up cells in a row based on criteria in neighbouring cell
    By bigbrain in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-30-2013, 05:55 PM
  2. [SOLVED] Trying to tie a drop down list into creating a value in a neighbouring cell
    By amitzala in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-17-2013, 03:08 PM
  3. score explanation in the neighbouring cell
    By polomacnenad in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-10-2012, 11:52 AM
  4. Auotmatic Recalculate
    By billykiller05 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 09-30-2009, 01:30 PM
  5. transferring comments to a neighbouring cell
    By keyes in forum Excel General
    Replies: 3
    Last Post: 09-16-2008, 05:26 PM

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