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 |
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 |
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 |
All times are GMT +1. The time now is 03:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com