Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
dcleesfo
 
Posts: n/a
Default I can't delete columns - help!

This is strange. For some reason, I no longer can delete columns (or rows).
The "Delete" option under Edit doesn't appear anymore. In searching to
figure out what was wrong, I noticed that "Columns" and "Rows" are no longer
an option under Format. Anyone have any clue as to what I did to make this
happen?
  #2   Report Post  
bj
 
Posts: n/a
Default

Is this with all menu items showing
<View<Toolbars<Customize<options. Select always show full menus
if it still does not show
goto
<View<Toolbars<Toolbars
got to the bottom of the screen and select Worksheet menu bar and then click
on reset
"dcleesfo" wrote:

This is strange. For some reason, I no longer can delete columns (or rows).
The "Delete" option under Edit doesn't appear anymore. In searching to
figure out what was wrong, I noticed that "Columns" and "Rows" are no longer
an option under Format. Anyone have any clue as to what I did to make this
happen?

  #3   Report Post  
_Jonah
 
Posts: n/a
Default

Right click on a toolbar, select customise, go to the left side and click on
Edit. Then add the Delete option to the Edit menu on the toolbar by dragging the
Delete option to the Edit menu and as it drops down, then place it wherever you
wish and release your mouse button. Close the dialogue box.

NB Email address is Spam proofed if repying.

Jonah
---------------

The "Delete" option under Edit doesn't appear anymore. In searching to
figure out what was wrong, I noticed that "Columns" and "Rows" are no longer
an option under Format. Anyone have any clue as to what I did to make this
happen?


  #4   Report Post  
dcleesfo
 
Posts: n/a
Default

Thanks, bj:

That was the problem!



"bj" wrote:

Is this with all menu items showing
<View<Toolbars<Customize<options. Select always show full menus
if it still does not show
goto
<View<Toolbars<Toolbars
got to the bottom of the screen and select Worksheet menu bar and then click
on reset
"dcleesfo" wrote:

This is strange. For some reason, I no longer can delete columns (or rows).
The "Delete" option under Edit doesn't appear anymore. In searching to
figure out what was wrong, I noticed that "Columns" and "Rows" are no longer
an option under Format. Anyone have any clue as to what I did to make this
happen?

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
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns Sam via OfficeKB.com Excel Worksheet Functions 4 July 14th 05 09:15 PM
Hidden Columns in Shared Workbooks Rotary Excel Discussion (Misc queries) 1 July 9th 05 12:28 AM
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns foofoo Excel Discussion (Misc queries) 1 April 2nd 05 12:02 AM
how do i delete the extra empty rows and columns that i dont need. lindaY Excel Discussion (Misc queries) 3 March 20th 05 03:48 PM
Counting the Contents of Two Columns Molochi Excel Discussion (Misc queries) 6 December 22nd 04 08:13 PM


All times are GMT +1. The time now is 06:48 PM.

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

About Us

"It's about Microsoft Excel"