Home > In Excel > Unable To Delete Tab In Excel

Unable To Delete Tab In Excel

Contents

Unavailable feature Alternatives Create lists(list: A series of rows that contains related data or a series of rows that you designate to function as a datasheet by using the Create List To get replies by our experts at nominal charges, follow this link to buy points and post your thread in our Commercial Services forum! All rights reserved. References University of Wisconsin at Eau Claire: Delete Excel Tab Promoted By Zergnet Comments Please enable JavaScript to view the comments powered by Disqus. Check This Out

Similar Threads - {RESOLVED} Excel Can't Solved EXCEL: Hide/unhide rows with a cell double click LoiselleEER, Dec 20, 2016 at 8:25 AM, in forum: Business Applications Replies: 3 Views: 74 LoiselleEER You put me on a right track. You can record shared workbook operations into a macro stored in another nonshared workbook. Insert or change hyperlinks Existing hyperlinks continue to work.

Unable To Delete Sheet In Excel 2010

A message will pop up asking you to confirm the deletion of the sheet. Thread Tools Show Printable Version Subscribe to this Thread… Mark this thread as unsolved… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 04-30-2006,01:25 PM #1 TDiesel216 Guest can't You May Also Like How to Add or Delete an Excel Worksheet You can add as many worksheets as you like to a workbook.

  • Click any other tab to return to your file.
  • Use drawing tools You can view existing drawings and graphics.
  • and no the sheet is not protected.
  • Register Help Remember Me?
  • Does the application crash?
  • Here is the FAQ for this forum.

Note: To change the order of the worksheets in a workbook, click the tab of the worksheet that you want to move, and then drag it to the location that you want. Yes, my password is: Forgot your password? sheet protection would not do that, you would still be able to delete individual sheets. Can't Delete Sheet In Excel 2016 See More: unable to delete or add worksheets in an Excel spreadsheet Report • ✔ Best Answer Scorpion99 March 14, 2013 at 08:20:13 From did you get this file?It might be

This thread popped up within the first 10 results of Google for my search terms. Delete Sheet Greyed Out Excel 2013 Add or change data validation Cells continue to be validated when you type new values, but you can't change existing data validation settings. Any help you can offer is much appreciated! On the Home tab, in the Cells group, click the arrow next to Delete, and then click Delete Sheet.

Right-click the sheet tab of a worksheet, and then click Insert. How To Enable Delete Sheet Option In Excel 2007 Speed issue in huge files Is where any option not to scale header and footer while printing Calc sheet (like in Msoffice)?) [closed] does libreoffice have a "signature line" feature for Stay logged in Sign up now! How to select worksheets To select Do this A single sheet Click the sheet tab.

Delete Sheet Greyed Out Excel 2013

If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.Would you like to participate? https://social.technet.microsoft.com/Forums/office/en-US/e4955199-430e-45a1-a95d-20f6a4c1f5f4/cannot-delete-s-sheet-in-excel-2010-share-file-sent-from-home-thanks?forum=excel As is Move/Copy. Unable To Delete Sheet In Excel 2010 Here is a list of all the features which are not enabled in a shared wb: Features that are unavailable in shared workbooks You can Excel Delete Sheet Greyed Out Does nothing happen?What steps are you trying and what happens when you try those steps.?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code. Report •

All sheets in a workbook Right-click a sheet tab, and then click Select All Sheets on the shortcut menu. his comment is here Kind of like Wikipedia. Note: Custom templates are automatically saved in the Templates folder. Register Help Forgotten Your Password? How To Delete A Worksheet In Excel 2010

Answer:You can view all of the sheet names as tabs along the bottom of the document. Click on the Delete button to continue. Saturday, September 18, 2010 2:57 PM Reply | Quote 1 Sign in to vote The problem is its a Shared Workbook. http://brrian.net/in-excel/unable-to-delete-worksheet-in-excel-2010.html Tip    When multiple worksheets are selected, [Group] appears in the title bar at the top of the worksheet.

Databases SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL SQLite MS Office Excel Access Word Web Development HTML CSS Color Picker Languages C Language More ASCII Table Linux UNIX Java Unable To Delete Sheet In Excel 2016 Register To Reply 11-13-2013,01:13 AM #10 arlu1201 View Profile View Forum Posts Administrator Join Date 09-09-2011 Location Bangalore, India MS-Off Ver Excel 2003 & 2007 Posts 19,227 Re: can't delete worksheet--grayed I was mucking around with embedding this spreadsheet in a Visio page but is wasn't working so I deleted the link (I think) If I go to Share Workbook the only

Cheers, Shane Devenshire Marked as answer by Sally Tang Monday, September 20, 2010 7:01 AM Saturday, September 18, 2010 11:33 PM Reply | Quote All replies 0 Sign in to vote

When creating a new spreadsheet, Excel users can add a new tab to display each new type of data. Under Excel, click Options. leafgroup.com © 1999-2016 Leaf Group Ltd. Can't Delete Worksheet In Excel 2016 You must type uppercase and lowercase letters correctly when you set and enter passwords.) Existing passwords remain in effect.

Create a VBA sub with these three lines of code...after it runs the problem should be solved. Are there ways to find out if the spreadsheet is corrupted? Workbook is not Protected, nor Shared. navigate here Can anyone explain?

Though the individual sheets had been password protected they are no longer. Tech Support Guy is completely free -- paid for by advertisers and donations. The time now is 02:10 PM. Share it with others Like this thread?

If I have helped, Don't forget to add to my reputation (click on the star below the post) Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) Use How to Delete a Sheet if It Is Grayed Out in Excel 2007 Normally, when you right-click a sheet tab at the bottom of an Excel workbook, you have the option See in Thread ↓#1 DerbyDad03 March 13, 2013 at 10:34:37 It might help if you explained what happens when you try to "delete a sheet; add a sheet; or hide or Click Save.

This can happen in one workbook, and it will disable it for ALL Excel workbooks (in other words the entire application). Report • Related Solutions› How to set up VBA form in Excel to input food order? › [Solved] How to use to macro insert row into new worksheet in Excel. › Be sure to delete worksheets that you're no longer using,... Place your cursor on the tab you wish to delete.

On the Home tab, in the Cells group, click Insert, and then click Insert Sheet. Is there any code running that might disable that menu option? Register To Reply 09-18-2013,12:58 PM #8 kris75 View Profile View Forum Posts Registered User Join Date 12-21-2009 Location North East, England MS-Off Ver Excel 2003 Posts 2 Re: can't delete worksheet--grayed Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote May 11th, 2004,11:30 AM #6 ColsHub New Member Join Date May 2004 Posts 6 Re: Can't delete worksheet "it

May 19, 2015 by asanchez192.