Excel Tips Tutorial: How to Enter Credit Card Numbers In Excel
Excel Tips Tutorial: How To Make Gantt Chart in Microsoft Excel
Excel Tips Tutorial: Pivot Tables
Excel For Noobs Tutorial: How to use IF function for logical calculation
Excel For Noobs Tutorial: How to use data filtering in MS Excel
Excel Tips Tutorial: How to Use Concatenate Function to Join Cells Together
Excel For Noobs Tutorial: How to create graphs in Excel
Excel Tips Tutorial: How to Insert Cells in Data Tables in MS ExceI
Excel Tips Tutorial: How to Convert Values From One Measurement System to Another
Excel Tips Tutorial: How to Convert Numbers to Text
Excel Tips For Noobs: How To Add Diagonal or Crossed Lines to a Cell
Excel Tips Tutorials: How to Make A Pie Chart in Microsoft Excel
Excel Tips: How to Solve Circularity Errors With Iterations
Excel Tips Tutorial: How To Use Vlookup in Microsoft Excel
Excel Tips Tutorial: How to use SUMIF, COUNTIF and AVERAGEIF Functions in Microsoft Excel
Excel Tips Tutorial: How to Use Conditional Format in Microsoft Excel
Excel Tips Tutorial: How to Connect Links to Excel Worksheets
Excel Tips Tutorial: How To Write Formulas In Excel
Excel Tips Tutorial: How to Find and Replace Values in Microsoft Excel
Excel Tips Tutorial: VBA Visual Basic for Application For Beginners in Microsoft Excel
Excel Tips Tutorial: How to Use Trim, Upper, Lower and Proper In Microsoft Excel
Excel Tips Tutorial: How to Convert a PDF File to Editable Excel File
Excel Tips Tutorial: How to Use Pivot Tables in Microsoft Excel
Excel Tips Tutorial: How to Find and Select Content or Cells in Excel
Excel Tips Tutorial: How to Merge Styles and Themes of Old and New Excel Versions 2003 2007 2010 2013
Excel Tips Tutorial: Microsoft Excel Keyboard Shortcuts
Excel Tips Tutorial: How to Draw a Line Through a Word in Excel - Strikethrough
Excel Tips Tutorial: Horizontal Text Alignment in Excel (General, Left, Center, Right, Fill, Justify, Center across Selection and Distributed)
Excel Tips Tutorial: Vertical Alignment in Excel (Top, Center, Bottom, Justify, and Distributed)
Excel Tips Tutorial: How to Display Text at a 45 Degree Angle (Diagonal Text)
Excel Tips Tutorial: How to add a Background Image (Picture) to an Excel Worksheet
Excel Tips Tutorial: How to Use Format Painter to Copy and Paste Cell Formats
Excel Tips Tutorial: How to Use Cell Styles to Format Cells
Excel Tips Tutorial: How to Change the Default Style of an Entire Excel Workbook Using Cell Styles
Excel Tips Tutorial: How to Create Your Own New Cell Style in Excel
Excel Tips Tutorial: Understanding and Applying Themes in Excel
Excel Tips Tutorial: How to Pin Important Excel File to the Recent Files List
Excel Tips Tutorial: How to Add Folders to the Favorites List in the Open Dialog Box
Excel Tips Tutorial: How to Save Excel Workbook Files
Excel Tips Tutorial: How to Change the Default File Type to Save Excel Workbooks
Excel Tips Tutorial: How to Open and Recover an Unsaved Excel File
Excel Tips Tutorial: Rules for Filenames in Microsoft Excel
Excel Tips Tutorial: How to Print Only an Excel Chart without Printing out the Entire Worksheet
Excel Tips Tutorial: How to Remove Formula Error-Checking Smart Tags
Excel Tips Tutorial: How to Stop Automatically Creating Calculated Columns in Excel Tables
How to Name an Excel Table
Excel 2013 Tutorial: How to Refer to a Named Cell as a Constant
Excel Concatenate Function Tutorial - How to Join Text in Excel
How to Use If Else If Function in Excel 2013 - Nested If Function in Microsoft Excel
Excel Worksheets Tutorial for Microsoft Excel 2013
Absolute, Relative and Mixed Cell Reference Excel Tutorial
Excel 2013 Tutorial Creating and Opening Workbooks in Excel 2013
Excel 2013 Tutorial The Function Library
How to Share Workbooks in Excel 2013 Tutorial
Save and Save As Excel 2013 Tutorial
How to Recover Unsaved Files in Excel 2013 with the Auto Saved Feature
How to Export Excel Files to PDF Other Different File Types
Basic Excel 2013 Functions Tutorial
Excel Tutorial How to Use Nested Functions
How to Use GoTo Special in Microsoft Excel 2013 Tutorial
Excel Page Layout Tutorial
Microsoft Excel Tutorial Page Breaks, Headers and Footers
Excel 2013 Tutorial How to Format Fonts in Excel
How to Create a Custom List in Excel Tutorial
Data Validation Microsoft Excel 2013 Tutorial - How to Restrict Entering Data in a Cell
Understanding Excel Charts Tutorial
How to Create a Basic Chart in Excel Step by Step Tutorial
How to Create and Use a Pivot Table in Microsoft Excel 2013 - Excel Pivot Table Tutorial
How to Pivot Data with Excel Pivot Tables Tutorial
How to Create a Macro in Microsoft Excel 2013
Microsoft Excel 2013 Worksheet Template Tutorial How to Create
Drop Down Lists Tutorial in Excel 2013
How to Reference Formulas and Data on other Excel Worksheets Worksheets Microsoft Excel 2013 Tutorial
Excel Data Forms Tutorial Microsoft Excel 2013
How to Insert Drawing Objects into your Excel Spreadsheets Microsoft Excel 2013 Tutorial
Excel LOOKUP Function Tutorial Microsoft Excel 2013
Excel Workbook and Worksheet Objects Tutorial
Excel Tutorial: Variables in Microsoft Excel Visual Basic Application (VBA)
Excel VBA Tutorial: If Then and Else Statement in Microsoft Excel (VBA) Visual Basic Application
Excel Events Tutorial: Visual Basic Application Evens in Microsoft Excel 2013
Excel For Noobs Tutorial: Excel Worksheet Operations (Adding, Editing, Deleting, Hiding and Protecting)
Worksheets are excellent tools for organizing your data because you can separate different types of data instead of placing everything on a single worksheet. For example, if you were tracking the performance of several items, you could use a single worksheet for each item, and then another worksheet to summarize the overall performance of all your items.
Adding a New Worksheet
To add a worksheet there will be a button to the right of the worksheet tabs. If you press this button a new worksheet will be added. You can also press Shift+F11 to insert a new sheet before the sheet that is activated. Another way to add a new sheet is to right click on a sheet tab, click Insert and then select what you want to insert from the Insert dialog box. This method allows you to enter other workbooks, templates such as time cards, invoices and other templates from Office.com.
If you want to delete a worksheet in your workbook you can right click the sheet tab and select Delete from the shortcut menu.
Another method is to use the Delete command which is located in the Home ribbon under the Cells group.
If you want to delete multiple sheets you need press CTRL, select all the sheets you want to delete and then follow the steps above.
Naming a Worksheet
To name or rename your worksheet right-click the worksheet tab, select rename from the short-cut menu and then type in the new name.
You can also double-click the worksheet and Excel will allow you to rename your worksheet.
Worksheet Tab Color
Some people like to color code their worksheets. To do this, right-click the tab, select Tab Color from the shortcut menu and then select the color of your preference.
Changing the Default Sheet Setting
You may want to change the number of sheets Excel opens by default. In Excel 2010 by default Excel opens a workbook with 3 sheets. For many workbooks only one sheet is necessary, and if more are needed you can just add them. To change the default number of worksheets:
Click File then Options and the Excel Options dialog box will appear. In General enter the default number of sheets you prefer where it says Include This Many Sheets and click OK.
Copying and Moving Worksheets
You can also copy and move worksheets in the current workbook or in a different or new workbook. To move or copy a worksheet right-click the worksheet tab and select Move or Copy to access the Move or Copy dialog box. Use this box to make your commands.
To move a worksheet in its current workbook you can also click on the worksheet tab and drag it to the location you prefer.
To make a copy of a worksheet click and drag the worksheet while pressing CTRL.
You can move and copy multiple worksheets simultaneously by pressing CTRL to selecting multiple sheets.
Protecting Your Workbook and Worksheets
If you want to prevent someone from making changes to your workbook or to specific worksheets you can do this by requiring users to enter a password before making changes to your workbook or worksheet. This could be a very useful tool if you have employees working on a computer where Excel files can be accessed or within a workbook where certain sheets need to be protected.
To prevent others from making structural changes to you workbook such as adding, deleting and moving sheets, you can use the protect workbook command. Click the Review tab, then in the Changes group click on the Protect Workbook Command, make sure that the Structure box is checked, enter a password and press OK, then re-enter your password in the Confirm Password dialog box and click OK.
Now to make structural changes the workbook will have to be unlocked with the password. To do this simply click on the Protect Workbook command and enter your password.
You may also have worksheets within a workbook that you want to protect from others. By using the Protect Worksheet command you can keep others from making changes by disabling certain commands or keep others from making any changes at all.
Click the Review tab, then click Protect Sheet and the Protect Sheet dialog box will appear. Make sure the Protect worksheet and contents of locked cells box is check, and then check the commands you want to allow users to perform without unprotecting the worksheet. Now enter your password and click OK, then reenter your password in the Confirm Password dialog box and click OK.
There may be some worksheets that you don’t want others to see. If this is the case you can hide worksheets. Right click the worksheet and select Hide from the shortcut menu. If you want to unhide the worksheet simply click on any worksheet tab and select Unhide. From the Unhide dialog box select the sheet that you want to unhide.
Making a Worksheet Very Hidden
You can also make a worksheet “very hidden” where it can’t simply be unhidden using the Unhide Dialog box.
Step 1: Activate your worksheet
Step 2: Click the Developer tab, then in the Controls group click on Properties. The Properties dialog box will appear.
Step 3: In the Visible box click on the drop-down arrow and select 2 – xlSheetVeryHidden.
Now your worksheet is “very hidden” and will not appear in the Unhide Dialog Box.
How to Unhide a Very Hidden Worksheet
Step 1: Press Alt+F11 to activate the Visual Basic Editor.
Step 2: Locate and select the sheet that is “very hidden” and then press F4. The properties box will appear.
Step 3: In the Visible box click on the drop-down menu and select -1 – xlSheetVisible.
Find the next tutorial in the links below.