View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Float a group of cells so they are always in view

"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
---