Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,069
Default How to make cell width different than the column width it lies in

Is there any way to change the width of a cell, or a few cells, while keeping
all the other cells in the column the same width?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 65
Default How to make cell width different than the column width it lies in

You can only change row heights and column widths. Not individual cells.
However, you can merge cells to make them appear the way you want. Try
highlighting a couple of cells that you want to merge, and then right click
them. Select Format Cells. On the Alignment tab, check the box for Merge
cells.


"JOHN" wrote in message
...
Is there any way to change the width of a cell, or a few cells, while
keeping
all the other cells in the column the same width?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default How to make cell width different than the column width it lies in

Hi,

I'm pretty sure that is not possible.
What do you intend to do with the "shortened" cells. is it for printing?
formatting?
an alternative would be to Merge two adjacent cells to form the "longer"
cells and leave the other cells as single cells. You could then change the
widths as needed.

John.

--
John


"JOHN" wrote:

Is there any way to change the width of a cell, or a few cells, while keeping
all the other cells in the column the same width?

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
macro unouwanme Excel Discussion (Misc queries) 9 August 31st 06 09:38 PM
run a macro in a locked cell Ray Excel Discussion (Misc queries) 8 January 10th 06 12:02 AM
creating a bar graph Johnfli Excel Discussion (Misc queries) 0 October 26th 05 08:16 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
What is the column width associated with cell borders? Bob Tarburton Excel Discussion (Misc queries) 3 April 1st 05 10:48 PM


All times are GMT +1. The time now is 05:30 AM.

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"