Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Viewing hidden data
I have input values in 18 cells C8:T8 these cells return a value
through formulas to the cells Y8:AJ8 is there any way to view these values at the bottom of the screen in some sort of a window so tha t they can be seen as the values in C8:T8 are entered. And will scroll to the next row when values are entered in C9:T9 etc. Note the returned values in columns Y:AJ are off screen Thanks EPJ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Viewing hidden data
Hi Jambun,
Try using Excel's Camera tool: Menu | Tools | Customize | Customize Toolbars/Menus | Commands Categories: All commands Scroll down to find Camera Drag to a toolbar Then select cells C8:T8 and click on the Camera icon; the border around the selected cells transforms into a moving marquee and the mouse pointer turns into a cross. Now click on the worksheet to returns the Camera, which can now be moved to the bottom of the sheet, and which will display a dynamic view of the cells of interest. Alternatively: Copy the range C8:T8 | Hold the Shift key and select the Edit menu | Choose Paste Picture Link The resultant dynamic link may be moved to a position of choice. --- Regards. Norman wrote in message ... I have input values in 18 cells C8:T8 these cells return a value through formulas to the cells Y8:AJ8 is there any way to view these values at the bottom of the screen in some sort of a window so tha t they can be seen as the values in C8:T8 are entered. And will scroll to the next row when values are entered in C9:T9 etc. Note the returned values in columns Y:AJ are off screen Thanks EPJ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Viewing hidden data
Norman
Both ideas of yours work fine but I need the information in the"Camera View" to show the contents of the next row if i start entering values in row D,E.F etc.ie: as i scroll to Row D the information in the Camera Shot needs to scroll also. Thanks EPJ On Thu, 22 May 2008 08:17:42 +0100, "Norman Jones" wrote: Hi Jambun, Try using Excel's Camera tool: Menu | Tools | Customize | Customize Toolbars/Menus | Commands Categories: All commands Scroll down to find Camera Drag to a toolbar Then select cells C8:T8 and click on the Camera icon; the border around the selected cells transforms into a moving marquee and the mouse pointer turns into a cross. Now click on the worksheet to returns the Camera, which can now be moved to the bottom of the sheet, and which will display a dynamic view of the cells of interest. Alternatively: Copy the range C8:T8 | Hold the Shift key and select the Edit menu | Choose Paste Picture Link The resultant dynamic link may be moved to a position of choice. --- Regards. Norman wrote in message .. . I have input values in 18 cells C8:T8 these cells return a value through formulas to the cells Y8:AJ8 is there any way to view these values at the bottom of the screen in some sort of a window so tha t they can be seen as the values in C8:T8 are entered. And will scroll to the next row when values are entered in C9:T9 etc. Note the returned values in columns Y:AJ are off screen Thanks EPJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - viewing hidden rows | Excel Worksheet Functions | |||
Viewing hidden characters | Excel Discussion (Misc queries) | |||
How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) | |||
Hidden data - hidden chart | Charts and Charting in Excel | |||
Saving hidden data with a worksheet (preferably without using a hidden sheet) | Excel Programming |