Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 26th 06, 10:53 PM posted to microsoft.public.excel.misc
Debbie
 
Posts: n/a
Default can autofill be used on merged cells?

I would like to use the autofill function on a group of cells I've merged
together. It doesn't seem to be working. Is it possible for this to even
happen? I know if I unmerge my cells, I can use the autofill on a single
cell. But I would like to do this within a box I've merged together.


Thanks,

Debbie

  #2   Report Post  
Old June 26th 06, 11:04 PM posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default can autofill be used on merged cells?

Debbie

NO.

Merging 9 cells into one just creates one single cell that looks larger than the
regular cells, but has the same properties as a regular cell.

My advice about merged cells.........

Merged cells are the spawn of Satan!

They cause more problems with Excel than any other feature I can think of.

Copying, cutting, pasting, sorting, filtering are all adversely
affected by merged cells.


Gord Dibben MS Excel MVP

On Mon, 26 Jun 2006 14:53:02 -0700, Debbie
wrote:

I would like to use the autofill function on a group of cells I've merged
together. It doesn't seem to be working. Is it possible for this to even
happen? I know if I unmerge my cells, I can use the autofill on a single
cell. But I would like to do this within a box I've merged together.


Thanks,

Debbie


  #3   Report Post  
Old June 27th 06, 02:38 PM posted to microsoft.public.excel.misc
Debbie
 
Posts: n/a
Default can autofill be used on merged cells?

Bummer.

Thanks anyway.


"Gord Dibben" wrote:

Debbie

NO.

Merging 9 cells into one just creates one single cell that looks larger than the
regular cells, but has the same properties as a regular cell.

My advice about merged cells.........

Merged cells are the spawn of Satan!

They cause more problems with Excel than any other feature I can think of.

Copying, cutting, pasting, sorting, filtering are all adversely
affected by merged cells.


Gord Dibben MS Excel MVP

On Mon, 26 Jun 2006 14:53:02 -0700, Debbie
wrote:

I would like to use the autofill function on a group of cells I've merged
together. It doesn't seem to be working. Is it possible for this to even
happen? I know if I unmerge my cells, I can use the autofill on a single
cell. But I would like to do this within a box I've merged together.


Thanks,

Debbie





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
how do i link merged cells to a merged cell in another worksheet. ibbm Excel Worksheet Functions 3 April 27th 06 11:40 PM
Move merged cells with conditional formatting? SpikeUK Excel Worksheet Functions 11 December 8th 05 06:04 PM
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 05:57 PM
requires that merged cells must be identically sized? Catt Excel Discussion (Misc queries) 11 July 3rd 05 12:36 PM
Merged Cells TerryTutor Excel Discussion (Misc queries) 1 June 14th 05 05:17 AM


All times are GMT +1. The time now is 02:01 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017