Forum Discussion

Copper Contributor

Feb 12, 2023

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

Subodh_Tiwari_sktneer
Feb 14, 2023
Paula_Mayes
Okay. Please follow the two steps described in the following screenshot...

Silver Contributor

Feb 12, 2023

You can use Inquire:
https://support.microsoft.com/en-us/office/clean-excess-cell-formatting-on-a-worksheet-e744c248-6925-4e77-9d49-4874f7474738#:~:text=To%20remove%20the%20excess%20formatting%20in%20the%20current,changes%20to%20the%20sheets%20or%20No%20to%20cancel.

Paula_Mayes
Copper Contributor
Feb 13, 2023
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
- Patrick2788
  Silver Contributor
  Feb 13, 2023
  Paula_Mayes
  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.
  - Paula_Mayes
    Copper Contributor
    Feb 13, 2023
    I'm sure I probably do have a personal version of Excel, as it came pre-loaded on my HP personal laptop. Thanks again for trying though. Sadly his solution isn't working for me either.

Resources