Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How can I adjust column width of a single cell within Excel 2003?

I would like to be able to adjust column width of one cell only without
affecting width of remaining cells within the same column. This is for
Excel 2003. Please advise.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default How can I adjust column width of a single cell within Excel 2003?

Sorry, cannot do that the way you've requested.
Some Options are

1) to leave cells to the right empty and turn off word-wrap in that cell,
any text will extend out over adjacent colums in that row.
2) select several cells along with that one in the same row and use
Format | Cells | [Alignment] and in the Horizontal, choose "Center Across
Selection"
3) select that cell and more on the same row and MERGE them into one cell.
Initially the entry in that will be centered, but you can then align it to
the left or right using standard format options.

Hope this helps some with the problem.

"biotekengineer" wrote:

I would like to be able to adjust column width of one cell only without
affecting width of remaining cells within the same column. This is for
Excel 2003. Please advise.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default How can I adjust column width of a single cell within Excel 2003?

Hi,
you can not adjust the width of a single cell, but you can overcome this
problem by merging the adjacent cells, which needs more space. the same
thing you can find in XL templates.
--
nmuthu


"biotekengineer" wrote:

I would like to be able to adjust column width of one cell only without
affecting width of remaining cells within the same column. This is for
Excel 2003. Please advise.

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
Running Excel 2000 VBA Application on Excel 2003 Excel Worksheet Functions 0 August 8th 06 06:04 PM
Using Excel 2000 VBA Application on Excel 2003 Excel Worksheet Functions 0 August 8th 06 02:36 AM
Conditional Format as a MACRO Gunjani Excel Worksheet Functions 3 March 29th 06 05:22 PM
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 06:16 PM
How do i change the height and width of a single cell in Excel? lotus1107 Charts and Charting in Excel 1 August 8th 05 02:36 AM


All times are GMT +1. The time now is 04:52 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"