Portion of sheet with different column widths

  • Thread starter Thread starter Laurence Lombard
  • Start date Start date
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
 
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
 
Thanks Debra - once again the newsgroup provides the answer!
Laurence
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula too long 2
Copy reference cell with alternate column 4
Max Length in a row 1
Help to create a macro 2
Creating A List of Items Between Two Numbers 2
Combine Worsheets (Excel 03) 2
Conditional Concatenate? 2
Splitting Numbers into Columns. 3

Back
Top