ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   One column stays while others scroll (https://www.excelbanter.com/excel-discussion-misc-queries/122509-one-column-stays-while-others-scroll.html)

Virginia

One column stays while others scroll
 
I am trying to create a chart that scrolls to the left as data is entered,
but I want column A to stay and not scroll. How do I format this?

David Biddulph

One column stays while others scroll
 
If you're talking not about a chart, but about a worksheet, select column B,
then Windows/ Freeze Panes.
--
David Biddulph

"Virginia" wrote in message
...
I am trying to create a chart that scrolls to the left as data is entered,
but I want column A to stay and not scroll. How do I format this?




Gord Dibben

One column stays while others scroll
 
Virginia

Select B1 and WindowFreeze Panes.


Gord Dibben MS Excel MVP

On Wed, 13 Dec 2006 08:31:01 -0800, Virginia
wrote:

I am trying to create a chart that scrolls to the left as data is entered,
but I want column A to stay and not scroll. How do I format this?




All times are GMT +1. The time now is 07:27 AM.

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