Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set default settings for downloaded reports?
I use a lot of reporting systems and usually export them to excel in order to
give to other users. I am trying to set the default for these reports rather than changing everything everytime I export. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set default settings for downloaded reports?
Not sure if this is what you're looking for, but I download reports from our
system often, & came up with a solution to format them. I created a spreadsheet where sheet1 is where I paste/export all of the raw data, & then use sheet2 to format the data. As an example, the formula for column a in sheet 2 would be "=Sheet1!A:A". You can then save the spreadsheet, paste/export into sheet1, & let sheet2 do the formatting. "Tonia J." wrote: I use a lot of reporting systems and usually export them to excel in order to give to other users. I am trying to set the default for these reports rather than changing everything everytime I export. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to restore all default settings | Excel Worksheet Functions | |||
Changing default chart settings like background colour etc | Setting up and Configuration of Excel | |||
New window in Excel does not display default settings | Excel Discussion (Misc queries) | |||
Default settings not applied to new documents | Setting up and Configuration of Excel | |||
reset default field settings in pivotable reports | Excel Discussion (Misc queries) |