Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Setting column width to specific row in Excel doc ??? Thanks!

I am working on an Excel document (using Windows 2007) and want to widen one
column (to fit the text) for just one row (i.e. I do not want to alter the
column width of all the rows above). Can this be done, and how?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Setting column width to specific row in Excel doc ??? Thanks!

No.

You could use "Centre across selection" under Text alignment in the
Alignment tab (FormatCells) to format column labels across 2 or more cols
w/o merging the cells (this avoids having to merge cells - a good practice)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Setting column width to specific row" wrote:
I am working on an Excel document (using Windows 2007) and want to widen one
column (to fit the text) for just one row (i.e. I do not want to alter the
column width of all the rows above). Can this be done, and how?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 266
Default Setting column width to specific row in Excel doc ??? Thanks!

You could format the text as "shrink to fit"

"Setting column width to specific row" wrote:

I am working on an Excel document (using Windows 2007) and want to widen one
column (to fit the text) for just one row (i.e. I do not want to alter the
column width of all the rows above). Can this be done, and how?

Reply
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
setting column width James Excel Discussion (Misc queries) 1 July 11th 08 12:02 AM
Setting column width in a table Box815 Excel Discussion (Misc queries) 4 October 11th 06 06:34 AM
Setting column width for blank columns gmr7 Excel Discussion (Misc queries) 0 January 17th 06 03:16 PM
Setting Column Width on Imported Data B.C.Lioness Excel Discussion (Misc queries) 0 May 16th 05 09:41 PM
Is there any specific setting for MS excel to download CSV in fin. MikeDb Excel Discussion (Misc queries) 1 December 7th 04 05:37 PM


All times are GMT +1. The time now is 12:57 PM.

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

About Us

"It's about Microsoft Excel"