column width

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

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

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

I am embedding multiple excel tables into Microsoft Word through the Paste Special function. The tables are looking great. Is there a way to set the width of the tables in excel? I would like them to fit the parameters of my word document. I can change the width of columns individually. But...

Hi My cell A1 has the following formula: "='SheetX'!C17" So, if someone enters a word in cell C17 of "SheetX", that word will appear in A1. Is it possible to have excel automatically adjust the width of column A based on the length of the word that is entered? For example, if someone...

Hi, This will be my first time using VBA and writing code. I am completely clueless so details are greatly appreciated. What I am trying to do: I've created a Pivot table report that automatically refreshes everytime it opens. On every refresh, the auto-format, in particular column width...

I have defined in a worksheet (Lists) column (K) and rows 31 through 38 contaning values: 9.3, 8.3, 11.3, etc... I need to be able to loop through this table using the values to set column widths in the worksheet "Report" starting at column A. I greatly appreciate help with this macro. Thanks...

Does anyone know of or have a VBA code that enables you to fix column width yet autofit rows?! I would like columns E:G to have their width fixed to 75, yet still allow rows E12:G16 to autofit. I was previously using the following so that columns E:G autofitted, as and when data was pulled...