If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Portion of sheet with different column widths
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 |
#3
|
|||
|
|||
Portion of sheet with different column widths
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 |
Thread Tools | |
Display Modes | |
|
|