Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
converting general cells format to text | Excel Discussion (Misc queries) | |||
format cells having text | Excel Discussion (Misc queries) | |||
format cells dialog box does not come up | Excel Discussion (Misc queries) | |||
format cells | Excel Worksheet Functions | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) |