+ Reply to Thread
Results 1 to 10 of 10

Columns moving up and down on their own in a worksheet. What Goes?

  1. #1
    Registered User
    Join Date
    01-17-2022
    Location
    Aventura,Florida
    MS-Off Ver
    365 Standard
    Posts
    6

    Columns moving up and down on their own in a worksheet. What Goes?

    Dear fellow members, HELP!

    I am brand new here and I hope that I can find somebody who might help me with a mighty problem happening to me while working a worksheet in a spreadsheet.

    1.- Some (not all) Columns have a tendency to move its cells one space up or down, usually they are the leftmost Column and the rightmost column. It produces a very awkward situation with the whole page.

    2.- The formatting procedure in the cells have the tendency to change, specially line thickness around a cell and also sometimes the color.

    I am basically trying to find somebody who might know mostly the quirks and sometimes unexplainable vagaries that this application has begun showing when you are using it. My main question and interest is in trying to find out why in the last couple of months, in excel, a few of the worksheets in one of my files have begun moving and displacing individual columns and cell formats throughout the pages of my work in the vertical. It is for me a wonder, since in all the years I have been working on this application I have never encountered such a phenomenon. Since your work in life, I presume, has mainly used excel as a tool for your control, I am firing this shot in the dark in my desperation to find a solution to my present problem.

    I have been using Excel's forerunner since 1984 in the early PC's by IBM, and then using excel in each one of the iterations that Microsoft brought out to the market, and I never, but never before encountered a page that moves columns in the vertical, and modifies the nature of the formatting values of the cells in each page, with no explainable reason for it to do so. Weird!

    So, if by any chance you might be able to come up with an idea for this to happen, or know someone who might be able to have an inkling of why this could be happening, I will be very grateful to you.

    Thank you

    Boris

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,025

    Re: Columns moving up and down on their own in a worksheet. What Goes?

    Does the file in question contain code?

    I've never seen this, though....
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    01-17-2022
    Location
    Aventura,Florida
    MS-Off Ver
    365 Standard
    Posts
    6

    Re: Columns moving up and down on their own in a worksheet. What Goes?

    Thank you very much for your kind interest Mr. Green

    As I mentioned in the few paragraphs I sent, I have been working for quite a few years on a spreadsheet that I constantly use to record my private expenses through the years (started around 2010) and the very early years I had no problems.
    I resorted every year to just rename each file from "Expenses 2010" to a newly saved one called Expenses 2011, and worked on top of that spreadsheet and on each of the five worksheets which that file comprised. That probably has meant that a lot of writing on top of every one of those cells have been reworked through the years.

    Sorry for my ignorance but I do not understand the meaning of your question of how much "code" each cell is carried in each one of the cells. Have I been using a method of using a spreadsheet for every new year based on the last one? Does the spreadsheet become so filled with "code" that it finally becomes unusable?

    My present problem began about a year ago when I observed that some columns kept going up or down on the left and right end of the spreadsheet. I kept correcting this quirk manually by moving and correcting the formatting troubles that caused me, but usually it wouldn't last long and the problem would reappear either on the same cells, or worse yet, on new ones.
    The formatting of lines in cells and colors entered for those cells would also change without rhyme or reason (that I could understand)

    But, the problem has worsened as I go along the time I am working with the worksheet which has prompted me to humbly ask and request some help and advice. Now I fear for the integrity of the contents of the worksheets and do not have any idea of what could be happening.

    When I format a row designating a continuous color and thickness that runs from one end of the worksheet to the other end, sometimes when I have to do some changing or supplanting information in one cell, the line formatting of the cell will change. Or, also, one of the contiguous cells will be affected and change and I will have to go back to correct that action.
    Needless for me to say that this situation has become unbearable and I am thinking of creating a brand new spreadsheet for my yearly expenses every time. Can I just copy the last spreadsheet I have that did not do all the mistakes this latest one is doing?

    I am right now trying to create a sample workbook that I will be able to show graphically what my problem is, like a master set without any information written inside the cells?

    The main worksheet that I work with has 17 columns and about 1600 rows of used space. Worksheets 2,3,4,5 are much smaller in size and complexity. The whole spreadsheet varies from 750 mb to 1.2 Gigas at most.

    Any help that you could provide me with will be greatly appreciated.

    As I mentioned, I am brand new in this forum and do not know my way around, but I am willing to learn.

    Thank you for your patience.

    B. Suster
    Last edited by BorSus; 01-18-2022 at 11:19 AM. Reason: incomplete information

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,779

    Re: Columns moving up and down on their own in a worksheet. What Goes?

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Registered User
    Join Date
    01-17-2022
    Location
    Aventura,Florida
    MS-Off Ver
    365 Standard
    Posts
    6

    Re: Columns moving up and down on their own in a worksheet. What Goes?

    Ms AliGW,
    Thank you very much for your kind welcome!
    I am baffled at the situation I am in, with my spreadsheet doing whatever IT wants, instead of working as it should. I have been using Excel for quite a few years, but never as a database professional, just for light work. And now I am bewildered by the things happening in my worksheet.
    I have sent Mr. Glenn Green an account of what I am going through with my Excel at this time and any help and advice will be greatly appreciated. Maybe someone has an explanation and a cure for this problem.
    I will try to send a sample of my work for your attention.
    Once again,

    Thank you very much!

    Boris Suster

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,779

    Re: Columns moving up and down on their own in a worksheet. What Goes?

    I have sent Mr. Glenn Green an account of what I am going through with my Excel at this time ...
    If you mean what you have already posted in this thread, then yes, we can all see it. If you mean that you have sent Glenn Kennedy a private message, then please keep everything here in the thread.

    If you attach a workbook here showing the issue, we shall both be able to access it.

  7. #7
    Registered User
    Join Date
    01-17-2022
    Location
    Aventura,Florida
    MS-Off Ver
    365 Standard
    Posts
    6

    Re: Columns moving up and down on their own in a worksheet. What Goes?

    Thank you for your advice, but for some reason I cannot seem to be able to find Where is the Attachment button where is the workbook attachment that I wish to show.
    Even in one post from Mr Glenn mentions that the attachment button is not working so I should try a different tactic, but even that one has not worked for me.
    Could you kindly please help me with additional instructions?

    Boris

  8. #8
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Columns moving up and down on their own in a worksheet. What Goes?

    there are instructions at the top of the page, inside yellow box.

    this also might help you:

    how-to-upload.png

  9. #9
    Registered User
    Join Date
    01-17-2022
    Location
    Aventura,Florida
    MS-Off Ver
    365 Standard
    Posts
    6

    Re: Columns moving up and down on their own in a worksheet. What Goes?

    I am sending here an attachment related to this thread, and want to thank Mr Morrison for his kind advice.
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    01-17-2022
    Location
    Aventura,Florida
    MS-Off Ver
    365 Standard
    Posts
    6

    Re: Columns moving up and down on their own in a worksheet. What Goes?

    Janmorris

    I have just been able to include an attachment, thanks to your kind help is finding out how. Please advice if you have received it.
    Thank you.
    Boris

+ 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] Transfer data from one worksheet to another, then moving over three columns.
    By KLG519 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-15-2018, 08:13 AM
  2. [SOLVED] Moving multiple columns (8 x sets of 3) with data in separate rows into 3 columns
    By Emmax in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-03-2016, 01:23 PM
  3. Moving blocks of columns to a combined list of columns
    By kbodway in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-15-2013, 01:17 PM
  4. Moving column data from one worksheet to rows in another worksheet.
    By taichi56 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-12-2013, 09:00 PM
  5. Help with moving columns from multiple worksheets into one worksheet side by side
    By gary619 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-16-2012, 04:54 PM
  6. [SOLVED] Selecting specific data on a worksheet and moving it to a table on another worksheet
    By wesman200098 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-08-2012, 05:45 AM
  7. Moving data from worksheet to columns
    By nobleprince in forum Excel General
    Replies: 4
    Last Post: 02-03-2012, 07: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