Forum Discussion
Solved
Help please
How can I quickly delete the excess columns in an existing Excel spreadsheet? I only need columns A thru M but did somthing stupid somewhere by accident and now have columns out to XFD that have formating in them.
- Hi Patrick- Thanks for trying to help me but I have no idea how to find "Inquire" on my Excel. I'm 71 yrs old and obviously not savvy enough to even follow the support link you sent. In fact, I can't even find what version of Excel came on this 2 yr old laptop! I was really good with Excel before I retired 5 yrs ago, and created some killer complicated spredsheets but now I can't seem to remember anything to make them work. Getting old sucks but sure beats the alternative! LOL
Hi Paula, it sounds like you might be using a personal version of Microsoft 365 in which case Inquire is not available (It's only available with a business license).
I recommend going with Subodh_Tiwari_sktneer 's solution.
To do that, select the whole column N by clicking on the column letter N and then press the shortcut key Ctrl+Shift+Right arrow key, this will select column N through XFD. Now right click and choose Delete.
- I"m missing a step or something. I've tried this several times but it will only let me select that column N. When I Ctrl+Shift+Right arrow key my spreadsheet lets me see me all the columns thru XFD but they are not selected. I can only select one column at a time.?
