column width

  1. dannyok90

    Autofit Columns VBA

    Hi all, Just wondering if there is a way to autofit columns but keep its current size if the new contents don't extend beyond its current width? Thanks, Dan
  2. J

    [Word VBA] how to compute a table occupies rows number

    Hi, All In WORD, when a table's column width is not large enough, usually some cells will occupies more than one row to display content in it. For example: A 3 * 4 table, when content in each cell is not long enough, the table occupy only 3 rows in WORD, but when content in for exam...
  3. R

    Conditionally Format a cell when typing longer text than allowed column width.

    Hello, I want my users to fill excel where I have fixed column width and I dont want then to type longer text. So I want to color text in red for example if they exceed the column width. How can I do this? Thank you.
  4. M

    Excluding a sheet from VBA loop - Column widths

    Hi All - I have a code below that works as intended, but I need help changing it slightly. It currently works to cycle through all worksheets and adjust the column widths from the active sheet. The change I need is: I want 2 worksheets to be exempt from this editing. The 2 sheets are...
  5. K

    width of spreadsheet no consistent

    On one sheet I have 10 columns A to J, with each being 5.00 in width. On the next sheet, I have 20 columns (A to T), with each being 2.50 in width. 10 x 5.00 = 20 x 2.50 and yet when I switch between the two sheets they occupy different widths on my screen (same zoom level). Even when I try to...
  6. D

    How to minimize wasted space in cells - optimize row height/column width?

    I often create tables in Excel where some cells contain a lot of text while others just contain a single digit or some other short value. With wrap text in cells enabled and then a combination of increasing row height and autofit the width of the columns there is a lot of wasted space in my...
  7. JARHTMD

    How to 'cover up' Data in a Cell in Excel2007

    I have a sheet in which I want to deliberately "cover up" data in a particular cell. I don't want to hide the cell. I want it to be readily/quickly available (for me), but hidden from everyone else. I don't want anything elaborate. I'll know what's there, but others will have no reason to...
  8. S

    How to set a column width or row height using an excel function

    I can retrieve a cell width or height using the CELL function. I would like to use this function to keep multiple sheet in sync with any reformatting done on the first sheet. Is there any Excel Function that does something like SetColumnWidth(Column,Width) or SetRowHeight(Row,Height) ? Thanks...
  9. 9tanstaafl9

    Mystery Autofit - widths automatically adjusting

    I'm pretty sure that I have seen a workbook before, where the column widths adjusted themselves automatically whenever the value in a column got large enough that it required an adjustment to avoid seeing #######. And when I say automatically, I don't mean that the column was adjusted during...
  10. E

    Why are Pixels Different with Same Column Width?

    Hello, While working in Excel 2010 on the same computer, I have two workbooks open side-by-side. In File A, my Column Width is set on 14.00 and the Pixel count equals 89; however in File B, my Column Width is also set on 14.00 but the Pixel count instead equals 103. Why is there a difference...
  11. 9tanstaafl9

    Copy Visible Columns VALUES and FORMAT - is this possible?

    I have to copy data from sheet 2 to sheet 1. Sheet 2 has a bunch of hidden columns (I don't know which they will be ahead of time). This works to paste formulas, but I need values: Sheet2.Range("B8:AM28").SpecialCells(xlCellTypeVisible).Copy Destination:=Sheet1.Range("A12") I must past...
  12. E

    Average column width, instead of maximum.

    Hello, forum. I have a list of descriptions, they live in a column. Some of them are very short, others are really long, but most of them are somewhere in between. If I double click the column header's right edge, it automatically adjust the width to display the longest description according to...
  13. H

    Change column width

    Hi, I want to change column width on the following columns in my worksheet: O, S, W, AA, AE, AI from 2 to 1. What I have is this: Range("O:O,S:S,W:W,AA:AA,AE:AE,AI:AI").Select Selection.ColumnWidth = 1 The problem is that it is selecting all columns from B to AI. I have some merged...
  14. H

    Column Width, text can "bleed" into cells to right yet when number exceeds width it only shows #

    I've tried playing with all the formatting, and none of it seems to affect this. My source file has all columns that are 15 pixels wide, meaning only a single character can fit. If I put in TEXT, it will show the text properly that spans several columns (if there is nothing in those cells to...
  15. L

    Setting column widths by values in Row 2

    I am looking for a way to set column widths by the values in Row 2 <tbody> A B C D 1 2 8.43 50 20 15 </tbody> Thanks for any help you can provide!
  16. R

    Variable bar chart column width depending on value

    Wondering if anyone can help, not being familiar this is probably an easy one for someone with Excel ninja skills: Along the x axis = time; y axis = ticket cluster ID Each ticket cluster ID has a life span (date range) which is shown in x-axis and within each ticket cluster ID is a number of...
  17. E

    Display row height and column width in inches a cell

    Hello, I want to display row height in inches in a cell (the same value displayed when using page layout mode), and i want to do the same with column width. I am using Windows 7 and office 2010. I found this code: <CODE>Function Width(MyRange As Range) As DoubleApplication.Volatile Width =...
  18. S

    Column chart - adjustable width of every column?

    Hi guys, I made a normal 100% stacked column based on the following data. Simply select all the cells in the following table, and click 100% stacked column in Excel 2010. Because the A/B/C/D columns they have different weight when it comes to importance. Therefore, I am thinking to make the...
  19. J

    Auto Cell formatting when using Wrap Text

    I have a rather large list of parts that are exported from an Oracle download. When I pull this report I often have to adjsut the column width in order to read the long part descriptions. If I click on the top of the row and do wrap text to get a cells with a greater row height sometimes all...
  20. H

    Adjust cell width and height to fit print margins (no gaps)?

    Hello, I would like to adjust my cell height and width to perfectly fit a margin of: 0.75inch from right and left. 0.50inch from top and bottom. No room for header or footer. I have 5 columns and 10 rows per page. I adjust my printer margins to match the numbers above and center the prints...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top