View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Selecting row data, filter out column nulls and reporting resu

Hi Tom,

Freeze panes basically freezes the top rows or left columns (or both) so
that they never scroll off the screen.

When Freeze panes is applied, the rows and/or columns are frozen above and
to the left of the current cell selection. If you only want to freeze rows at
the top then select a cell in column A (say A11) and apply Freeze panes and
then rows 1:10 will be frozen against vertical scrolling. (always visible)

If you want to also freeze say column A because it has row identifier info
in it then select say B11 then Rows 1:10 are frozen against vertical scroll
and column A is frozen against horizontal scroll.

If you look up Freeze panes in Help you should find all the info you need.

As some added extra info for the future, it is always a good idea to include
in your post the version of xl you are using. Sometimes it does not matter
but other times it is critical when explaining how to do something.

--
Regards,

OssieMac