Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 16th 05, 09:05 PM
Elaine
 
Posts: n/a
Default AutoFill Visible Cells with Months

I would like to type Jan in A2 and AutoFill up to however far the selection
goes. However, there are some rows that are hidden. I am not able to autofill
the visible cells in the selection.

What I have done is:
Type Jan in A2
Select area to be filled
Select visible cells (by pressing F5 and clicking Special Cells)
EDIT | Fill | Series | Autofill

I get some weird results. Can anyone please help me get Jan, Feb etc with
only the visible cells filled so that there are no skipped months where there
are hidden rows.

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
Visible cells Melissa Excel Worksheet Functions 0 February 15th 05 08:23 PM
Select Visible Cells Only Apparently Excel Discussion (Misc queries) 2 January 29th 05 01:40 AM
Copy & Paste Visible Cells with Formulas Ricky Excel Worksheet Functions 5 January 27th 05 06:37 PM
SUMPRODUCT TO CALCULATE VISIBLE CELLS ONLY Lisa Excel Worksheet Functions 4 January 11th 05 01:58 PM
Autofill skipping cells Carla Bradley Excel Worksheet Functions 1 November 8th 04 07:20 PM


All times are GMT +1. The time now is 07:31 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017