Portion of sheet with different column widths

L

Laurence Lombard

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
 
D

Debra Dalgleish

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 Edit>Paste Picture Link
 
Top