+ Reply to Thread
Results 1 to 7 of 7

Fixed size for some range of cells

  1. #1
    Registered User
    Join Date
    01-23-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    79

    Fixed size for some range of cells

    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.

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Fixed size for some range of cells

    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...

  3. #3
    Registered User
    Join Date
    01-23-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    79

    Re: Fixed size for some range of cells

    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.

  4. #4
    Registered User
    Join Date
    01-23-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    79

    Re: Fixed size for some range of cells

    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.

  5. #5
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Fixed size for some range of cells

    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?)

  6. #6
    Registered User
    Join Date
    01-23-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    79

    Re: Fixed size for some range of cells

    Actually i need to fix the size of a cell so that other cells on changing won't effect the size of this cell.

  7. #7
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Fixed size for some range of cells

    So you need to protect the worksheet, to prevent column width changes to that cell...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. inserting image to cell/merged cells as background fixed to cell's size.
    By _Rapier_ in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-18-2014, 02:17 PM
  2. Identify & highlight if all cells in a fixed range are blank
    By heena.singh in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-24-2013, 05:57 AM
  3. Average excluding zeros over a variable range of fixed size
    By tface in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 02-09-2013, 08:23 AM
  4. Change range of cells within VBA macro and copy and paste to fixed cell range
    By Mannyny in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-20-2012, 11:51 AM
  5. checkbox size is not fixed - size decreased
    By nimi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2008, 05:07 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1