Forum Discussion

chipg900's avatar
chipg900
Copper Contributor
Feb 16, 2020

Deleting unwanted rows and columns

Could someone please tell me the simplest way to delete the unwanted rows and columns at the end of spreadsheets and just to save the the ones I need? Thank you.

  • PReagan's avatar
    PReagan
    Bronze Contributor

    Hello chipg900,

     

    There are several ways to remove unwanted rows and columns in excel. The method that you choose may depend on what rows and columns you wish to remove. Here are a few ways to remove rows and columns in excel:

     

    1. Right-click a row number or column letter in the rows/columns bar. Select delete.
    2. Select a row/column that you would like to remove. Go to the Home tab, under "Cells" select "Delete".
    3. Select a row/column that you would like to remove. Press Ctrl+"-".
  • JBF_54's avatar
    JBF_54
    Brass Contributor
    I've a similar question, only it doesn't involve deleting data (rows or columns), but deleting whatever I need to to reset the the location of 'Cntrl-End'. I'd like to go to the end of my working area, not the last cell touched that is farthest away from A1.
  • JBF_54's avatar
    JBF_54
    Brass Contributor
    Update: I repeated the procedure, this time adding the steps of deleting the unused rows and columns, then exiting. This shrunk the file down to its original size, but still hasn't moved the Cntrl-End location.
    • PReagan's avatar
      PReagan
      Bronze Contributor

      JBF_54 

       

      Can you please share a sample file so that I can facilitate testing?

      • JBF_54's avatar
        JBF_54
        Brass Contributor
        Is there a way to send you the file without it being posted for the whole world to see?
    • JBF_54's avatar
      JBF_54
      Brass Contributor
      Thanks ... I followed the instructions in the article, but there is no "Inquire" options under COM Add-Ins.

Resources