Thread: Floating Cells
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Clark
 
Posts: n/a
Default Floating Cells

What about creating a "button" that floats as you scroll?

"Michael M" wrote:

Clark
As Ken has stated, really can't be done.
If you think about your question, you will realise that you will be lining
data up with data that is not relative to the first column.
You can freeze some rows and some columns but you can't do both

HTH
Michael M

"Clark" wrote:

Thanks ken, but I want to be able to freeze these few cells in column A, and
still scroll the remainder of the rows in Columns B to Z independently.

Clark

"Ken Hudson" wrote:

Click on the cell just below the lowest cell that you want to anchor and go
to Window Freeze Panes.
--
Ken Hudson


"Clark" wrote:

Can I make a group of cells in Column A, "float" or stay near the top left of
the spreadsheet as I scroll down?