ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Right click delete options (https://www.excelbanter.com/excel-discussion-misc-queries/179922-right-click-delete-options.html)

LDP Analyst[_2_]

Right click delete options
 
When I right click a cell in Excel 2003, the options I get are to Delete Row
or Column. I want to only delete cell and then move up/left. This works in
other excel files - just not thise one. is there a way to reset this?

Dave Peterson

Right click delete options
 
I bet you're looking at filtered data.

Data|Filter|Show all

then try it.

LDP Analyst wrote:

When I right click a cell in Excel 2003, the options I get are to Delete Row
or Column. I want to only delete cell and then move up/left. This works in
other excel files - just not thise one. is there a way to reset this?


--

Dave Peterson

LDP Analyst[_2_]

Right click delete options
 
Yes, I am! Thanks so much! Once I realized that I could work around it by
showing the filters.

"Dave Peterson" wrote:

I bet you're looking at filtered data.

Data|Filter|Show all

then try it.

LDP Analyst wrote:

When I right click a cell in Excel 2003, the options I get are to Delete Row
or Column. I want to only delete cell and then move up/left. This works in
other excel files - just not thise one. is there a way to reset this?


--

Dave Peterson



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

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