ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pointer Options (https://www.excelbanter.com/excel-discussion-misc-queries/71148-pointer-options.html)

Paul M

Pointer Options
 
If someone could help, it would be great.

I am using excel 2003, before I had 2000 and I was able to highlite a row of
cells we'll say half with numbers and the other half empty.

in 2000 I was able to select all of them and go to the lower right corner
and the pointer would turn into a "+" then the empty cells would auto fill
counting up or down.

My problem is that the "+" does not apear.

any ideas?

Thanks in advance

Chip Pearson

Pointer Options
 
Excel 2003 should work the same way. Be sure your cursor is
exactly on the little black square in the lower right corner of
the active cell.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Paul M" wrote in message
...
If someone could help, it would be great.

I am using excel 2003, before I had 2000 and I was able to
highlite a row of
cells we'll say half with numbers and the other half empty.

in 2000 I was able to select all of them and go to the lower
right corner
and the pointer would turn into a "+" then the empty cells
would auto fill
counting up or down.

My problem is that the "+" does not apear.

any ideas?

Thanks in advance




Paul M

Pointer Options
 
It is, the cursor does not change

"Chip Pearson" wrote:

Excel 2003 should work the same way. Be sure your cursor is
exactly on the little black square in the lower right corner of
the active cell.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Paul M" wrote in message
...
If someone could help, it would be great.

I am using excel 2003, before I had 2000 and I was able to
highlite a row of
cells we'll say half with numbers and the other half empty.

in 2000 I was able to select all of them and go to the lower
right corner
and the pointer would turn into a "+" then the empty cells
would auto fill
counting up or down.

My problem is that the "+" does not apear.

any ideas?

Thanks in advance





Pete_UK

Pointer Options
 
Click on Tools | Options | Edit (tab) and check "Allow cell Drag &
Drop".

Hope this helps.

Pete


Paul M

Pointer Options
 
Thanks Pete,

This was exactly what I needed A+

"Pete_UK" wrote:

Click on Tools | Options | Edit (tab) and check "Allow cell Drag &
Drop".

Hope this helps.

Pete



Pete_UK

Pointer Options
 
Thanks for the feedback, Paul.

Pete



All times are GMT +1. The time now is 07:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com