ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Text staying put (https://www.excelbanter.com/excel-discussion-misc-queries/151250-text-staying-put.html)

Bikertyke

Text staying put
 
Having created a data table in Excel, a key is required for colour coded
cells. Is it possible the keep the key in a set position whilst the
spreadsheet is is scrolled up and down. I would prefer not to split the
screen if possible.

Stephane Quenson

Text staying put
 
You could open a 2nd window of the same spreadsheet and arrange them on the
screen so both are visible all the same time. I am not aware of any
possibility to have an "always on top" excel window.

Stephane.

Dave Peterson

Text staying put
 
You could put your key in the top few rows, then use window|Freeze so that those
rows are always visible.

Bikertyke wrote:

Having created a data table in Excel, a key is required for colour coded
cells. Is it possible the keep the key in a set position whilst the
spreadsheet is is scrolled up and down. I would prefer not to split the
screen if possible.


--

Dave Peterson


All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com