Jan 09 2020 07:50 AM
I am having problems selecting just two columns (AI&AU) so i can unhide the columns between them. It worked perfectly 2 days ago but when i came in yesterday i started having this issue. Once i select the two columns it automatically selects all columns from (A to AU). I have tried multiple ways "click and drag, click then shift+click, click then ctrl+click) and it always selects all the columns again. I can go to any other computer in my office and open the same files and it works perfectly, only (AI&AU) get selected and I can unhide the columns. I was thinking it was a glitch in Excel so I uninstalled and reinstalled office 365 but the problem remained. Any help would be great. I am posting 2 pictures to show what I mean. First is my laptop selection, the second is from another laptop in my office.
Jan 09 2020 08:49 AM
On these two laptops do you have exactly the same version/build# of the Office or they are different?
Jan 09 2020 09:38 AM
@Abiola1 Attached is one sample file.
Jan 09 2020 09:43 AM
They use to be the same version/build number. But when i uninstalled and reinstalled to try to fix the problem it installed a newer version. @Sergei Baklan
Jan 09 2020 09:52 AM
Why I asked that was a bug with related issue in some builds. Do you have the same on updated version?
Jan 09 2020 09:56 AM
Yes, updated version has the same issue. It seems to be related to the a couple rows are merged across the column's. If i was to unmerge the rows then I can select columns just fine. But why can I do it on every other computer in my office just fine without having to unmerge the rows? @Sergei Baklan
Jan 09 2020 10:15 AM
Have no idea - same build, same file, it shall be the same behavior.
In general it's better to avoid merged cells at all. Could you lease check on attached file, I removed merged cells and change formatting on Center Across Selection instead.