Float a window over sheet
 

Is it possible to float a window over an active sheet. The window would
contain three columns on six cells? Any help would be great. Thank you. Jay

Float a window over sheet
 

I forgot to state that the cells would be data from another sheet in the
workbook

"Jason" wrote:

Is it possible to float a window over an active sheet. The window would
contain three columns on six cells? Any help would be great. Thank you. Jay

Float a window over sheet
 

You can take a picture of a range.

Select your range
edit|copy
go to a different location
Shift-Edit|Paste Picture Link

And you can move that picture where ever you want.

If you want this always visible, you could put the picture in Row 1 (and make
row 1 tall enough to fit the picture).

Then Window|Freeze panes to make sure row 1 is always visible.

In fact, you could put it in column A and freeze column A as well as row 1.

Jason wrote:

Is it possible to float a window over an active sheet. The window would
contain three columns on six cells? Any help would be great. Thank you. Jay

--

Dave Peterson

Float a window over sheet
 

Dave Thank you, My goal is to have this as a seperate window as I would like
it not to print when the sheet is printed. The infomation would be
confidental with only those who have access to the file being able to see
that window., and then it is printed and posted without that information.

Basicly it is an employee schedule. As you make a change to the schedule it
updates with how much that week costs you in payroll. That way the scheduling
people can find the least expensive person to fill a shift.

"Dave Peterson" wrote:

You can take a picture of a range.

Select your range
edit|copy
go to a different location
Shift-Edit|Paste Picture Link

And you can move that picture where ever you want.

If you want this always visible, you could put the picture in Row 1 (and make
row 1 tall enough to fit the picture).

Then Window|Freeze panes to make sure row 1 is always visible.

In fact, you could put it in column A and freeze column A as well as row 1.

Jason wrote:

Is it possible to float a window over an active sheet. The window would
contain three columns on six cells? Any help would be great. Thank you. Jay

--

Dave Peterson

Float a window over sheet
 

If you're using Excel 2002, or later version, you can use the Watch
window to view specific cells:

Choose ToolsFormula AuditingShow Watch Window
Select a cell
Click the Add Watch button
Click the Add button

To go to a watched cell, double-click its name in the watch list.


Jason wrote:
Dave Thank you, My goal is to have this as a seperate window as I would like
it not to print when the sheet is printed. The infomation would be
confidental with only those who have access to the file being able to see
that window., and then it is printed and posted without that information.

Basicly it is an employee schedule. As you make a change to the schedule it
updates with how much that week costs you in payroll. That way the scheduling
people can find the least expensive person to fill a shift.

"Dave Peterson" wrote:


You can take a picture of a range.

Select your range
edit|copy
go to a different location
Shift-Edit|Paste Picture Link

And you can move that picture where ever you want.

If you want this always visible, you could put the picture in Row 1 (and make
row 1 tall enough to fit the picture).

Then Window|Freeze panes to make sure row 1 is always visible.

In fact, you could put it in column A and freeze column A as well as row 1.

Jason wrote:

Is it possible to float a window over an active sheet. The window would
contain three columns on six cells? Any help would be great. Thank you. Jay

--

Dave Peterson




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html