Hello All,
Could you please tell me a way so that i can lock or fix columns width upto certain row then for below it will be different.
Hello All,
Could you please tell me a way so that i can lock or fix columns width upto certain row then for below it will be different.
Last edited by tanvi_kalra; 02-14-2014 at 06:52 AM.
No, a column can't have a different width for different rows - the column width is the same for all rows...
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Hello OllyXLS
Thanks for quick reply. I want to know is there any way so that we can apply page breaks then change the width on respective page portions.
Hello OllyXLS
Thanks for quick reply. I want to know is there any way so that we can apply page breaks then change the width on respective page portions.
No, a column can't have a different width for different rows - the column width is the same for all rows...
(Going well this, isn't it?)
Actually i need to fix the size of a cell so that other cells on changing won't effect the size of this cell.
So you need to protect the worksheet, to prevent column width changes to that cell...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks