Portion of sheet with different column widths

I have a sheet containing two tables of data, but they require different
column spacing.

I could use a formula similar to the one below (assuming the data is in
A1:C1) to generate a line that appears to have different column spacings to
the worksheet. The information is for display purposes only.

=+A1&REPT(" ",10-LEN(A1))&B1&REPT(" ",10-LEN(B1))&C1

Is there a better way? In WORD one can insert separate tables on a page. Can
one do this in Excel?
Thanks
Laurence

You could store the second set of data on a separate sheet, and adjust
its columns as required.

Then, copy the data from the second sheet
Switch to the first sheet, and select the starting cell where you'd
like the copied data to appear.
Hold the Shift key, and choose EditPaste Picture Link


Laurence Lombard wrote:
I have a sheet containing two tables of data, but they require different
column spacing.

I could use a formula similar to the one below (assuming the data is in
A1:C1) to generate a line that appears to have different column spacings to
the worksheet. The information is for display purposes only.

=+A1&REPT(" ",10-LEN(A1))&B1&REPT(" ",10-LEN(B1))&C1

Is there a better way? In WORD one can insert separate tables on a page. Can
one do this in Excel?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks Debra - once again the newsgroup provides the answer!
Laurence
"Debra Dalgleish" wrote in message
...
You could store the second set of data on a separate sheet, and adjust
its columns as required.

Then, copy the data from the second sheet
Switch to the first sheet, and select the starting cell where you'd
like the copied data to appear.
Hold the Shift key, and choose EditPaste Picture Link


Laurence Lombard wrote:
I have a sheet containing two tables of data, but they require different
column spacing.

I could use a formula similar to the one below (assuming the data is in
A1:C1) to generate a line that appears to have different column spacings
to
the worksheet. The information is for display purposes only.

=+A1&REPT(" ",10-LEN(A1))&B1&REPT(" ",10-LEN(B1))&C1

Is there a better way? In WORD one can insert separate tables on a page.
Can
one do this in Excel?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html