| 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) | |||
Linear Mode
