Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Custom View
I have created a series of reports from a common table using custom
views. I want the title of the report to change based upon the view selected. Is there any way to have a cell display the view that is currently being applied. I know that i can change the header / footer, however i would prefer to place the title in a cell within the spreadsheet Thanks for your help Vitorjose |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Custom View
You could have each view's heading in a different row. Then, hide all
the other heading rows when you create each view. vitorjose wrote: I have created a series of reports from a common table using custom views. I want the title of the report to change based upon the view selected. Is there any way to have a cell display the view that is currently being applied. I know that i can change the header / footer, however i would prefer to place the title in a cell within the spreadsheet -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Custom View
Thanks for the info
Debra Dalgleish wrote: You could have each view's heading in a different row. Then, hide all the other heading rows when you create each view. vitorjose wrote: I have created a series of reports from a common table using custom views. I want the title of the report to change based upon the view selected. Is there any way to have a cell display the view that is currently being applied. I know that i can change the header / footer, however i would prefer to place the title in a cell within the spreadsheet -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format divide by 10 / single digit view: Custom? Text(Round( | Excel Discussion (Misc queries) | |||
How to view a custom view when the worksheet is protected? | Excel Worksheet Functions | |||
Default Custom View | Excel Discussion (Misc queries) | |||
excel should have a floating "custom view" toolbar | Excel Worksheet Functions | |||
Custom Views in Shared workbook | Excel Discussion (Misc queries) |