G
Guest
Is there a way to set Excel's Cell Formatting defaults to Text Alignment-
Vertical='top' and Text Control='Wrap Text'?
I created 30 folders/subfolders and put a lot of spreadsheets in them.
Later, when I started adding data, I realized that I needed all cells in all
spreadsheets to have Cell Formats set to Text Alignment- Vertical='top' and
Text Control='Wrap Text'.
I've tried opening them one by one, highlighting all cells, and making those
changes, but the changes only take effect in the few cells where some text
already exists. The vast majority of (still empty) cells refuse to accept
those changes.
So I am forever having to go into Format Cells and tediously reaccomplish
these same settings over and over again....help!
Vertical='top' and Text Control='Wrap Text'?
I created 30 folders/subfolders and put a lot of spreadsheets in them.
Later, when I started adding data, I realized that I needed all cells in all
spreadsheets to have Cell Formats set to Text Alignment- Vertical='top' and
Text Control='Wrap Text'.
I've tried opening them one by one, highlighting all cells, and making those
changes, but the changes only take effect in the few cells where some text
already exists. The vast majority of (still empty) cells refuse to accept
those changes.
So I am forever having to go into Format Cells and tediously reaccomplish
these same settings over and over again....help!