| T O P I C R E V I E W |
| tib |
Posted - 10/24/2003 : 11:54:16 AM
In a worksheet which I basically use as a input device for further calculations I want to add comments (explanations, etc.) on top of the data (or after the last row). Since the datasheet spans the whole screen it's not good to put it to the side (to the right of the last column).
When I scroll down the worksheet the text object disapears. It appears only if I press manually the refresh button.
How can I keep text objects in a worksheet always on top of the data?
Thanks for any hints, Tilman.
|
| 2 L A T E S T R E P L I E S (Newest First) |
| tib |
Posted - 10/24/2003 : 8:59:51 PM
Thanks rlewis,
on top of the column header that's even better than covering some of the cell values. That's exactly what I was looking for. Thank you!
|
| rlewis |
Posted - 10/24/2003 : 3:36:32 PM
If you double click on an empty region of the worksheet window , the worksheet display control dialog box will be activated. One can then increase the "Gap From Top" property (I tend to use values like 120). This will shift the worksheet down in the window and one can then use the space above worksheet for text labels, messages etc ...
The worksheet display control window can also be activated by right-clicking in an empty part of the worksheet window and selecting properties ... |
