| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dragging a cell
Hi,
I am unable to drag a cell down. I have checked automatic under tools, options, calculations. My problem is I am unable to get a + sign when I take the mouse near the edge of a cell to be dragged. Pl help. krishna |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dragging a cell
Hi there Sai
Hope this will help; On the menu select TOOLS, then OPTIONS, on the next pop up window find the EDIT TAB, then make sure that the ALLOW CELL DRAG AND DROP checkbox is enabled. Select OK or APPLY when done. Good luck... "Sai Krishna" wrote: Hi, I am unable to drag a cell down. I have checked automatic under tools, options, calculations. My problem is I am unable to get a + sign when I take the mouse near the edge of a cell to be dragged. Pl help. krishna |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dragging a cell
Hi Mark, thanks a ton. Didn't know the existence of this option!! regards krishna "Markv" wrote: Hi there Sai Hope this will help; On the menu select TOOLS, then OPTIONS, on the next pop up window find the EDIT TAB, then make sure that the ALLOW CELL DRAG AND DROP checkbox is enabled. Select OK or APPLY when done. Good luck... "Sai Krishna" wrote: Hi, I am unable to drag a cell down. I have checked automatic under tools, options, calculations. My problem is I am unable to get a + sign when I take the mouse near the edge of a cell to be dragged. Pl help. krishna |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dragging a cell
Glad I could help "Sai"
"Sai Krishna" wrote: Hi Mark, thanks a ton. Didn't know the existence of this option!! regards krishna "Markv" wrote: Hi there Sai Hope this will help; On the menu select TOOLS, then OPTIONS, on the next pop up window find the EDIT TAB, then make sure that the ALLOW CELL DRAG AND DROP checkbox is enabled. Select OK or APPLY when done. Good luck... "Sai Krishna" wrote: Hi, I am unable to drag a cell down. I have checked automatic under tools, options, calculations. My problem is I am unable to get a + sign when I take the mouse near the edge of a cell to be dragged. Pl help. krishna |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dragging a cell
When you have a few minutes spare time, browse through the ToolsOptions Tabs
You will see all kinds of things that affect your functionality. Gord Dibben MS Excel MVP On Mon, 23 Jun 2008 02:11:00 -0700, Sai Krishna wrote: Hi Mark, thanks a ton. Didn't know the existence of this option!! regards krishna "Markv" wrote: Hi there Sai Hope this will help; On the menu select TOOLS, then OPTIONS, on the next pop up window find the EDIT TAB, then make sure that the ALLOW CELL DRAG AND DROP checkbox is enabled. Select OK or APPLY when done. Good luck... "Sai Krishna" wrote: Hi, I am unable to drag a cell down. I have checked automatic under tools, options, calculations. My problem is I am unable to get a + sign when I take the mouse near the edge of a cell to be dragged. Pl help. krishna |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dragging a cell
Sure, will do so.
regards krishna "Gord Dibben" wrote: When you have a few minutes spare time, browse through the ToolsOptions Tabs You will see all kinds of things that affect your functionality. Gord Dibben MS Excel MVP On Mon, 23 Jun 2008 02:11:00 -0700, Sai Krishna wrote: Hi Mark, thanks a ton. Didn't know the existence of this option!! regards krishna "Markv" wrote: Hi there Sai Hope this will help; On the menu select TOOLS, then OPTIONS, on the next pop up window find the EDIT TAB, then make sure that the ALLOW CELL DRAG AND DROP checkbox is enabled. Select OK or APPLY when done. Good luck... "Sai Krishna" wrote: Hi, I am unable to drag a cell down. I have checked automatic under tools, options, calculations. My problem is I am unable to get a + sign when I take the mouse near the edge of a cell to be dragged. Pl help. krishna |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dragging a cell
I'm so glad I read this, as I was having the same problem. Is there a way to
do this for the entire Excel application, rather than file by file? It seems all of my excel files have lost this ability. Thanks, bjb55 "Markv" wrote: Hi there Sai Hope this will help; On the menu select TOOLS, then OPTIONS, on the next pop up window find the EDIT TAB, then make sure that the ALLOW CELL DRAG AND DROP checkbox is enabled. Select OK or APPLY when done. Good luck... "Sai Krishna" wrote: Hi, I am unable to drag a cell down. I have checked automatic under tools, options, calculations. My problem is I am unable to get a + sign when I take the mouse near the edge of a cell to be dragged. Pl help. krishna |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dragging Cell References/Formulas | Excel Worksheet Functions | |||
| Dragging a formula with cell references | Excel Discussion (Misc queries) | |||
| Dragging & incrementing cell values | Excel Worksheet Functions | |||
| copy one to cell to another by clicking and dragging | Excel Worksheet Functions | |||
| Dragging cell data | Excel Discussion (Misc queries) | |||
![Sai Krishna[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
