Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Fixed area above row 1

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

  #2   Report Post  
Posted to microsoft.public.excel.misc
MartinW
 
Posts: n/a
Default Fixed area above row 1

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


  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Fixed area above row 1

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.

wrote:

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


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fixed area above row 1 [email protected] Excel Discussion (Misc queries) 0 April 25th 06 07:25 AM
How to increase chart area without affecting plot area? [email protected] Charts and Charting in Excel 2 April 21st 06 09:05 PM
Extra Row in Defined Print Area Harry Gordon Excel Discussion (Misc queries) 3 November 14th 05 03:06 AM
Print Excel charts in Word 2003 with fixed size Phil Charts and Charting in Excel 1 November 3rd 05 04:24 AM
Volatile print area stevepain Excel Discussion (Misc queries) 6 July 20th 05 05:46 PM


All times are GMT +1. The time now is 04:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"