width

Dear Experts Attached blank excel sheet column width is read in pixel 8.43 (64 pixel) top of column A I tried File menu --> Option --> Advanced --> Display Ruler to mm --> Press OK button https://imgur.com/a/KwlpEqX But that won't change pixel to mm Am I missing something ? is this the...

Need help with the following: I have a height and width column in pixel count. I convert the pixels to inches without a problem. How do I figure out the last row in the column. They amount of rows will change every time I pull my data. In other words, how can I create my calculation for each...

I am trying to create a button through VBA Code that allows me to autofit every column in a worksheet based only on the range of cells that has numbers in it (Ie. prevents autofitting based on headers). I found a video online that gives me the following code but it needs to be modified in order...

Hi everyone, I am wondering if it’s possible to set column widths to a wider size than the above, using say a range, meaning if the range A1-A17 = column size 10.00 then have A18 –A100 = column size 20.00, I don’t wish to use merge cells or wordwap if possible. Or if not at least simulate...

Hi, I have some code which takes a range in excel (which changes in size) and then pastes it into powerpoint as a picture. I need some code that will copy the range and paste it as a picture to a specified width or height (one or the other). Whether the picture is sized to the specified width or...

Hi, I have been using a vba code for a while, but I can't get it to work anymore. Not sure what I'm doing wrong. The code should determine the last used cell in column "A". And then it will fill the height or width of the empty space. But the image height cannot be more than H and width...

Morning, I'm creating a 1 page document that each column (columns A - I) is a set width. Most of the worksheet is filled with drop down lists that are wordy. Due to the size of each column, you can't read the each item in the drop down to the cell size. I'm looking for a way to increase the...

Hi guys, I recently converted to office 365 from 2010 and had a problem when I was resizing one of my Excel charts. Previously (on Excel 2010) I was able to change the width from say 5.45cm to 5.50cm without the height changing (say it was at 10cm). But with office 365 when I change the chart...

Hi When i see the image inserted in a cell thru coding and its height width properties are dispalyed as 2.28 cm and 16.27 cm respectively ScaleHeight and Scale width shows 100% but in the original excel sheet the same image created in the sheet is at 2.12 cm Height 16.27 cm width ScaleWidth =...

I am trying to solve a problem. Assume I have a label that is 100 twips in width (default unit from my research) for a userform. I need to count how many characters of a specific font can fit into that 100 width without going to a new line. That would require converting these units of measure...

Hi All, I ma writing a script to covert a given range into image, i found a code from which was working fine as long as the range was smaller width but the moment i increased the width of the column it is not working, the whole image is not creating. the below is the steps how the code works, 1)...

I have multiple charts with the same series, so I want to write a code where I can just have 1 legend instead of having a legend per chart. I felt the easiest way was to write a code where I can have the legend cover the entire chart area. However, i've run into a problem where the legend...

I'm having trouble finding code online that works to autofit a column width based on a selection in a drop down list. I would also like to have a minimum width that the column won't go below. I would need it for many columns in the same sheet so could it be a global type code? If not I can...

Hi I inserted a pic in excel sheet. The sheet has many functions. When I clicked on Formulas tab -->Show Formulas. Columns width would change (expand) to show the formulas but the picture width also chang as a result (expand and become not clear). Can I fix the picture size? I thought picture...

I'm trying to create text boxes with the same border width as the worksheet cells (set in VBA). My VBA code sets Selection.Borders(xlEdgeTop).Weight = xlThin Units for text box border width in format shape/line/weights & arrows = ??pts I'd like to set the borders of my textbox to the points...

How would one automatically adjust a rows height as the cell entry exceeds the column width.Thanks

Can a comment box be configured with a set width and grow the height as required to fit the text *as I type* it? It could start as 100 characters wide x 1 line high but when I hit 101 characters it wraps to the next line and the comment box grows by a line vertically to show all the text...

Is there a method/macro/add-in that allows me to save tables with formatting as an HTML file but without the column fixed width? I would like to keep cell text color, cell background color, cell font, rowspan, colspan, etc.... but just without the column fixed width.

Hi there, I have a workbook and each sheet has a different range set as the print area. Some are bigger than others but on the whole they are all pretty similar. I'd like to be able to set each page's print setup so that each 'print area' range fits to the width of the print paper (or PDF...

Hi All, I'm a graphic designer (not a mathematician) and I'm trying to create a little calculator that will give me the column and gutter widths of a page, based on the following variables: -Page width -# of Columns desired -Gutter width is x% of Column width (eg. all gutters would be 25% the...