ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   NEED A PART OF THE TABLE TO REMAIN IN THE SCREEN, HOW?? (https://www.excelbanter.com/excel-discussion-misc-queries/43675-need-part-table-remain-screen-how.html)

san

NEED A PART OF THE TABLE TO REMAIN IN THE SCREEN, HOW??
 
need a part of the table to remain in the screen wyl the rest of the date
should be able to scroll. like the headings in the table to be shown wyl the
data can be scanned by scrolling down??

David Billigmeier

Select the row you would like to be stationary and Window-Freeze Panes
--
Regards,
Dave


"san" wrote:

need a part of the table to remain in the screen wyl the rest of the date
should be able to scroll. like the headings in the table to be shown wyl the
data can be scanned by scrolling down??


Ray A

One way
Show the data you want to display and then WindowsFreeze Panes
Alternative
At the top of the horizonital scroll bar and the right of the vertical there
is a small line that you can grab with your mouse. Drag this to any location
desired to split the window.
HTH
"san" wrote:

need a part of the table to remain in the screen wyl the rest of the date
should be able to scroll. like the headings in the table to be shown wyl the
data can be scanned by scrolling down??



All times are GMT +1. The time now is 02:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com