ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Woksheet spliting (https://www.excelbanter.com/excel-programming/410530-woksheet-spliting.html)

Liz

Woksheet spliting
 
I am trying to see if there is a way to split a worksheet. The data I have
to input needs to have columns at different widths.

example:
A1.
a b c d e f



A2

A b c d e f

Any help you can give me I would appreciate

Tom Hutchins

Woksheet spliting
 
Sorry, each column has a single width for all its cells. You could merge
cells to simulate wider columns, but merged cells can cause problems with
sorting and some editing operations.

Hope this helps,

Hutch

"Liz" wrote:

I am trying to see if there is a way to split a worksheet. The data I have
to input needs to have columns at different widths.

example:
A1.
a b c d e f



A2

A b c d e f

Any help you can give me I would appreciate


Jacques ALARDET

Woksheet spliting
 
Hello Liz

If i inderstand your question, I propose une solution "bricolo"

Utilise the merge cellule. In your example :

A1.
a b c d e f

A2
a b c d e f

A2 A1
a a
b b+c+d
c e+f
d g
e h
f i

I hope it d'ont exists a third split (A3) !

J a c q u e s

"Liz" a écrit dans le message de
...
I am trying to see if there is a way to split a worksheet. The data I have
to input needs to have columns at different widths.

example:
A1.
a b c d e f



A2

A b c d e f

Any help you can give me I would appreciate



Liz

Woksheet spliting
 
Some one told me that you can add a new worksheet in with that worksheet is
this possible? That way it is all in one worksheet but with several
worksheets. Is this somehow possible

"Jacques ALARDET" wrote:

Hello Liz

If i inderstand your question, I propose une solution "bricolo"

Utilise the merge cellule. In your example :

A1.
a b c d e f

A2
a b c d e f

A2 A1
a a
b b+c+d
c e+f
d g
e h
f i

I hope it d'ont exists a third split (A3) !

J a c q u e s

"Liz" a écrit dans le message de
...
I am trying to see if there is a way to split a worksheet. The data I have
to input needs to have columns at different widths.

example:
A1.
a b c d e f



A2

A b c d e f

Any help you can give me I would appreciate



Tom Hutchins

Woksheet spliting
 
You can't insert/embed a worksheet into another worksheet in the same
workbook. You can embed a different workbook as an object in a worksheet.

Hutch

"Liz" wrote:

Some one told me that you can add a new worksheet in with that worksheet is
this possible? That way it is all in one worksheet but with several
worksheets. Is this somehow possible

"Jacques ALARDET" wrote:

Hello Liz

If i inderstand your question, I propose une solution "bricolo"

Utilise the merge cellule. In your example :

A1.
a b c d e f

A2
a b c d e f

A2 A1
a a
b b+c+d
c e+f
d g
e h
f i

I hope it d'ont exists a third split (A3) !

J a c q u e s

"Liz" a écrit dans le message de
...
I am trying to see if there is a way to split a worksheet. The data I have
to input needs to have columns at different widths.

example:
A1.
a b c d e f



A2

A b c d e f

Any help you can give me I would appreciate




All times are GMT +1. The time now is 03:21 PM.

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