Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default increase data with cursor on cell bottom right corner

Hi,
I can't incremente cells data by setting the pointer on the bottom right
corner of the selected cell. The pointer doesn't change to allow to perform
such operation.
Pls give a hand.
Sabin.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default increase data with cursor on cell bottom right corner

Not too sure I understand the question but I will assume it is something
like:
You have a number (say 5) in a10 and you want a11:A20 to read 5, 6,7,8 ...
15

Method 1: enter 6 in A11; select A10 and A11; place the pointer over the
fill handle (lower right corner) of A11; drag down to A20

Method 2: select A10; use command Edit | Fill; specify Series; select
Columns and stop- number 15; click OK

best wishes (please return if I did not answer the question)
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Rohmann" wrote in message
...
Hi,
I can't incremente cells data by setting the pointer on the bottom right
corner of the selected cell. The pointer doesn't change to allow to
perform
such operation.
Pls give a hand.
Sabin.



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default increase data with cursor on cell bottom right corner

Choose ToolsOptions
On the Edit tab, add a check mark to Allow cell drag and drop

Rohmann wrote:
Hi,
I can't incremente cells data by setting the pointer on the bottom right
corner of the selected cell. The pointer doesn't change to allow to perform
such operation.
Pls give a hand.
Sabin.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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
When i highlight cells, I USED to get total in bottom rt corner? Barb B Excel Worksheet Functions 2 May 8th 06 02:02 PM
cursor shoots to a corner of the screen roger_home Excel Discussion (Misc queries) 0 April 20th 06 01:30 AM
Page #s and bottom corner dates have disappeared in printing. flowerpot Excel Discussion (Misc queries) 1 October 7th 05 08:07 PM
Missing Sum at Bottom Right Corner Ramrod Excel Discussion (Misc queries) 3 September 26th 05 07:24 PM
AutoFIll -by dragging the bottom-right corner of the cell Venkatesh V Excel Discussion (Misc queries) 5 February 23rd 05 04:57 PM


All times are GMT +1. The time now is 05:12 AM.

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

About Us

"It's about Microsoft Excel"