Forum Discussion

lpkelloway's avatar
lpkelloway
Copper Contributor
Aug 25, 2022

how do I delete dash columns

How do you delete the dash columns. I looked it up and have tried doing it but I'm having problems. 

Can some help me with easy steps to do it.

 

Thanks

3 Replies

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    You may have to be more specific. It's not clear what you mean by 'dash columns'. Are you looking to split a column on delimiter?
    • lpkelloway's avatar
      lpkelloway
      Copper Contributor
      When you have the spreadsheet and your columns those are solid lines but I have a line going down like this - - - - - - so I have other columns with my numbers and when I print it prints where the - - - - and the other columns are not there. So how do I delete that - - - - - so all my columns will be on the page when I print it
      I hope you understand what im saying
      Thanks
      • HansVogelaar's avatar
        HansVogelaar
        MVP

        lpkelloway 

        The dotted lines are automatic page breaks. You can hide them, but not remove them.

        You can force Excel to print everything on one page by activating the Page Layout tab of the ribbon. In the Scale to Fit group, set Width and Height to 1 Page:

Resources