I have importing data from an Access file to Excel but everytime I update the Excel file, rather then Wrap texting certain columns, it automatically widens the column and puts everything in one line. I want it to be able to stay a certain size and as data updates, the column simply wraps it into another line. I tried to protect the sheet but then I am unable to import data. Any suggestions?
I am trying to change the width of a column and everytime I highlight it and right click for options the menu does not appear. What appears in the column is a down arrow.
Any reason why this is happening?
Thanks in advance.
Good day
I am making a form at work, the column width for the top 10 rows is ok, however I would like to change to column width after those 10 rows - please help. .....thank you
StellaBee
I have column headers located in I3:L3 that change based on a selection from a data validation list pulling from R1 of another worksheet.
A VLOOKUP function pulls the corresponding data into the cells below each header.
I need help with a macro that will autofit the column width if the contents of any of these cells change.
This worksheet is normally locked, so if possible, I would like to be able to automatically unlock the column in order to autofit the column, then relock it. That's a secondary issue though.
How do I change the column width for some rows and not for others within the
same excel worksheet? Is this possible? Thank you!
Hello all.
Two easy queries I think, but i'm stuck.
1. How to i change the format of a column to text, and also also the width - i seem to be able to do either / or in one line. I could write two lines but i though there must be a better way . My current code is below.
Range("A:A").NumberFormat = "@" AND ColumnWidth = 18
2. If i want all columns from Column I through to the last column to be text and 13 width - how would i VBA that please ?
Thanks, as always, for your help. Chuf
Hi All!
Hey, we just ran into something interesting, and am hoping that an expert on here can help us figure out how Excel is doing this...
In a cell on a spreadsheet is a number in 12 pt. font -- if you decrease the size of the column, the size of the font is changing to show the entire number (vs. changing it to ####)... So, if the number 12345 fits in the cell perfectly in 12 pt font, and you decrease the size of the cell, the font size is changing to 8 pt font so the entire number is still visible...
How does Excel do this? What/where are the settings? We'd like to know how to do this for future implementations!
Thanks much!
-j.g.
Using Excel 2007, how can you seperate or divide up your excel sheet you are working on. This is hard to explain but easy if you could see what I was trying to do.
Basically, how do you change width and height of a cell with out it doing it for every cell in that column or row? I'm have completed my first top layer in Excel, and now I need the bottom half cells to be a different width and height without it changeing my top half.
Does that make sense?
Sometimes Excel 2007 will automatically adjust the column width when I change a cell's format and the new number is too wide for the old column. That's helpful at times but sometimes I would like to get it to stop doing that. Is there a way?
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 enters "a very very long word" in cell C17, then column A will need to be wide. If someone enters "short" in C17, then Column A can be narrower. Is there a way I can set things so that the column width is adjusted without me having to do anything after the word is entered into C17?
Many thanks
Sam
