1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Table doesn't alternate colors for a certain number of lines, any ideas why?

https://preview.redd.it/bxt1f17pm1jg1.png?width=525&format=png&auto=webp&s=16d870c6d5b80ce08b0750e07a5482c07c968eba

a picture to show what I mean.

I made a table, and it worked great, I initially expanded it to reach something like 350 lines. Now I was getting closer to reaching the end of it, so I expanded it again. But this happened.

So I went back, shrunk the table to the last line I filled in (about 220) and tried again, thinking it was an issue with the already existing cells. But I expand it to the 1000th line and I still get the same non alternating lines. This span is the only place where this happens.

As a test I tried to create another table next to it, and it doesn't have the same issue

https://preview.redd.it/ndeo57bbn1jg1.png?width=558&format=png&auto=webp&s=90d21f3b51fdbc0c074786a6db8f2a1cf1023652

Any idea on why this could be happening? I almost never use excel and I mainly go off of intuition most of the time, I looked online and I can't find this issue anywhere else.

I'd add the link but the document has some personal information I'd rather not share.

Thank you so much for any advice

submitted by /u/Outrageous_Froyo_775
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#real-time data collaboration
#financial modeling with spreadsheets
#table
#Excel
#alternating colors
#issue
#lines
#expanded
#shrunk
#cells
#document
#picture
#another table
#expanding
#test