I keep losing my Exel format 1

[anniesolomon]

I selected the entire worksheet and formatted it so that data in all cells will be at the top left and wrapped. But, as soon as I type something new, the format isn't working. The data goes to the bottom of the cell and does not wrap. It's making me crazy!

 

[SkipVought]

hi,

I selected the entire worksheet and formatted it so that data in all cells will be at the top left and wrapped.

By THAT do you mean that all 16,384 columns and 1,048,576 rows are formatted as such?

No, I think not. You probably formatted the cells containing data and then when you entered data outside that original range, there was no such format. Or possibly, you copied a cell containing text from some other workbook or sheet and PASTED it into your already formatted cell, and it lost its original format, which does happen with an indiscriminate paste.

I'd suggest using Structured Tables, which propagates your formats and formulas into new rows as you enter data.

 

[anniesolomon]

You are spot on! I was pasting stuff from a website into my "formatted" spreadsheet. Thanks for teaching me something new. I never heard about structured tables but I'm going to look into it.

 

[SkipVought]

As I stated, if you indiscriminately paste your format might be destroyed.

However you can paste discriminately if you right-click in the cell you want to paste into and select the Paste Option that is appropriate, like VALUES in your particular instance.