Access all In Easy Steps books for just £5 a month

In Easy Steps Articles

June 16, 2023

How to use the Fill function in Excel

You typed “January”, but the rest of the monthly headings can be automatically completed, using the Fill Handle to enter data, following the pattern it recognizes in your existing cell data:

1) Select the B2 cell with the “January” heading   

2) Move the mouse to the bottom-right corner of the cell to see the + Fill Handle appear   

3) Click the Fill Handle and drag over adjacent cells to select them, then release the mouse button to fill those cells

4) Click the Auto Fill Options button and change when necessary, to copy cell contents or to fill with or without formatting

Excel recognizes various entry types. If you start with “Jan” rather than “January”, adjacent cells fill with “Feb”, “Mar”, “Apr”, etc.

5) Select cell B4, and fill cells C4:G4 with a copy of B4. Repeat for B6 to C6:G6, and for B13 to C13:G13. Select the block of cells B8:B9, and fill cells C8:G9

 

You can also use the right-click menu to edit (cut/copy/delete) a selection of cells and to insert copied cells at another location. Just select the cell(s) with the mouse and right-click to see the options available.

 

 

 

Find more tips like this in:

Microsoft Excel in easy steps
ISBN: 9781840789966
By: Mike McGrath & Michael Price
£11.99 paperback / £6.99 ebook

 

 

 

 

Excel Functions & Formulas in easy steps
ISBN: 9781840788815
By: Michael Price
£11.99 paperback / £6.99 ebook

 

 

 

 

100 Top Tips – Microsoft Excel
ISBN: 9781840788792
By: Sean McManus
£5.99 paperback / £5.99 ebook

 

Sign up to our

Newsletter

Our newsletters inform you of new and forthcoming titles, handy tips, and other updates and special offers. You can opt out anytime.

"*" indicates required fields

By In Easy Steps Team

Share

We are sorry to let you go...

Would you mind giving us your feedback or reason of cancelling the subscription?

 

"*" indicates required fields

Hidden
Hidden
Hidden
Reason For Cancellation*
Hidden