ExcelBanter - Keeping data in a cell stationary while the spreadsheet is scroll

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Keeping data in a cell stationary while the spreadsheet is scroll (https://www.excelbanter.com/excel-discussion-misc-queries/46888-keeping-data-cell-stationary-while-spreadsheet-scroll.html)

Tammy

Keeping data in a cell stationary while the spreadsheet is scroll

I need to keep my data in the left margin stationary while scrolling throught
the spread sheet to the right. How do I do that?

Sloth

highlight cell B1 and click on Window-Freeze Panes

This will "freeze" column A

"Tammy" wrote:

I need to keep my data in the left margin stationary while scrolling throught
the spread sheet to the right. How do I do that?

All times are GMT +1. The time now is 03:45 AM.