I am having an issue with autofitting rows in a spreadsheet of imported text
in Excel 2003. There are no merged cells in the document, and none of the
cells go over the 1024 character limit. When I select all rows and attempt to
autofit the rows to the contents of the cells, some of the rows resize
properly, and some leave one or several lines of white space below the bottom
of the text in the longest cell. I can resize them manually, but this is data
that is imported daily and runs to several thousand rows. If I widen the
column where I am having the problem, once it reaches a certain width (which
varies), if I re-autofit the selection, it will correct itself. But I am
constrained on column width, as there are about 20 columns and I need them
all to fit on one 81/2 by 14 landscape page width. Any ideas on what might be
causing the problem and how to fix it?
1. How do I get rid of extra white space when row autofit is on?
2. "Wrap text" makes row larger than text resulting in white space.
3. Wasted white space Chart Area
4. Excel - fill white space in cells
5. Excel won't properly autofit row height
6. Text format properties and autofit row height questions
7. Determine If Cell Has White Space Only & No Characters
8. White Space Around Chart
9. Autofit Row Height with Merged Cells
10. Remove white space
11. How to remove white spaces between brackets in xls to notepad export
12. Autofit Row
13. AutoFit rows with top aligned & merged cells
14. Excell autofit row height function
15. Autofit Row Height of Merged Cells
16. Excel save as htm with functionality too much white space
17. How do I display white space characters in excel?
18. Issues with white space when printing & with wrapping text
19. White Space in a Cell
I type various rows of text. Each row containing a different number of
sentences. I format the row to wrap text. However, Excel increases the row
height more than is needed therefore resulting in white space. I have to
then resize the row by "guessing" at what size will work to fit the text.
I am creating a spreadsheet that contains a column of text followed columns
I have a lot to fit into one page, the font is small, and the description in
the text field varies in length. How can I fill the following white space
with dots to make it easier to determine which figure follows the text in the
Shading or colour is not appropriate to aid reading along the row as the
spreadsheet will be photocopied.
It is not appropriate to create the file in Word, because the figures are
updated from other cells on the spreadsheet.
I have noticed that when I copy a long string of text (for what I've experienced more than 12 lines) to a
single cell, I can't get the autofit row height to work properly. It strech the height of the cell to only the 12th line. So
when I copy a huge string of text(20+ lines) and I use autofit row height, it doesn't fit the height properly and I have to
strech the height of the row manually.
Also I noticed that when I copy paste text into a cell, the cell format is
set to general and if I put the cell format to text, the value of the cell is changed to "##################".
someone please explain me what is happening and what I am doing wrong.
I have found a workaround for the problem with autofitting row height with merged cells. My fix is to go to a blank column to
the right of your data and copy the data from your merged cells and paste special< values to the blank column. Then expand
this new column to match the width of the original merged columns. Now the autifit will work for each row since the new
column is not merged. Then you can either hide this column for later use or delete it.
I have a cell (Say M5) that Conatenates some text based on the answer to another cell (Say M2). Based on this, the cell
autowraps text so that it may need to be 2 rows in height or not. I would like the autofit row to automatically adjust the
row size based on any changes to M2.
I'm creating a worksheet where I want users to fill in free text data.
the autofit row height seems to work where individual cells are concerned.
My difficulty is that where cells have been merged (within a single row) the
function appears not to work.
How can I get rid of the white space around the table when I do save as htm
with excel funtionality. I changed to to align to the left but have a good 1
1/2 inch of white space (want to expand it) that is unusable and I would like
to get rid of.
When I print and print preview, there is quite a bit of white space in the
cells. However, in the spreadsheet, there is no whitespace in the cells.
How do I get rid of this whitespace when I print?
In one cell, there is 14 bullet points and some of these bullet points have
several wrapped lines. Wrapping works for all lines except fot the last
line. For the last line in this cell, the text shows in the formula bar but
does not show on the spreadsheet. It just cuts off at the end of the line
and doesn't wrap to the next line.
Is there a limit to how much text can be stored in a cell in order to have
the text wrapping work effectively? I have seen this issue before so I am
hoping this is a known issue.
I'm collating a lot of spreadsheets that many other
people have filled in onto one big spreadhseet template.
My problem is that there is a free text cell and, because
dont know about the 'alt & enter' option, they've hit the space bar
many many times make it look like a new point starts on a new line.
In Word, you have the option of showing all
the keyboard strokes
so you can tell what people have done - but I'm finding I'm having
to go into each free text cell and hit delete, then the cell magically
shifts up so that there is no white space.
Any ideas? My document is currently 200 pages long and I'm
nowhere near done!