myKontera

script type text/javascript > var dc_UnitID 14; var dc_PublisherID 95319; var dc_AdLinkColor blue ; var dc_adprod ADL ; var dc_OPEN_new_win yes ; /script> script type text/javascript SRC http://kona.kontera.com/javascript/lib/KonaLibInline.js > /script>

Excel :Deleting a Worksheet

To delete a worksheet, right-click the sheet tab and choose Delete from the menu that appears. If the sheet you want to delete contains data (or if you delete all the data on a sheet in the current session), Excel asks you to confirm the fact that you want to delete the sheet. Every workbook must contain at least one sheet, so if you try to delete the only sheet, Excel complains.


To select multiple sheets to delete, press Ctrl while clicking the sheet tabs 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.

After you delete a worksheet, it’s gone for good. This operation is one of the few in Excel that you can’t undo. Therefore, you may want to save a workbook before deleting worksheets. Then, if you inadvertently delete a worksheet, you can revert to the saved version.

Bookmark and Share

Excel : key combinations to perform editing

After you’re in edit mode, you can use any of the following keys or key combinations to perform your edits:

  1. Left arrow/right arrow: Moves the cursor left or right one character,respectively, without deleting any characters.
  2. Ctrl+left arrow/Ctrl+right arrow: Moves the cursor one group of characters to the left or right, respectively.
  3. Shift+left arrow/ Shift+right arrow: Selects characters to the left or right of the cursor, respectively.
  4. Shift+Home: Selects from the cursor to the first character in the cell.
  5. Shift+End: Selects from the cursor to the last character in the cell.
  6. Backspace: Erases the character to the immediate left of the cursor.
  7. Delete: Erases the character to the right of the cursor or erases all selected characters.
  8. Insert: Places Excel in OVR (overtype) mode. Rather than adding characters to the cell, you overtype, or replace, existing characters with new ones,depending on the position of the cursor.
  9. Home: Moves the cursor to the beginning of the cell entry.
  10. End: Moves the cursor to the end of the cell entry.

Bookmark and Share
 

Social Bookmarker