Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 2000.. changing single cell width not column

Status
Not open for further replies.
nlm9802

nlm9802

IS-IT--Management
Oct 10, 2000
409
0
0
US
How would I go about changing just certain cells to have different widths in the same column? changing the column width affects all cells in the column.

say I wanted cell a1 with width of 20 and cell b1 width of 10, b2 width of 10.

I thought it would just let me click and drag at the side of the cells, but no luck. I know you can do almost anything in office, its just a matter of finding out how.
 
Sort by date Sort by votes
Well you can't do that I'm afraid - the nearest you can get would be to merge A1 & B1 with both columns having a width of 10

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes
Get the best answers to your questions - faq222-2244
 
Upvote 0 Downvote
If you just want more room for data in the cell, you can also use word wrap within the individual cells: (Format>Cells Click Alignment tab, Check box for Wrap Text). This will increase the cell size vertically as needed for the entered data, and the width can remain the same within the column.
 
Upvote 0 Downvote
nlm,

You can make forms on worksheets with a great deal of precision by using the merge cells technique as xlbo has suggested.

You can increase the precision by selecting all cells and making the columns' width much smaller than the default column width and then merging as many cells as desired (both in the horizontal as well as the vertical directions)

Just another suggestion :)

Skip,
Skip@TheOfficeExperts.com
 
Upvote 0 Downvote
Personal opinion only, but shared by pretty much all the regulars in the MS newsgroups, there is nothing more evil and troublesome in Excel than a merged cell. They are the spawn of the devil!!!

In case you hadn't guessed, I'm not a fan of merged cells. Right royal pain when referencing, copying to or from when inside a group of cells etc.

Regards
Ken.............
 
Upvote 0 Downvote
I second that Ken but sometimes there ain't no other way ;-)


Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes
Get the best answers to your questions - faq222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Question
Office 2000 XL
Replies
6
Views
342
dhookom
dhookom
ladyck3
  • Locked
  • Question
Excel 365 - Auto-Populating a cell from date in the next cell. 2
Replies
9
Views
112
ladyck3
ladyck3
Bijugate
  • Question
Excel update question
Replies
0
Views
101
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
130
combo
combo
arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
151
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top