Forum Discussion

Teoxengineer2301's avatar
Teoxengineer2301
Copper Contributor
Jun 03, 2020

Office 365 Excel Column Adding Problem

Hello there, I am an Office 365 user. Today, I wanted to add columns to the page of an Excel workbook I use regularly, but Excel did not allow me. I could add it up to the IV column, it doesn't seem...
excel
office 365
mathetes's avatar
mathetes
Gold Contributor
Jun 03, 2020

Teoxengineer2301 

 

this link describes the limits in Excel

https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3


I can’t help but wonder what impels you to create a spreadsheet with that many columns in the first place. 

needing that many rows in a table: no problem. 

but to need that many columns sounds like an unmanageable spreadsheet. How would you be able to make sense of it?

 

would you be willing to describe why you need more columns? 

Teoxengineer2301's avatar
Teoxengineer2301
Copper Contributor
Jun 03, 2020

My table is the type that allows daily data data to be analyzed and shows all days of a month and every month of the year. Therefore, my table is in an order that expands to the right. However, this is my first time encountering this situation. The version I use is .xls, but when I return to .xlsx, I noticed that my columns returned to normal order.mathetes 

  • mathetes's avatar
    mathetes
    Gold Contributor
    Jun 03, 2020

    Teoxengineer2301 

     

    That data could also be organized such that it expands the table downward by date, and still be used for whatever analytical purposes you have.

     

    But leave it as is, if it's working.....