LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
BobW
 
Posts: n/a
Default 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!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
converting general cells format to text junkgrrl Excel Discussion (Misc queries) 1 January 12th 06 05:50 PM
format cells having text steve Excel Discussion (Misc queries) 2 July 15th 05 01:24 AM
format cells dialog box does not come up GMed Excel Discussion (Misc queries) 1 April 14th 05 05:00 PM
format cells Alfred Excel Worksheet Functions 2 April 1st 05 03:43 PM
Protected cells -automatically format to a different color Fred Evans Excel Discussion (Misc queries) 9 December 3rd 04 12:59 PM


All times are GMT +1. The time now is 01:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"