Deleting a worksheet you no longer need

If you no longer need a worksheet, or if you want to get rid of an empty worksheet in a workbook, you can delete it in either of two ways:

  • Right-click the sheet tab and choose Delete from the shortcut menu.
  • Choose Home?Cells?Delete?Delete Sheet. If the worksheet contains any data, Excel asks you to confirm that you want to delete the sheet. If you’ve never used the worksheet, Excel deletes it immediately without asking for confirmation.

You can delete multiple sheets with a single command by selecting the sheets that you want to delete.

To select multiple sheets, press Ctrl while you click the tabs for the sheets that you want to delete. To select a group of contiguous sheets, click the first sheet tab, press Shift, and then click the last sheet tab. Then use either method to delete the selected sheets.

Add to Technorati Favorites


// Related Posted - GOOGLE!

Loading



Related Websites
No comments yet.

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>