Customizing Excel's 'Format Cells' defaults - how?
 

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!

Customizing Excel's 'Format Cells' defaults - how?
 

You could copy|paste special|formats (if you wanted to copy all the format for
that cell).

You could create a macro that sets a particular format the way you like. Just
record a macro when you do it manually and your code could be perfect. Assign
it a nice shortcut keystroke for easy access.

Maybe you could adjust the Normal style
Format|style|Normal|Modify

All the cells with that normal style will be affected by this change.

But styles live in workbooks--you'd have to do that same modification for each
workbook.


BobW wrote:

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!

--

Dave Peterson

Customizing Excel's 'Format Cells' defaults - how?
 

Dave, thanks; I like the Format Normal Style approach. It does the trick!

"Dave Peterson" wrote:

You could copy|paste special|formats (if you wanted to copy all the format for
that cell).

You could create a macro that sets a particular format the way you like. Just
record a macro when you do it manually and your code could be perfect. Assign
it a nice shortcut keystroke for easy access.

Maybe you could adjust the Normal style
Format|style|Normal|Modify

All the cells with that normal style will be affected by this change.

But styles live in workbooks--you'd have to do that same modification for each
workbook.


BobW wrote:

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!

--

Dave Peterson