ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how to fit my column unmoved eventhough i scroll down? (https://www.excelbanter.com/new-users-excel/4532-how-fit-my-column-unmoved-eventhough-i-scroll-down.html)

Zxing

how to fit my column unmoved eventhough i scroll down?
 
how to make like for example i have column 1 until column 20
when i right scroll to column 8, it start to move to right hand side, and my
first column can't see anymore.

I want to be even though i scroll, the first column is not moving one.. no
matter how i scroll, it can see the first column, how to set?
which option?

Frank Kabel

Hi
- move the cursor in cell B1
- goto 'windows - Freeze Panes

--
Regards
Frank Kabel
Frankfurt, Germany

"Zxing" schrieb im Newsbeitrag
...
how to make like for example i have column 1 until column 20
when i right scroll to column 8, it start to move to right hand side,

and my
first column can't see anymore.

I want to be even though i scroll, the first column is not moving

one.. no
matter how i scroll, it can see the first column, how to set?
which option?




All times are GMT +1. The time now is 04:09 PM.

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