cancel
Showing results for 
Search instead for 
Did you mean: 

HOW TO FIX COLUMN IN BEX REPORT

Former Member
0 Kudos

Hello Gurus,

I have created BEX report in which user want 1st two column (Material and its describtion) to be fixed as if he want to check all relavent result related to Material the first 2 column should not be move it should be fixed and rest other results and other column should move,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

If u want 2 fix first two columns, then select 3 rd column. And then in menu "<b>Window</b>" select <b>freeze panes</b>.

suppose want to fix first row select second row and do freeze panes.

If u want to fix both rows and columns select the intersection of next row and next column.

Hope its clear.

reward if useful.

shylaja.

Answers (3)

Answers (3)

Former Member
0 Kudos

hi,

look at this thread already posted:

shameem

Former Member
0 Kudos

Thanks for ur answers,

well it dosent help much,

my question is that i just want to fix first 2 columns and rest should move.The query which i design is v long in width so what i want that 1st two column(material and its describtion) should as it is while rest of columns move (scrole) so all related results and other feilds displayes in front of 1st two column i.e,Material and its describtion.

former_member188325
Active Contributor
0 Kudos

Hi,

select required first two columns,go to "window" from Excel menu bar..enable(click on) freez panes..and save it as work book if necessary...

Hope this helps...

Pl dont forget assign points if it helps.

Thanks

Former Member
0 Kudos

Hi Wajid,

The VBA code i gave earlier will do this automatically for your users. Please use it. It freezest columns A and B so that columns A and B dont move even if your users scroll to the right. It just stays there.

In your workbook after you have inserted your query, go to Tools->Macro->Visual Basic Editor. Then go to Insert Menu->Module. Double click the module that have been created (probable name is Module1) and then on the code editor paste this code:

Public Sub SAPBEXonRefresh(queryID As String, resultArea As Range)

Range("C1").Select

ActiveWindow.FreezePanes = True

End Sub

Everytime the users refresh your query it will freeze the first to columns. So at least you are sure that the columns A and B are frozen.

Former Member
0 Kudos

Hi,

You can do this via the following VBA code:

Public Sub SAPBEXonRefresh(queryID As String, resultArea As Range)

Range("C1").Select

ActiveWindow.FreezePanes = True

End Sub

Put this this code in a VBA module in your workbook. It will execute everytime the user refreshes the query and will freeze the first two columns (to the left of C1).

Message was edited by: Emmanuel Nepomuceno

Message was edited by: Emmanuel Nepomuceno

Former Member
0 Kudos

hi wajid,

select the colum -> right click-> select properties->column width

select the radio button " do not adjust the column width"

cheers

ravi