Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Excel 2000 row heights change between computers

When opening an Excel 2000 document on several different computers, the row
heights change. All are set to the same default printer and are the same
default font. Has anyone seen a cure for this?


Post your answer or comment

comments powered by Disqus
In Excel 2000, can I change the direction of the move selection after Tab? (I
know you can change the dirrection after Enter)

Hi, I have a small excel program to print label.
We have a problem that this program works on certain computers and it doesn't work on others.
When I say it doesn't work, it's because the display change between computers.
Somehow the column width changes, the row height changes, that's why all display change.
And since this program is a label printing program, all changes in column width or row height will affect anything..

One of the changes I notice is the column width in the working computer is 11.86 but when I open the same file on other computer which doesn't work, the column width becomes 11.9
I believe many other changes to other columns too, that's why it's affecting my display badly.

Any idea what happen, or setting or anything that done this?
I have set all the display setting for all computers that open this file to 1024 X 768, but still the problem persisted..

Regards,
Juanda

I created a spreadsheet in earlier version Excel XP (2002 SP3), when I bring
that sheet to another computer with Excel 2003, the Row heights are change.
So, when I sned to print the file the print out is smaller than 2002
version.

Excel 2002 shows 15.25 and Excel 2003 shows 15.2

So, What I trying to do is to change the Row height format, but Excel 2003
does not allow me to do that, the minimum increment is 0.1 and I want 0.05

I have several rows which are relatively large but which have a small
font in the cells. When I copy and paste to another area or another
worksheet, the row height decreases to fit the small font. How can I
keep the row height the same when copying and pasting? I've tried
several options in paste special but nothing works. I'm using Excel 97
at home and 2000 at work and they both do the same.

Thanks in advance,

--
BT

I am trying to figure out how to make the row height change automatically
according to the contents of the cell. I tried autofit option under
'Format->rows'in the menubar. But it doens't seem to work. What I want is the
cells to expand according to the height. I have tried different options but
nothing seems to work at this poing. I am very frustrated so please help me
out.

When I merge two cells in excel 2003 and format to word wrap, the row height
is not adjusting to show wraped text. I am forced to manually adjust row
height

I am trying to figure out how to make the row height change automatically
according to the contents of the cell. I tried autofit option under
'Format->rows'in the menubar. But it doens't seem to work. What I want is the
cells to expand according to the height. I have tried different options but
nothing seems to work at this poing. I am very frustrated so please help me
out.

I used Microsoft Speech to record a lenghthy paragraph into an Excel cell. I
have asked Excel to auto-fit the row height. I have expanded the width of
the column. No matter what I do, all the the text will not show itself in the
cell. It cuts off about half-way down, leaves a big chunk of white space
below the last visible sentence, and that's it. If you F2 on the cell you
can see that all the text is there. Is there some formatting trick to be
able to see all the text in this cell? Thanks.

I have a spreadsheet in which all cells are set to 10 point font and Row height is set to 13.50

I am running into a problem when I want to set all cells to wrap text and then autoformat row height. When I do this (this being turning on the wrap text function) I then select all cells and double click between the line between any two rows to autoformat the row height for all cells. This works fine but if the wrap text feature is not needed for a row, the row height changes from 13.50 to 12.75. I want the row height for every row to be at least 13.50. Is there a way to do this?

I need a formula to calculate the height of a cell. Basically I will repeat this formula thoughtout the database, and each cell in column U will have its row height.

Thanks to Erik and Seti, they have come up with the following code:

Code:
Function RangeHeight(rng As Range) As Double
RangeHeight = rng.Height
End Function

Now, the problem is, that the formula does not automatically update when the row height changes, and when I open the file on another pc, all the formulas change to #NAME since it does not recognise the custom formula.
Any idea?

Thanks,
Chris

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.

any suggestions ?

--
later

Hello,
I have a problem in Excel 2000 during copying everything on a worksheet
to antoher worksheet (values in cells and textboxes).

To avoid the run-time error 1004 (from Microsofts Knowledge
Base-article - 177634) that occurrs if you copy the sheet over and over
again, following code is used:

Code:
--------------------
Sheets("MyOrigSheet").Visible = True
Sheets("MyOrigSheet").Select

'Add new sheet
Sheets.Add Befo=Sheets(1)

'Copy cells but not drawingobjects from original sheet
Sheets("MyOrigSheet").Cells.Copy

'Pasting cells on new sheet
Sheets(ActiveSheet.Name).Paste

