ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   shifting cells disabled. (https://www.excelbanter.com/excel-discussion-misc-queries/262408-shifting-cells-disabled.html)

Menotti2

shifting cells disabled.
 
I am failing to drag or shift cells/rows/columns in my excel worksheet. I
have reinstalled MS office XP ,but it did not help me. What should I do?


Jacob Skaria

shifting cells disabled.
 
Check out the options under 'Edit' tab from menu ToolsOptions

If that doesnt help post back elaborating the problem

--
Jacob (MVP - Excel)


"Menotti2" wrote:

I am failing to drag or shift cells/rows/columns in my excel worksheet. I
have reinstalled MS office XP ,but it did not help me. What should I do?


Mike H

shifting cells disabled.
 
Hi,

E2003
Tools-Options-Edit tab- Select Allow cell drag & drop.

E2007
Office Button-Excel Options-Advanced- Select ' Enable fill handle and cell
drag & drop"
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Menotti2" wrote:

I am failing to drag or shift cells/rows/columns in my excel worksheet. I
have reinstalled MS office XP ,but it did not help me. What should I do?



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

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