Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Resizing cells within the same spread sheet

Hi to all! I'm trying to teach myself how to use excel with a manual and
just plain experimenting with trying to create simple spread sheets for now.
Now this may appear a bit naive but I would like to know if it is possible to
change for example the heighth of a column of cells without changing the size
of the cells immediately to the right or left of the cell. I know that you
can choose the option to unlock a particular range of cells while protecting
the rest of the cells within the sheet but that option appears to only allow
you to change the content of the cell. I've tried all sorts of different
things with no success. Is it impossible? Thanks for any help.

Manny
--
A fledgling at 64
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 342
Default Resizing cells within the same spread sheet

I think it is only possible to change the heighth of of row, not the heighth
of individual cells within the row.


"Manny" wrote:

Hi to all! I'm trying to teach myself how to use excel with a manual and
just plain experimenting with trying to create simple spread sheets for now.
Now this may appear a bit naive but I would like to know if it is possible to
change for example the heighth of a column of cells without changing the size
of the cells immediately to the right or left of the cell. I know that you
can choose the option to unlock a particular range of cells while protecting
the rest of the cells within the sheet but that option appears to only allow
you to change the content of the cell. I've tried all sorts of different
things with no success. Is it impossible? Thanks for any help.

Manny
--
A fledgling at 64

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Resizing cells within the same spread sheet

You can merge cells to make it look like this, but merged cells cause lots of
other problems--sorting, copy|pasting, ...

I wouldn't use them.

But if you want to try:
In xl2003 menus:
select the two cells
Format|Cells|alignment tab|check merge



Manny wrote:

Hi to all! I'm trying to teach myself how to use excel with a manual and
just plain experimenting with trying to create simple spread sheets for now.
Now this may appear a bit naive but I would like to know if it is possible to
change for example the heighth of a column of cells without changing the size
of the cells immediately to the right or left of the cell. I know that you
can choose the option to unlock a particular range of cells while protecting
the rest of the cells within the sheet but that option appears to only allow
you to change the content of the cell. I've tried all sorts of different
things with no success. Is it impossible? Thanks for any help.

Manny
--
A fledgling at 64


--

Dave Peterson
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
How do I customize the resizing of my spread sheet to 8 1/2 by 17 First Light Excel Discussion (Misc queries) 1 January 3rd 10 06:48 AM
why cant I merge cells in a reguler spread sheet Lyle Excel Discussion (Misc queries) 2 November 5th 09 08:02 AM
Expanding a spread sheet to new cells. jrsrdcr Excel Discussion (Misc queries) 1 May 3rd 09 05:15 AM
Resizing cells in a selection without resizing entire sheet Danielle via OfficeKB.com Excel Discussion (Misc queries) 4 August 11th 06 10:06 PM
Counting Unique Cells When Spread Sheet is Filtered carl Excel Worksheet Functions 1 June 3rd 05 07:20 PM


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