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, especially line thickness around a cell and also sometimes the cell’s 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 must add that this particular worksheet has been copied from older worksheets of past years and past versions of Excel. In my case this is a worksheet with 5 sheets and it is doing this quirk only on the first sheet page. The first sheet is the largest one with 18 columns being used and about 1600 rows, between 750 MB up to 1.1 Gigabytes. (Depending on the spreadsheet’s year in which it was created)
I have been using Excel's forerunner since 1984 in the early PCs by IBM, and then using excel in each one of the iterations that Microsoft brought out to the market from then on, 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
PS. I shall include a small .xlsx sample where this is happening.
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, especially line thickness around a cell and also sometimes the cell’s 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 must add that this particular worksheet has been copied from older worksheets of past years and past versions of Excel. In my case this is a worksheet with 5 sheets and it is doing this quirk only on the first sheet page. The first sheet is the largest one with 18 columns being used and about 1600 rows, between 750 MB up to 1.1 Gigabytes. (Depending on the spreadsheet’s year in which it was created)
I have been using Excel's forerunner since 1984 in the early PCs by IBM, and then using excel in each one of the iterations that Microsoft brought out to the market from then on, 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
PS. I shall include a small .xlsx sample where this is happening.
