Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 17th 05, 04:13 PM
WSCI-Nathan
 
Posts: n/a
Default cell height changing when using autofill

Hey everyone, been experiencing a very frustrating problem the past couple of
days. I am using excel to make invoices for print. I am using it for this
becasue I can print them in sequential numbers. My problem is that I am
trying to copy the entire page and autofill it down a few times, but on the
autofilled pages the cell heights of a few of the cells changes on me and
messes up the entire job. I'm not understanding why it is doing this becasue
I have it set to autofill the cell formatting as well as contents. Any
suggestions?

  #2   Report Post  
Old January 17th 05, 11:26 PM
Dave Peterson
 
Posts: n/a
Default

I couldn't get the rowheights to change (xl2002).

If you're dragging down the range while holding onto the autofill button (bottom
right corner of the cell), maybe just rightclicking and dragging, then choosing
"fill without formatting" would work for you.

If this isn't close, you may want to post more details on how you did the
autofill.

WSCI-Nathan wrote:

Hey everyone, been experiencing a very frustrating problem the past couple of
days. I am using excel to make invoices for print. I am using it for this
becasue I can print them in sequential numbers. My problem is that I am
trying to copy the entire page and autofill it down a few times, but on the
autofilled pages the cell heights of a few of the cells changes on me and
messes up the entire job. I'm not understanding why it is doing this becasue
I have it set to autofill the cell formatting as well as contents. Any
suggestions?


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing cell references Tracey Excel Discussion (Misc queries) 4 January 4th 05 08:05 PM
changing the value of each cell in a range by a certain percentage Aaron Excel Discussion (Misc queries) 5 December 15th 04 10:30 PM
Changing Cell Fill Colour Nick Excel Discussion (Misc queries) 4 December 6th 04 10:05 PM
autofill according to cell index. honour Excel Discussion (Misc queries) 1 December 2nd 04 01:49 PM
CELLS HAVING SAME NUMBER BY CHANGING ANY CELL JOHN MORREY Excel Discussion (Misc queries) 2 December 2nd 04 02:50 AM


All times are GMT +1. The time now is 04:56 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017