Fill Handle in Excel

  powerless 16:02 07 Aug 2004

Where is it Vog?

I've highligted some cells but I'm bot seeing the fill handle.

  VoG II 16:05 07 Aug 2004

Hover the cursor over the bottom right corner of the last selected cell. The cursor should turn into a +

Then hold down the left mouse button and drag.

  stalion 16:12 07 Aug 2004

he's the man what would you do with out him useing Excel

  powerless 16:17 07 Aug 2004


But it didn't do what I wanted it to do or maybe I did it wrong?

I want a list of dates going all the way down in the format of [if possible]...

Monday 02/8/04

Tuesday 02/08/08

I though from reading the help files [I did read 'em honest] that using the fill handle would save me alot of typing.

Where I go wrong?

  VoG II 16:22 07 Aug 2004

You only need to enter the first date. So in a cell type in


then Format, Cell, select Date and the *Wednesday, 14 March 2001 option.

Then hover over the bottom right to get +, left click the mouse and drag down or across depending which way you want the list to go.

  ayrmail 17:31 07 Aug 2004


  powerless 17:36 07 Aug 2004

Right, that's working...But English (United Kingdom) did not give that option *Wednesday, 14 March 2001?

The trinidad one did?

2 More questions, is there a way for excel to expand all cells so that it fills a page of A4 because at the moment it's all small when it prints.

...and how do i get excel to print the cell lines [borders?], as it only prints the text.

  VoG II 17:43 07 Aug 2004

Look at File/Page Setup

On the Page tab, change the printed size and then use PrintPreview to make sure it is as wanted.

To get the gridlines to print, File/Page Setup, Sheet tab and tick Gridlines.

  powerless 17:52 07 Aug 2004


It all works :-))


VoG™ ;-))

  powerless 17:57 07 Aug 2004

Cells H2 to H31 are to be "added up" with the total in G32,33 and H32, H2 [I merged the cells].

From school i remeber =a1+a2+a2

There is an easier way i know, where would i find it?

  VoG II 18:22 07 Aug 2004

In the cell where you want the total (I'm a bit confused about that), enter the formula


This thread is now locked and can not be replied to.

Elsewhere on IDG sites

HTC U12 Plus review: Hands-on

Frida Kahlo's life, art and legacy explored in Google's new giant online collection and app

Best Android emulators for Mac

Comment importer des contacts d’un iPhone à un autre iPhone ?