Forum Discussion

ANGHamilton777's avatar
ANGHamilton777
Copper Contributor
Oct 11, 2023

How to copy and paste in excel without hidden rows but maintain formatting

I have a large file with filters.  Am trying to copy & paste without hidden rows which I've turned on Go To Special and clicked "VISIBLE CELLS ONLY", but when it comes to pasting, it's not keeping th...
excel
peiyezhu's avatar
peiyezhu
Bronze Contributor
Oct 12, 2023
want to maintain the formatting, with row spaces.?
What do you mean with row spaces or formatting?
what is your expected result?
  • ANGHamilton777's avatar
    ANGHamilton777
    Copper Contributor
    Oct 17, 2023
    Thanks for your response. I have multiple rows of Batteries (for example), so if I copy and paste with the Go To, it omits the rows where the Chargers are and places them directly under each other. I can sort column A, but was wondering if there's a formula or step I'm missing to avoid this.
    • peiyezhu's avatar
      peiyezhu
      Bronze Contributor
      Oct 17, 2023

      ANGHamilton777 

      so if I copy and paste with the Go To
      what do you mean the Go To?

      Can you share your workbook and show your expected result?

Resources