Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Liz Liz is offline
external usenet poster
 
Posts: 133
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,069
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.programming
Liz Liz is offline
external usenet poster
 
Posts: 133
Default 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


  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,069
Default 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




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
Protect woksheet and keep using outline capabilities Jean-Luc Excel Discussion (Misc queries) 1 September 28th 09 01:27 PM
lookup a cell on another woksheet by using the tab name noseyg Excel Programming 2 November 22nd 06 07:52 AM
How do I Increment a particular woksheet number? [email protected] Excel Worksheet Functions 2 March 6th 06 02:36 AM
Sound / Audible Alert in a Woksheet ? carl Excel Worksheet Functions 3 July 7th 05 09:17 PM
on exel how do I can take out the ceros on the woksheet? ana ibarra Excel Worksheet Functions 1 May 25th 05 09:47 AM


All times are GMT +1. The time now is 02:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"