'Copy drawingobjects (textboxes and buttons) from original sheet
Sheets("Sum per meas Grund").DrawingObjects.Copy

Sheets(ActiveSheet.Name).Paste

Sheets(ActiveSheet.Name).Select
Sheets(ActiveSheet.Name).Name = "MyNewSheet"
--------------------

Using Excel 2002 and Excel 2003 this works all fine. But not on Excel
2000.

Does not Drawingobjects exist in Excel 2000?

Do I have to check for version and then in case Excel 2000 use the
following code instead:

Sheets("MyOrigSheet").Copy Befo=Worksheets(1)
Sheets("MyOrigSheet").Visible = False
Sheets("MyOrigSheet(2)").Select
Sheets("MyOrigSheet(2)").Name = "MyNewSheet"

?

Thank you in advance.

Best Regards
Siri

--
SiriS
------------------------------------------------------------------------
SiriS's Profile: http://www.excelforum.com/member.php...fo&userid=7995
View this thread: http://www.excelforum.com/showthread...hreadid=509981

I work with excel 2000 files on several different computers - some using
Wndows XP and others still using Windows 98. I find that when opening a file
in Window 98 previously saved from another computer using Windows XP my
custom number and date formats are lost. I notice that Windows XP adds some
customised formats to Excel's default list of formats available - this never
happens under Windows 98.
Any light on this problem would be much appreciated.
--
Paul Fraser

Hello,
I have a problem in Excel 2000 during copying everything on a worksheet to antoher worksheet (values in cells and textboxes).

To avoid the run-time error 1004 (from Microsofts Knowledge Base-article - 177634) that occurrs if you copy the sheet over and over again, following code is used:

Sheets("MyOrigSheet").Visible = True
Sheets("MyOrigSheet").Select   

'Add new sheet
Sheets.Add Before:=Sheets(1)                     

'Copy cells but not drawingobjects from original sheet
Sheets("MyOrigSheet").Cells.Copy      

'Pasting cells on new sheet
Sheets(ActiveSheet.Name).Paste

'Copy drawingobjects (textboxes and buttons) from original sheet
Sheets("Sum per meas Grund").DrawingObjects.Copy  

Sheets(ActiveSheet.Name).Paste
 
Sheets(ActiveSheet.Name).Select
Sheets(ActiveSheet.Name).Name = "MyNewSheet"
Using Excel 2002 and Excel 2003 this works all fine. But not on Excel 2000.

Does not Drawingobjects exist in Excel 2000?

Do I have to check for version and then in case Excel 2000 use the following code instead:

Sheets("MyOrigSheet").Copy Before:=Worksheets(1)
Sheets("MyOrigSheet").Visible = False
Sheets("MyOrigSheet(2)").Select
Sheets("MyOrigSheet(2)").Name = "MyNewSheet"

?

Thank you in advance.

Best Regards
Siri

I would like the Excel 2000 sheetname to change as I change the filename
where I use a single worksheet.

Is it possible to change the background color(on selected cells) in the row and column headers in excel 2000? i.e. if I select cell A6 I want the background color "header" column A to be red and the background color in "header" row 6 to be red.

We encounter a strange problem with Excel (2000 and 2003):

In the standard Excel table done with Arial 10 the row height is 12.75
(17 Pixel). This applies to all my colleagues.

On my computer, however, I see a row height of 13.20 (20 pixel). We
didn't find the menue to change this general setting (the weak
workaround with the workbook causes a number of other problems).

Theirs - mine - Font setting
12.75 (17) - 13.20 (20) - Arial 10
12 (16) - 11.40 (19) - Arial 9
11.25 (15) - 10.20 (17) - Arial 8

As a result my Excel sheets never look&print the same on all the other
computers and so do their sheets on my computer.

