#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Inventory Sheet

I downloaded the inventory sheet and there is a feature which I cannot seem
to duplicate.

The first two rows appear to be frozen. The data can be scrolled without
the top two lines moving. How do I set this up for other spreadsheets?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 515
Default Inventory Sheet

If you want to freeze the top 2 rows, select A3, click on Window, the Freeze
Panes.
If you also want to freeze Column A, to be visible when you scroll right,
select B3 in stead
--
Hth

Kassie Kasselman


"Grillin'" wrote:

I downloaded the inventory sheet and there is a feature which I cannot seem
to duplicate.

The first two rows appear to be frozen. The data can be scrolled without
the top two lines moving. How do I set this up for other spreadsheets?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Inventory Sheet

Select A1 (so you can see rows 1 and 2)
Select A3
Window|freeze panes.

Everything above A3 will be frozen.

If you had selected B3, then everything above B3 would be frozen and everything
to the left of B3 (column A) would be frozen.

And if you have data|Filter applied, show all first--else you may be freezing in
the wrong cell.

And window|Unfreeze Panes
to get rid of it.

Grillin' wrote:

I downloaded the inventory sheet and there is a feature which I cannot seem
to duplicate.

The first two rows appear to be frozen. The data can be scrolled without
the top two lines moving. How do I set this up for other spreadsheets?


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default Inventory Sheet

Goto Tools ~ Options ~ General Tab. Verify that the "At Startu[p..." field is
empty.

"Grillin'" wrote:

I downloaded the inventory sheet and there is a feature which I cannot seem
to duplicate.

The first two rows appear to be frozen. The data can be scrolled without
the top two lines moving. How do I set this up for other spreadsheets?

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
How do I build a excel sheet that counts item in an inventory kenny Excel Worksheet Functions 2 May 9th 06 05:03 PM
Inventory Sheet Medic 803 Excel Discussion (Misc queries) 1 January 3rd 06 06:48 PM
Inventory sheet to track, order & reduce quantity from master. drc536 New Users to Excel 2 October 23rd 05 06:36 PM
how do i set u a inventory sheet for a vending mahine Bratt Excel Discussion (Misc queries) 0 July 7th 05 03:32 AM
Inventory Wash-Out sheet DirtRoad Excel Worksheet Functions 0 February 28th 05 07:35 AM


All times are GMT +1. The time now is 11:27 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"