View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Autofilter in Excel

Remove the merged cells and put the value in each row???

If you want to try, then visit Debra Dalgleish's site for a way to fill empty
cells from the value in the cell above.

http://contextures.com/xlDataEntry02.html

JsiPxi wrote:

Because I have merged some cells over 2 rows, when I try and autofilter them,
only half the row of data comes up. How can I stop this from happening?


--

Dave Peterson