ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Formating (https://www.excelbanter.com/excel-discussion-misc-queries/199338-excel-formating.html)

Elizabeth

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

Pete_UK

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



Dave Peterson

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


All times are GMT +1. The time now is 02:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com