Fill Handle in Excel

  powerless 16:02 07 Aug 04
Locked

Where is it Vog?

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

  VoG II 16:05 07 Aug 04

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 04

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

  powerless 16:17 07 Aug 04

Fantastic...

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 04

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

2/8/04

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 04

oh

  powerless 17:36 07 Aug 04

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 04

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 04

Resolved...

It all works :-))

TY!!!

VoG™ ;-))

  powerless 17:57 07 Aug 04

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 04

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

=SUM(H2:H31)

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

Amazon Fire HD 8 review: A brilliant combination of function and value – with one massive caveat

1995-2015: How technology has changed the world in 20 years

How to create an introvert-friendly workplace

Apple Watch 2 review | Apple Watch Series 2 review: New Apple Watch is faster, brighter, water-resit…