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
|
|||
|
|||
how do I apply formatting from one worksheet to a whole workbook?
I have an Excel workbook that is composed of the results from Access queries.
IE. 1 query is 1 worksheet. So far I have 31 in the workbook and will likely have 50-75 before I'm finished. How can I populate the formatting from the 1st sheet (header naming convention, size, layout, etc.) to each one that is there now and as I add more? Each added sheet defaults back to the Excel 2000-2003 format. Thanks |
#2
|
|||
|
|||
how do I apply formatting from one worksheet to a whole workbook?
On Aug 27, 2:46 pm, amergerm35
wrote: I have an Excel workbook that is composed of the results from Access queries. IE. 1 query is 1 worksheet. So far I have 31 in the workbook and will likely have 50-75 before I'm finished. How can I populate the formatting from the 1st sheet (header naming convention, size, layout, etc.) to each one that is there now and as I add more? Each added sheet defaults back to the Excel 2000-2003 format. Thanks Setup a template so each sheet will already be preformatted. You can find instructions in Help under Templates. Would be an .xlt file. To fix existing files, Select All, copy, goto all the other sheets you want (Shift- or CTRL-click the tabs), goto cell A1, Paste Special:Formats. You can do the same thing with a normal Paste if you have to copy your actual column headers, assuming the data is always in the exact same place. You could also copy sheets (then delete the data) instead of using the New:Sheet command. I generally Drag-n-Drop to do this, while holding down CTRL. Unless the query process creates the sheet, then nevermind. |
#3
|
|||
|
|||
how do I apply formatting from one worksheet to a whole workbo
I don't know about that. When Access gives me the output from my query (which
all involve different data widths and colums, I then click on ToolsOffice LinksAnalyze with microsoft Excel. It opens a. Excel spreadsheet and I copy the worksheet to the existing workbook, moving it to the back. For every sheet I have to go in and change the formatting in about 5-6 areas. Does this help clarify? I'm kind of new to using the output from one to generate data in another application. Amergerm "Spiky" wrote: On Aug 27, 2:46 pm, amergerm35 wrote: I have an Excel workbook that is composed of the results from Access queries. IE. 1 query is 1 worksheet. So far I have 31 in the workbook and will likely have 50-75 before I'm finished. How can I populate the formatting from the 1st sheet (header naming convention, size, layout, etc.) to each one that is there now and as I add more? Each added sheet defaults back to the Excel 2000-2003 format. Thanks Setup a template so each sheet will already be preformatted. You can find instructions in Help under Templates. Would be an .xlt file. To fix existing files, Select All, copy, goto all the other sheets you want (Shift- or CTRL-click the tabs), goto cell A1, Paste Special:Formats. You can do the same thing with a normal Paste if you have to copy your actual column headers, assuming the data is always in the exact same place. You could also copy sheets (then delete the data) instead of using the New:Sheet command. I generally Drag-n-Drop to do this, while holding down CTRL. Unless the query process creates the sheet, then nevermind. |
#4
|
|||
|
|||
how do I apply formatting from one worksheet to a whole workbo
I would think creating a normal template should help this, because
that works for new files. Unless the query makes its own formatting, changing whatever Excel's normal format is, then there probably isn't much you can do ahead of time. Since you are copying the data in, you could try Paste Special and select plain Text from the dialog box. It isn't the same as the normal Excel Paste Special when copying from a different program, but it is there. |
#5
|
|||
|
|||
how do I apply formatting from one worksheet to a whole workbo
Copy one of your formatted sheets to a new book. File/Save As "Sheet.xlt"
(file type template). This automatically opens your template folder, but you need to locate your XLSTART folder and put this file in it. When you create a new sheet, it should pull from this template. "Spiky" wrote: On Aug 27, 2:46 pm, amergerm35 wrote: I have an Excel workbook that is composed of the results from Access queries. IE. 1 query is 1 worksheet. So far I have 31 in the workbook and will likely have 50-75 before I'm finished. How can I populate the formatting from the 1st sheet (header naming convention, size, layout, etc.) to each one that is there now and as I add more? Each added sheet defaults back to the Excel 2000-2003 format. Thanks Setup a template so each sheet will already be preformatted. You can find instructions in Help under Templates. Would be an .xlt file. To fix existing files, Select All, copy, goto all the other sheets you want (Shift- or CTRL-click the tabs), goto cell A1, Paste Special:Formats. You can do the same thing with a normal Paste if you have to copy your actual column headers, assuming the data is always in the exact same place. You could also copy sheets (then delete the data) instead of using the New:Sheet command. I generally Drag-n-Drop to do this, while holding down CTRL. Unless the query process creates the sheet, then nevermind. |
#6
|
|||
|
|||
how do I apply formatting from one worksheet to a whole workbo
I tried both of these and no success. I'm going to try writing some VB code
for Access and try to force it that way. Thanks, Bill "Valerie" wrote: Copy one of your formatted sheets to a new book. File/Save As "Sheet.xlt" (file type template). This automatically opens your template folder, but you need to locate your XLSTART folder and put this file in it. When you create a new sheet, it should pull from this template. "Spiky" wrote: On Aug 27, 2:46 pm, amergerm35 wrote: I have an Excel workbook that is composed of the results from Access queries. IE. 1 query is 1 worksheet. So far I have 31 in the workbook and will likely have 50-75 before I'm finished. How can I populate the formatting from the 1st sheet (header naming convention, size, layout, etc.) to each one that is there now and as I add more? Each added sheet defaults back to the Excel 2000-2003 format. Thanks Setup a template so each sheet will already be preformatted. You can find instructions in Help under Templates. Would be an .xlt file. To fix existing files, Select All, copy, goto all the other sheets you want (Shift- or CTRL-click the tabs), goto cell A1, Paste Special:Formats. You can do the same thing with a normal Paste if you have to copy your actual column headers, assuming the data is always in the exact same place. You could also copy sheets (then delete the data) instead of using the New:Sheet command. I generally Drag-n-Drop to do this, while holding down CTRL. Unless the query process creates the sheet, then nevermind. |
Thread Tools | |
Display Modes | |
|
|