#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Rows and Columns

I need to create two rows, but only in certain columns. Other columns in the
same row need to only be one row. Is this possible?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 69
Default Rows and Columns

There are two ways to do this. One would be to do a Wrap Text (highlight the
cells where you want the two rows, Format, Cells, Alignment, and half-way
down check the box that says "Wrap Text".

If you want specific items on each of the two rows, try this. Merge
(Format, Cells, Alignment, and half-way down, check the box that says "Merge
Cells") two cells into one - these cells would be where you want one row. So
- your row would really be two rows - but part of the cells would be merged
into one row, and part would show two rows.

Hope this helps,



"blazefightinfem" wrote:

I need to create two rows, but only in certain columns. Other columns in the
same row need to only be one row. Is this possible?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Rows and Columns

Row height and column width are the properties of the entire row and column and
cannot be altered throughout.

What do you want to do now that you have these facts?

Post back......there may be other ways to get what you want.


Gord Dibben MS Excel MVP

On Thu, 11 Jan 2007 11:23:01 -0800, blazefightinfem
wrote:

I need to create two rows, but only in certain columns. Other columns in the
same row need to only be one row. Is this possible?


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
Cutting and pasting from rows into columns and visa versa. Pank New Users to Excel 2 November 8th 06 01:54 PM
Rows & Columns in Excel seadragon69 Excel Worksheet Functions 2 December 7th 05 05:54 PM
How to swap rows and columns? [email protected] Excel Discussion (Misc queries) 5 September 21st 05 08:07 AM
inserting columns within certain rows only crimsonkng Excel Discussion (Misc queries) 4 July 14th 05 05:13 PM
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns foofoo Excel Discussion (Misc queries) 1 April 2nd 05 12:02 AM


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