Welcome to my Excel 2010 Workbook Tutorials. Here is a list of all the Excel 2010 Workbook Tutorials I have created so far.
Showing posts with label Excel Workbook. Show all posts
Showing posts with label Excel Workbook. Show all posts
How to Encrypt a Workbook with a Password
In this tutorial I will teach you how to encrypt a workbook with a password.
By encrypting a workbook with a password you can make Excel users to enter a password to open your workbook. This allows you to control who can open your workbook.
For this tutorial you will need to have a workbook already open within Excel 2010.
Step 1: Open File Menu
Step 2: Select Info Tab
This will open the Encrypt Document Window. This is where you decide what password will be used to open your workbook.
Notice this window warns you that if you forget your password, it can not be recovered.
Step 5: Enter a Password into Encrypt Document Window
Notice you will see 4 black dots represents your password, but Excel hides the actual values so no one can watch you type it in.
If you select Cancel the Encrypt Document Window will close and you will return to the Info Tab located on the File Menu.Step 6: Select OK
The Confirm Password Window will open.
If you select Cancel the Confirm Password Window will close and the Encrypt Password Window will reopen.
Step 7: Reenter Password into Confirm Password Window
Step 8: Select OK
If you don't enter the same password that you entered into the Encrypt Document Window then you will be prompted with the following popup.
If you see this pop up then just select OK and you will return to Confirm Password Window.
If you entered the same password that you entered into the Encrypt Document Window then you have successful Encrypted your workbook with a password. You will see the following on the Info Tab, located within the File Menu.
Congratulations, you have encrypted your workbook with a password. For a list of all my workbook tutorials feel free to check out my Workbook Tutorials.
How to Create an Excel 97-2003 Workbook
Welcome to my Workbook Tutorials.
Step 1: Begin by opening Excel 2010.
In this Tutorial I will teach you how to create an Excel 97-2003 Workbook within Excel 2010.
An Excel 97-2003 Workbook is used to allow users to be able to open the workbook with Excel 97 – Excel 2003 versions.
Step 1: Begin by opening Excel 2010.
If you already have Excel 2010 open you don't need worry about opening it again.Step 2: Save the workbook as Excel 97-2003 Workbook
Open File menu.
Select Save (This will open the Save As window).
Select File Address.
Enter File Name.
Change the Save As Type to Excel 97-2003 Workbook.
Select Save.Congratulations. You have created an Excel 97-2003 Workbook. For a complete list of all my macro tutorials open Workbook Tutorials.
How to Create a Binary Workbook
Welcome to my Workbook Tutorials.
Step 1: Begin by opening Excel 2010.
In this Tutorial I will teach you how to create a Binary Workbook within Excel 2010.
A Binary Workbook is used to allow for a large amount of data to be entered into the workbook. A binary workbook also allows users to store macros within the workbook. The main reason to not use a binary workbook is if there is possibility that someone with an earlier version of Excel may try to open that workbook. Some versions of Excel will not open a binary workbook.
Step 1: Begin by opening Excel 2010.
If you already have Excel 2010 open you don't need worry about opening it again.Step 2: Save the workbook as Excel Binary Workbook
Open File menu.
Select Save (This will open the Save As window).
Select File Address.
Enter File Name.
Change the Save As Type to Excel Binary Workbook.
Select Save.Congratulations. You have created a Binary Workbook. For a complete list of all my macro tutorials open Workbook Tutorials.
How to Create a Macro-Enabled Workbook
Welcome to my Tutorials.
In this Tutorial I will teach you how to create a Macro-Enabled Workbook within Excel 2010.
A Macro-Enabled Workbook is used when the user wants to create and use macros within their workbook.
Step 1: Begin by opening Excel 2010.
If you already have Excel 2010 open you don't need worry about opening it again.Step 2: Create a macro
Technically you don't need a macro to create a Macro-Enabled Workbook. However, why would you make it Macro-Enabled if you had no macros?Step 3: Save the workbook as Macro-Enabled Workbook
For the purpose of this tutorial I will assume that you already know how to create a macro. If you need help creating a macro feel free to read my How to Create a Macro tutorial.
Now that we have Excel 2010 open and have created a macro we are ready to save the workbook as a Macro-Enabled Workbook.
Open File menu.
Select Save (This will open the Save As window).
Select File Address.
Enter File Name.
Change the Save As Type to Macro-Enabled Workbook.
Select Save.Congratulations. You have created a Macro-Enabled Workbook. For a complete list of all my macro tutorials open Workbook Tutorials.
How to Create an Excel Workbook
Welcome to my Excel Workbook Tutorials. In this tutorial I will teach you how to create a new Excel workbook within Excel 2010.
Step 1: Open the File Menu.
Step 2: Select New from the File Menu.
Congratulations. You have created an Excel workbook using Excel 2010. Feel free to view the more of my Excel 2010 Workbook Tutorials.
Step 1: Open the File Menu.
File Menu Location
Step 2: Select New from the File Menu.
You should see the following window now.
Notice the the File Menu is still open to the left and New is highlighted green. This just shows that right now you have the new workbook command selected. To the right of the File Menu you will see the new workbook options. For the purpose of this tutorial you don't need to know the purpose of every option within this section.Step 3: Double click Blank Workbook.
Congratulations. You have created an Excel workbook using Excel 2010. Feel free to view the more of my Excel 2010 Workbook Tutorials.
Subscribe to:
Posts (Atom)







