#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 71
Default Excel Formating

Is it possible to create a writable Excel table within another Excel
spreadsheet that has different column widths that the rest of the spreadsheet.

The upper table has different column width requirements that the lower data
elements.
--
Liz
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default Excel Formating

One way you can achieve this is to use two columns for the table which
requires wider columns, and to merge adjacent cells, but this is not
recommended as merged cells cause all sorts of problems.

Can you not have your second table positioned to the right of the
first table so it uses different columns?

Alternatively, if this is for a printed document, you could think
about using Word, and linking the tables seperately to the Word
document.

Hope this helps.

Pete

On Aug 19, 2:21*pm, Elizabeth
wrote:
Is it possible to create a writable Excel table within another Excel
spreadsheet that has different column widths that the rest of the spreadsheet.

The upper table has different column width requirements that the lower data
elements.
--
Liz


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Excel Formating

You could merge cells together to give it that look, but merged cells will cause
heartache later on.

If I were you, I'd put different tables on different sheets. It'll make
updating lots easier.

Elizabeth wrote:

Is it possible to create a writable Excel table within another Excel
spreadsheet that has different column widths that the rest of the spreadsheet.

The upper table has different column width requirements that the lower data
elements.
--
Liz


--

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
excel formating amber Excel Worksheet Functions 2 July 15th 08 09:10 PM
Formating number in Excel Michelle Excel Discussion (Misc queries) 2 August 31st 07 05:31 PM
Install dates formating using conditional formating? Jerry Eggleston Excel Discussion (Misc queries) 2 November 9th 05 05:49 PM
Conditional Formating in Excel mzafar Excel Discussion (Misc queries) 1 June 24th 05 04:56 PM
Formating Excel functions MLRB Excel Worksheet Functions 3 November 18th 04 07:07 PM


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