LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 16th 05, 08:05 PM
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.

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

All times are GMT +1. The time now is 10:59 PM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017