Excel

[gayanwin]

Machan Meke excel sheet 100k withara thiyanawa mata one 100 weni sheet ekata giyath me name kiyana sheet eka hiden nowi thiyaganna widiyak. ahema thiye nam kiyala diyan

 

[sanjuprasad]

Power Bi ise karanna ba da?

 

[gayanwin]

Power Bi ise karanna ba da?

a kiwe

 

[cheyrav]

bump

 

[Lovtus]

select the worksheet tab > click the "View" tab on the ribbo > In the "Window" group, click "Freeze Panes". A drop-down menu will appear. Click "Freeze Panes".

 

[gayanwin]

select the worksheet tab > click the "View" tab on the ribbo > In the "Window" group, click "Freeze Panes". A drop-down menu will appear. Click "Freeze Panes".

machan mata freeze karaganna one work shee eka ahema nathuwa work sheet eke cells rows newe

 

[Lovtus]

machan mata freeze karaganna one work shee eka ahema nathuwa work sheet eke cells rows newe

tab eka uda right-click karala freeze panes daala balapan

 

[gayanwin]

tab eka uda right-click karala freeze panes daala balapan

ahema option ekak na ban

 

[Handuna]

To freeze a worksheet tab in Excel, first select the worksheet tab you want to freeze. Then, click the "View" tab on the ribbon. In the "Window" group, click "Freeze Panes". A drop-down menu will appear. Click "Freeze Panes".

Your worksheet tab will now be frozen in place. You can scroll left and right and up and down, but the worksheet tab will stay in the same place. This is helpful if you want to keep track of where you are in a large worksheet.
Google දෙයිය තමයි කිව්වේ.

 

[gayanwin]

To freeze a worksheet tab in Excel, first select the worksheet tab you want to freeze. Then, click the "View" tab on the ribbon. In the "Window" group, click "Freeze Panes". A drop-down menu will appear. Click "Freeze Panes".

Your worksheet tab will now be frozen in place. You can scroll left and right and up and down, but the worksheet tab will stay in the same place. This is helpful if you want to keep track of where you are in a large worksheet.
Google දෙයිය තමයි කිව්වේ.

naha machan hariyanne na one nam uba karala balahanko

 

[Nidarshana_k]

View attachment 192307

Machan Meke excel sheet 100k withara thiyanawa mata one 100 weni sheet ekata giyath me name kiyana sheet eka hiden nowi thiyaganna widiyak. ahema thiye nam kiyala diyan

ehama karanne kohomada bn ubata one windows 2k use karnnada ?

 

[Handuna]

https://www.extendoffice.com/documents/excel/2695-excel-lock-freeze-worksheet-tab.html

Me link eke thiyenawa answer eka. Podi vba code ekak.

 

[gayanwin]

https://www.extendoffice.com/documents/excel/2695-excel-lock-freeze-worksheet-tab.html

Me link eke thiyenawa answer eka. Podi vba code ekak.

Thanks Machan Eth Meka Freeze wenne na machan shet eka pana pana view wenawa mata one mulinma freeze wela thiyenna

 

[kinkon]

බම්ප්

 

[Any.key]

bump