"twb111" wrote:
Large spreadsheet with data in columns A-L. Reference codes in columns M1
through P1. How can I keep or float the reference codes so they are always
in view on the right side of the spreadsheet?
Another option if reference info is static,
is to use the input msg feature of data validation
Eg select entire cols A-L,
then click Data Validation Input Message tab
Copy/paste/enter the details in M1:P1
for the title/msg such as:
Title, eg: References
Input Message, eg:
M1: xxx
N1: zzz
O1: vvv
P1: bbb
Click OK
The "floater reference info" will appear
when any cell in cols A-L is selected
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---