#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 155
Default auto fill

I need to make a table with for 4 quarters (rows) and the months of the year
(columns). I am asked to use the auto fill function for the months of the
year but I can't seem to find where that is. Can someone tell me where the
"auto fill" function is or how to use it instead of having to type in all of
the months of the year.

Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 133
Default auto fill

Just write a month name in a cell, position the cursor on the bottom
right corner of the cell, click and drag down as far as needed.
HTH
Daniel

I need to make a table with for 4 quarters (rows) and the months of the year
(columns). I am asked to use the auto fill function for the months of the
year but I can't seem to find where that is. Can someone tell me where the
"auto fill" function is or how to use it instead of having to type in all of
the months of the year.

Thanks!



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 30
Default auto fill

Autofill is not a function you type in, but an action. You must enter your
first month (say January) and hit enter to complete your cell entry. Then
select the cell you just entered the month into and look in the lower right
corner - you should see a small square. Click and hold on this square and
drag across the columns - the months should autofill for you. If they don't,
once you've released the mouse button, you can click on a fly-out menu that
appears next to the last cell you dragged too - this will give you some
options.

Hope that helps.

CVinje
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
auto fill or auto search from a list or drop-down list??????? Joe H.[_2_] Excel Discussion (Misc queries) 9 August 29th 08 12:56 AM
Auto-populate, Auto-copy or Auto-fill? Jay S. Excel Worksheet Functions 4 August 10th 07 09:04 PM
Auto Fill Bee Excel Worksheet Functions 5 March 21st 07 10:53 PM
using auto fill edit or fill handel fill handle or auto fill Excel Worksheet Functions 0 February 10th 06 07:01 PM
Auto-fill doncalarco Excel Worksheet Functions 0 September 1st 05 06:38 PM


All times are GMT +1. The time now is 05:45 PM.

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

About Us

"It's about Microsoft Excel"