ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Freze panes (https://www.excelbanter.com/excel-worksheet-functions/104874-freze-panes.html)

blander

Freze panes
 

Hi guys,

How do i keep the columns A and B on the left while scrolling sccross..


--
blander
------------------------------------------------------------------------
blander's Profile: http://www.excelforum.com/member.php...o&userid=36486
View this thread: http://www.excelforum.com/showthread...hreadid=571369


Pete_UK

Freze panes
 
Position the cursor in cell C1 then do Window | Freeze Panes if you do
not have a header row - if you do, position in cell C2.

Hope this helps.

Pete

blander wrote:
Hi guys,

How do i keep the columns A and B on the left while scrolling sccross..


--
blander
------------------------------------------------------------------------
blander's Profile: http://www.excelforum.com/member.php...o&userid=36486
View this thread: http://www.excelforum.com/showthread...hreadid=571369



Marcelo

Freze panes
 
hi,

select c1 and at menu click on Window | Freze Panel

hth
regards from Brazil
Marcelo

"blander" escreveu:


Hi guys,

How do i keep the columns A and B on the left while scrolling sccross..


--
blander
------------------------------------------------------------------------
blander's Profile: http://www.excelforum.com/member.php...o&userid=36486
View this thread: http://www.excelforum.com/showthread...hreadid=571369



blander

Freze panes
 

Thanks guys much appreciated :)


--
blander
------------------------------------------------------------------------
blander's Profile: http://www.excelforum.com/member.php...o&userid=36486
View this thread: http://www.excelforum.com/showthread...hreadid=571369



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

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