Funny (I didn't believe my eyes):
If we de-install the driver for the graphics card running the computer
on it own ... the setting of the Excel is correct. As soon as we
re-install the graphics card driver software things are confused again.

Computer: Dell Latitude D820, graphics card nvidia Quatro NVS 120m
Same Windows, same Service Pack, same Patches,

Also those using the same computer with the same graphics card don't
have this problem ... !?

My IT-people are puzzled and Dell seems - as always - neither capable
nor willing to help (the computer is just a couple of month old)

Your help is much appreciated!

Nicolas

Hi, I'm new with Excel. I know a few simple formulas for operations on data, but have had little purpose for these so far. Most of what I do for now is to place engineering data into tables of presentable form, with more emphasis on making it practical for those in the field to use on a clipboard. One way in which I make a spreadsheet more useable is the insertion of blank, narrower lines between records (groups?), which typically cover several lines. I would have used a double-border in place of this, but it isn't heavy enough, so I formed my own version with narrow line-insertion, formatted with heavy borders top and bottom. Trying to do this for 80 or more records is a nightmare! Once I realized just how time-consuming this was, I sort of expected to find some syntax of general similarity to the forumulas which work conditionally on data value, but I have had no such luck finding anything which would so easily alter other cell attributes. Is there any formula syntax for non-data row/column/cell attributes? If not, I need some good clues on how to macro this, which I really haven't done anything with yet.

What I need is a formula or macro which can find all of the blank lines in a spreadsheet, and change the row height, at very least. I suppose from all the head-thrashing around Google that I may need to macro this, but if so which structures would be best, and where is all the cell-attribute syntax posted?

Please help if you can - thanks!

hey, can anyone help me ?

I copy and paste an Excel 2000 file into my computer (with nothing changed)
, and when i open and printed out the file document with Excel 2003, the font
size and lingement have changed? please help?

It's just another column.

Put some kind of indicator in that column (Yes/No, True/False, anything that
would indicate what you want to do later.)

Then sort your data (but include that column with the indicator in the range
sorted).

Now all your rowheights are mixed up. Select all the cells and autofit the
rowheights.

Filter by that helper column so that you only see Yes, True (or whatever).

Select those visible rows and adjust the rowheight (double it???).

Then data|filter|showall
(or remove the filter.)

(Hide or delete the helper column if you don't need it anymore.)

Michelle wrote:
>
> Hi Dave,
> Thanks for your post. I am having the same problem. Did not have this
> problem with previous version of Excel! Anyway...can you explain more about
> the helper row? I've used Excel for years but never heard of that.
>
> "Dave Peterson" wrote:
>
> > The rowheight stays with the row.
> >
> > If I had to do this, I'd add a helper cell per row -- some kind of indicator.
> >
> > then sort my data,
> > autofit all the rows
> > and look for that indicator and adjust the rowheight of those rows.
> >
> > tsysjohn wrote:
> > >
> > > I have set the row heights for the rows in my spreadsheet exactly as I want
> > > them - different rows have different heights. When I sort the spreadsheet,
> > > which I do every day or so, Excel changes some of the row heights. How can I
> > > prevent this?
> >
> > --
> >
> > Dave Peterson
> > >

--

Dave Peterson

If cells A1-C1 are merged and formatted to wrap text, but the amount of text
overflows to more than one row, i.e. requiring the text to wrap, the row
height doesn't auto-resize. Also, double clicking to adjust the row height
doesn't respect wrapped text. It is necessary to manually adjust the row
height - and even then if the row is instructed to set auto height - it
reverts to a single row of text, visually truncating the second and
subsequent rows. Excel ought to be able to correctly adjust row height.
Note: this problem has persisted through the last several versions of MS
Excel, all the way through my current MS Excel 2000.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

I developed a pretty complex workbook (20 worksheets, between 500 and 2000
rows per sheet, columns A to CZ), 95% of the formulae are arrayed {}.
The workbook has multiple switches, dropdown select menus, quite a number of
SUMPRODUCTs, OFFSETs, limited INDIRECT functions, the workbook has range
names for every input (cell/row).
The complete workbook takes 25 seconds to calculate in Excel 2003 (1.2 GHz
Pentium M), if you change all switches at once.
Excel 2000 takes forever for the exact calculation, even when I don't change
a single input, it sometimes takes 45 seconds, and freezes in 80% of the
times. The very first calculation (F9) after I open the file usually works
fine.

I'd highly appreciate some advice.

Hi All,

Every time I paste a table from Access to Excel, I have to reset the
row height to 12.75 (Excel automatically wraps text and makes each cell
three times its normal height). Is there any way that I can make this
height constant until I change it?

Thank you,
Sara

--
sara
------------------------------------------------------------------------
sara's Profile: http://www.excelforum.com/member.php...o&userid=24763
View this thread: http://www.excelforum.com/showthread...hreadid=383307

In an excel sheet I need the row heights to be 16.0. I select the rows and
go to Format, Row, Height and type 16.0. When I check the row height it will
be 16.2. I can take the cursor and try to change an individual row height
and it will let me choose 15.6 (26 Pixels) or 16.2 (27 Pixels). I have
changed the screen resolution and it did not help and I have tried to change
print resolution but am only given 600dpi as a choice.


No luck finding an answer? You could always try Google.