See all How-To Articles This tutorial demonstrates how to delete Excel and Google Sheets worksheets. Delete WorksheetsSay you have the following Excel file with three worksheets (Sheet1, Sheet2, and Sheet3) and want to delete Sheet1 and Sheet3.
As a result, Sheet1 and Sheet3 are deleted, and only Sheet2 is left in the workbook. See also: VBA Delete or Clear Worksheet Delete Google SheetsTo delete worksheets in Google Sheets, follow the same steps. Overview of Excel MobileNot only can you edit Excel workbooks and templates created on your PC, you can create and edit workbooks and templates on your device with Excel Mobile.
When you close a newly created workbook, it is automatically named and placed in the Excel Mobile workbook list. You can easily rename the workbook with a more meaningful name and move it to another folder or a storage card. Tips Work in full-screen mode to see as much of your workbook as possible. Tap View > Zoom and select a percentage so that you can easily read the worksheet. See alsoCreate a chart Adjust column widths and row heights
Tip To specify an exact column width and row height, tap and hold the column or row, tap Format Cells and enter the measurements on the Size tab. See alsoApply cell borders Fit rows and columns to data Automatically calculate valuesYou can quickly calculate the largest number, smallest number, average number, and sum of the numbers in a selected range of values.
See alsoEnter a formula Automatically add values Automatically enter a sequence of values
Notes With Autofill you can quickly fill cells with repetitive data such as numbers or repeated text. Autofill takes the content of the first cell in the selected row or column and copies it down or across the rest of the selection. Tip To preserve memory, Fill is limited to an area of 127 rows by 31 columns. To copy information into more rows or columns, reduce the amount of information copied at one time and perform the fill procedure multiple times. See alsoCopy and paste data Enter a value or text in a cell Automatically add values
Notes Any time you change a value in the cells you originally selected to add, the sum will be updated. See alsoEnter a formula Copy and paste dataYou can copy data from one cell to another in an Excel Mobile workbook by using the Copy and Paste commands on the shortcut menu. In addition, you can do the following:
Tip To preserve memory, Paste is limited to an area of 127 rows by 31 columns. To copy information into more rows or columns, reduce the amount of information copied at one time and perform the copy and paste procedure multiple times. See alsoEnter a formula Automatically enter a sequence of values Delete cells, rows, or columns
Notes Excel Mobile keeps formulas up to date by adjusting references to the shifted cells to reflect their new locations. However, a formula that refers to a deleted cell displays the #REF! error value. See alsoAdjust column widths and row heights Enter a formula
See alsoRefer to a cell or range in a formula Enter a value or text in a cell
Notes To enter text, you may need to tap to display Input Panel.Tip To quickly edit cell contents, tap the cell and replace or edit the text or value. To undo an edit, tap Menu > Undo Typing in x. See alsoEnter a formula Format numbers and text Filter data in a worksheet
Notes The data in the top row of the selected cells or range of cells will not be filtered. The row should contain column headings. Tips To turn off AutoFilter, tap Tools > AutoFilter. To display all rows again, tap All in the filter list in each of the selected columns. See alsoSort data in a worksheet Fit rows and columns to data
See alsoAdjust column widths and row heights Format numbers and textYou can easily format numbers in an Excel Mobile workbook by assigning a numeric category such as number, currency, date, or fraction to a cell. You can also format text by changing the font type, size, or color, applying bold or italic formatting, and underlining text.
See alsoApply cell borders Position data in a cell Go to a cell or region
Notes The current region is defined as the block of filled-in cells that includes the currently selected cell or cells. The region extends in all directions to the first empty row or column. Tip To go to a specific cell, you can also enter the cell reference in the name box and then tap Enter. See alsoEnter a value or text in a cell Name a cell or range Hide and display rows and columns
See alsoAdjust the view of a worksheet Insert a function
Tip To learn about a function, review the information provided in the description area below the Function list. See alsoEnter a formula Enter a value or text in a cell Insert a symbol Insert cells, rows, and columns
Notes Excel Mobile keeps formulas up to date by adjusting references to the shifted cells to reflect their new locations. See alsoDelete cells, rows, or columns Enter a value or text in a cell Insert a symbol
Tips If you select a different font or subset, a different set of symbols displays. To use Microsoft Wingdings or Microsoft Webdings that are available on your PC, connect your device to your PC and open ActiveSync. Copy the Wingdings.ttf and Webdings.ttf files from the Font folder on your PC to the My Windows Mobile Device /Windows/Fonts folder in the ActiveSync window. For more information, see ActiveSync Help on the PC. See alsoEnter a value or text in a cell Enter a formula Insert a function Format numbers and text Name a cell or range
Tips To delete a name, tap Menu > Insert > Define Name, tap a cell name in the list, and tap Delete. To paste the list of cell names and their locations on the worksheet, tap Paste List. See alsoGo to a cell or region Refer to a cell or range in a formula Unsupported features in Excel MobileExcel workbooks created on your PC can be opened and edited on your device. However, Excel Mobile does not fully support some features such as formulas and cell comments. Some data and formatting may be lost when you save the workbook on your device. Note the following regarding these Excel Mobile formatting considerations:
See alsoOverview of Excel Mobile Unsupported features in Word Mobile Synchronizing documents, workbooks, and notes Refer to a cell or range in a formula
Tips To refer to a cell in another worksheet in your formula, enter the worksheet name followed by an exclamation point (!) and the cell, range, or name reference. Example: =Sheet1!Earnings To create a 3-D reference, in your formula, specify two or more sheets in a workbook; use a colon between the first and last worksheet names. Example: =SUM(Sheet2:Sheet6!$A$2:$C$5) See alsoEnter a formula Go to a cell or region Name a cell or range Sort data in a worksheetYou can sort data in ascending order (A-Z, or 0-9) or descending order (Z to A, or 9 to 0).
Tip To undo a sort, tap Menu > Undo Sort. See alsoFilter data in a worksheet Switch to another worksheet
See alsoMove a worksheet Rename a worksheet How do I...Set the default template Automatically save files on a storage card How do I...Enter a formula Enter a value or text in a cell Select a different chart type Add titles to a chart How do I...Zoom in or out How do I...Insert a symbol How do I...Insert a function How do I...Go to a cell or region How do I...Name a cell or range How do I...Sort data in a worksheet How do I...Automatically enter a sequence of values How do I...Rename a worksheet How do I...Insert a worksheet How do I...Insert a worksheet Rename a worksheet Delete a worksheet Move a worksheet How do I...Insert cells, rows, and columns How do I...Delete cells, rows, or columns How do I...Adjust column widths and row heights How do I...Format numbers and text How do I...Format numbers and text How do I...Apply cell borders How do I...Position data in a cell How do I...Find or replace text or data How do I...Copy and paste data How do I...Beam an item Open a file Automatically save files on a storage card Send an item via e-mail Move a file or note Delete an item Synchronizing documents, workbooks, and notes Overview of Excel Mobile How do I...Add titles to a chart Add a legend to a chart How do I...Change the scale of a chart How do I...Select a different chart type How do I...Add a data series Change data series names or legend text Change how a data series is displayed How do I...Add a data series How do I...Change data series names or legend text How do I...Change how a data series is displayed Position data in a cell
See alsoEnter a value or text in a cell Apply cell borders
Tip To fill a cell or range of cells with color, tap the arrow next to Fills and tap a color on the palette. See alsoAdjust the view of a worksheet Add titles to a chart
See alsoSelect a different chart type Add a legend to a chart Select a different chart typeYou can easily change the chart type to present your data in a different way.
See alsoAdd titles to a chart Change the scale of a chart Change the scale of a chart
See alsoAdd titles to a chart Select a different chart type Add a data seriesYou can add a data series to a chart without affecting the data on your worksheet.
Notes The name of the new series will appear in the chart legend. See alsoChange data series names or legend text Add titles to a chart Change data series names or legend text
Notes The updated series name will appear in the chart legend. See alsoChange how a data series is displayed Change the data series for a chart Change how a data series is displayedYou can change the color and style of lines, data markers, and fills in a chart.
See alsoAdd a data series Change data series names or legend text Adjust the view of a worksheetIn an Excel Mobile workbook, you can display and hide window elements such as scroll bars, view two areas of a worksheet and lock rows or columns in one area by splitting or freezing panes, and use the full screen to see as much data as possible.
See alsoAdjust column widths and row heights Zoom in or out Insert a worksheetAn Excel Mobile workbook contains three worksheets by default. You can easily add more sheets if you need them to help organize your data.
See alsoRename a worksheet Move a worksheet Delete a worksheetYou can delete a worksheet you no longer need from your workbook.
See alsoMove a worksheet Insert a worksheet Rename a worksheet Rename a worksheetWorksheets are named Sheet1, Sheet2, and so on, by default. You can easily rename the worksheets with meaningful names.
See alsoMove a worksheet Insert a worksheet Move a worksheetYou can easily change the order of sheets in your Excel Mobile workbook.
See alsoInsert a worksheet Rename a worksheet How do I...Create a chart How do I...Create a chart How do I...Create a chart How do I...Create a chart How do I...Create a chart Create a chart
See alsoAdd titles to a chart Change the scale of a chart Change the data series for a chartYou can edit the data series from a chart without affecting the data on your worksheet.
See alsoChange how a data series is displayed Add a data series Add a legend to a chart
See alsoSelect a different chart type How do I delete an Excel spreadsheet from my phone?You can delete a document, spreadsheet, or presentation from the Google Docs, Sheets, and Slides home screens.. On your Android phone or tablet, open the Google Docs, Sheets, or Slides app.. In the upper left, tap Menu .. Tap Trash.. Next to the file you'd like to delete, tap More .. Tap Delete forever.. How do I delete a tab in Excel app?Delete a worksheet. Right-click the Sheet tab and select. Delete.. Or, select the sheet, and then select Home > Delete > Delete Sheet.. How do you delete sheets in Excel iOS?Touch and hold the spreadsheet thumbnail, lift your finger, then tap Delete. To delete a spreadsheet shared with you by someone else (so that it can no longer be recovered), tap Delete Now.
How do I quickly delete a sheet in Excel?Alternatively, you can simply click on the sheet that you want to delete then click Alt + HDS. This will simply delete the current sheet.
|