Fixed area above row 1

F

fwells11

I would like to be able to place an image and a few buttons on the top
of a worksheet that do not move as I manipulate the data. Is there any
way to place fixed content above Row 1 In Excel please?

TIA
 
M

MartinW

Hi fwells,

You can't place them above row 1 but you can place them in row 1 or however
many rows you require.

Select an entire row and go to Window>freeze frames.
This will freeze any frames above the one you selected.

For example if you select row 6 - then rows 1 to 5 will be frozen, select
row 2 and row 1 will be frozen etc.

HTH
Martin
 
D

Dave Peterson

How about just using row 1?

You can show row 1.
Select row 2
and window|freeze panes.

So row 1 is always visible when you scroll up/down the worksheet.

======
I'm not sure what you're doing, but maybe creating a floating toolbar would be
an option.
 
Top