+ Reply to Thread
Results 1 to 2 of 2

Cell values after inserting rows.

  1. #1
    Registered User
    Join Date
    05-05-2020
    Location
    Cleveland, Ohio
    MS-Off Ver
    16.16.13
    Posts
    2

    Cell values after inserting rows.

    OSX10.15.3 Excel 16.16.13

    I apologize for the size of the screen shots, but I can't figure out how to reduce them, nor can I produce the results in a smaller file to attach. Cells copied to a new file don't reproduce the issue.

    After inserting some rows in excel, the selected cells don't "line up with" the values in the formula bar. Values typed IN a cell show up in the cell BELOW. In the example below, the selected cell shows 88 in the cell, but displays 89 in the formula bar (The 89 in the formula bar appears in the next cell below the 88.) Excel 2.jpg

    Also, after inserting multiple rows, if I enter sequential values in a few rows, then drag down to continue the sequence, I end up with skipped rows. Excel 3.jpg

    Another "symptom" is that when I select a row (376 in this example), it appears like this: Excel 4.jpg -

    This is VERY frustrating, and doesn't happen all the time; the only thing I can figure out is that it seems to happen on a new page. My solution so far is to keep deleting values from the affected cells and typing in again, and eventually I can type the values I want in the cells. I've never had this problem before, but it's as if there are bogus cells being inserted when I copy rows. I've tried reformatting the affected cells, manually deleting content in the cells, and nothing seems to work.

    Thanks for any help you can provide!

  2. #2
    Registered User
    Join Date
    05-05-2020
    Location
    Cleveland, Ohio
    MS-Off Ver
    16.16.13
    Posts
    2

    Re: Cell values after inserting rows.

    I figured out that if I switch from Page view to Normal view, the issue doesn't happen. I don't understand why the page view is unworkable, but this fixes my immediate problem.

    Pat

+ 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. Using Values in VBA that change when inserting Rows/Columns
    By NewYears1978 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-07-2018, 03:39 PM
  2. Inserting Rows Based on Values in Different Sheet
    By le.gibson13 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-25-2017, 01:06 PM
  3. [SOLVED] Obtaining values from equally spaced columns and inserting in rows where they match
    By dhiresh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-04-2013, 07:48 AM
  4. need help inserting blank rows where values are missing
    By excel_dummy22 in forum Excel General
    Replies: 0
    Last Post: 06-23-2011, 12:10 PM
  5. Replies: 1
    Last Post: 09-22-2010, 12:16 AM
  6. inserting rows with default values
    By silverh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-11-2005, 02:44 AM
  7. Inserting/Deleting Rows when values are added /cleared
    By teresa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2005, 11:06 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