Office 365 Excel Column Adding Problem

%3CLINGO-SUB%20id%3D%22lingo-sub-1435612%22%20slang%3D%22en-US%22%3EOffice%20365%20Excel%20Column%20Adding%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1435612%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20there%2C%3C%2FP%3E%3CP%3EI%20am%20an%20Office%20365%20user.%20Today%2C%20I%20wanted%20to%20add%20columns%20to%20the%20page%20of%20an%20Excel%20workbook%20I%20use%20regularly%2C%20but%20Excel%20did%20not%20allow%20me.%20I%20could%20add%20it%20up%20to%20the%20IV%20column%2C%20it%20doesn't%20seem%20to%20be%20after.%3C%2FP%3E%3CP%3EWhat%20is%20the%20reason%20I%20couldn't%20add%20additional%20columns%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEmre%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1435612%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1435803%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Excel%20Column%20Adding%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1435803%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F687503%22%20target%3D%22_blank%22%3E%40Mslm1645%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20link%20describes%20the%20limits%20in%20Excel%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fexcel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fexcel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20can%E2%80%99t%20help%20but%20wonder%20what%20impels%20you%20to%20create%20a%20spreadsheet%20with%20that%20many%20columns%20in%20the%20first%20place.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3Eneeding%20that%20many%20rows%20in%20a%20table%3A%20no%20problem.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3Ebut%20to%20need%20that%20many%20columns%20sounds%20like%20an%20unmanageable%20spreadsheet.%20How%20would%20you%20be%20able%20to%20make%20sense%20of%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewould%20you%20be%20willing%20to%20describe%20why%20you%20need%20more%20columns%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1436349%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Excel%20Column%20Adding%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1436349%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20table%20is%20the%20type%20that%20allows%20daily%20data%20data%20to%20be%20analyzed%20and%20shows%20all%20days%20of%20a%20month%20and%20every%20month%20of%20the%20year.%20Therefore%2C%20my%20table%20is%20in%20an%20order%20that%20expands%20to%20the%20right.%20However%2C%20this%20is%20my%20first%20time%20encountering%20this%20situation.%20The%20version%20I%20use%20is%20.xls%2C%20but%20when%20I%20return%20to%20.xlsx%2C%20I%20noticed%20that%20my%20columns%20returned%20to%20normal%20order.%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1436524%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Excel%20Column%20Adding%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1436524%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F687503%22%20target%3D%22_blank%22%3E%40Mslm1645%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20data%20could%20also%20be%20organized%20such%20that%20it%20expands%20the%20table%20downward%20by%20date%2C%20and%20still%20be%20used%20for%20whatever%20analytical%20purposes%20you%20have.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20leave%20it%20as%20is%2C%20if%20it's%20working.....%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1438088%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Excel%20Column%20Adding%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1438088%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 to be after.

What is the reason I couldn't add additional columns?

 

Emre

4 Replies
Highlighted

@Mslm1645 

 

this link describes the limits in Excel

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


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? 

Highlighted

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 

Highlighted

@Mslm1645 

 

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.....

Highlighted

Thank you @mathetes