How to Unlock Protected Spreadsheets: A Step-by-Step Guide
Unlocking a protected spreadsheet can seem daunting, but it’s actually a straightforward process. All you need is the password for the file, and you’ll be …
Worksheets
How-to guides and tutorials about topics related to worksheets that you create and edit in spreadsheet applications like Microsoft Excel or Google Sheets.
How to Clear Rules From Entire Sheet in Excel 2010
The conditional formatting feature in Microsoft Excel can be a very helpful feature for identifying and sorting data. But if something changes, or you are …
Why Does Excel Keep Changing My Numbers to Dates?
Occasionally you might enter data into one of your cells in Excel, only to find that Excel has converted that number to a date. This …
How to Create a Named Range in Google Sheets
You can create a named range in a Google spreadsheet by selecting the cells for the range, clicking the Data tab and choosing Named ranges, …
Why is My Worksheet Backwards in Excel 2010?
Microsoft Excel has a couple of different potential layouts, though many people will only ever see one. A layout option that can be really confusing …
How to Rename a Worksheet Tab in Excel 2013
Do you find that you need to click on a couple of different worksheet tabs before you find the right one? This is a pretty …
How to Unhide a Worksheet in Excel 2010
Did you previously hide a worksheet because it contained important information that you didn’t want anyone to edit? Or perhaps you simply have too many …
How to Print Part of a Worksheet in Excel 2013
It’s really easy to make a mistake when you are trying to print an Excel spreadsheet. But even if you have gone through and made …
How to Delete a Sheet in Excel 2010
New Microsoft Excel files often contain a couple of blank tabs where you can add data. But if you only need one tab for your …
Why Isn’t My Entire Spreadsheet Printing in Excel 2010?
If you have finished creating or editing a spreadsheet in Microsoft Excel and then gone to print it out, you might find that it hasn’t …
How to Add Same Header to All Sheets in Excel 2013
When you want to make the same change to multiple cells in a Microsoft Excel worksheet, then you can usually do so by selecting all …
What is the Difference Between a Workbook and a Worksheet in Excel 2010?
Have you seen the terms “worksheet” and “workbook” a lot when reading about Microsoft Excel? They may seem like the same thing, or at least …
How to Insert a New Worksheet in Excel 2013
Taking advantage of the ability to have multiple sheet tabs in Microsoft Excel is a great way to keep similar types of data organized. For …
How to Make a Text Box in Excel 2010
Adding text boxes in Microsoft Excel may seem odd, considering the layout of a spreadsheet and the way that the application is generally. But you …
How to Merge Cells in Google Sheets
A standard cell layout in Google Sheets is going to include a series of rows and columns that contain one cell in each column for …
How to Insert Excel Into Word 2016
The steps in this article are going to show you how to embed an existing Microsoft Excel spreadsheet into a document in Microsoft Word 2016. …
How to Stop Freezing Rows in Google Sheets
You can unfreeze a row in Google Sheets by selecting the View tab at the top of the window, choosing Freeze, then clicking No Rows. …
3 Ways to Create a New Worksheet in Google Sheets
When you create a new workbook file in Google Sheets, it will have one worksheet tab by default. In many cases, this is going to …
How to Lock Cells in Google Sheets
Occasionally when you have a cell or range of cells in a spreadsheet it contains data or a formula that can never change. As the …
How to Remove Comments from Google Sheets
When you give permission to someone else to work on a spreadsheet in Google Sheets, you will both be able to leave comments that are …
Can I Name a Worksheet Something Other Than Sheet1, Sheet2, etc in Excel 2013
Excel files are often referred to a spreadsheets, but they are actually files called workbooks, and they can contain multiple spreadsheets within them. These spreadsheets …
How to Delete All Comments from a Worksheet in Excel 2013
We have previously written about how to delete a comment in Excel 2013 when you have a specific comment in a spreadsheet that you no …
Why Are My Column Labels Numbers Instead of Letters in Excel 2013?
If your Microsoft Excel application has column numbers instead of letters, then you may be wondering not only how that happened, but how you can …
How to Insert a Comment in Excel 2013
Sometimes a cell in an Excel worksheet requires a bit of explanation. But it may not be feasible to include that explanation in the cell …
How to Only Display the Year for a Date in Excel 2013
There are a lot of different options when it comes to formatting a date in Excel, and the variety of reasons that you might be …
How to Remove Gridlines in Excel 2013
One of the most common changes made to Excel spreadsheets that are going to be printed is the addition of gridlines. We have discussed how …
How to View a List of Worksheets in Excel 2013
Using multiple worksheets within an Excel 2013 workbook is common when you have a lot of data that you want to keep in the same …
How to Unhide a Worksheet in Excel 2013
It’s common to hide a worksheet in Excel 2013 if it contains information that should not be edited, if the data on the sheet isn’t …
How to Insert an Excel Spreadsheet Into Powerpoint 2013
Excel spreadsheets can be an effective way to communicate data in a Powerpoint presentation, but switching between multiple files is not an ideal solution. Fortunately, …
How to Format Dates as Days of the Week in Excel 2010
Data that is entered into the cells of a worksheet in Microsoft Excel 2010 can take many forms. Fortunately, Excel also offers multiple formatting choices …
How to Rename a Worksheet in Google Sheets
Large workbooks often have multiple worksheets contained within them, as it is usually more convenient to contain related information entirely within one file. The default …
How to Put the Worksheet Name in the Footer of an Excel 2010 Worksheet
If you have ever printed a lot of different similar-looking reports, then you know how helpful it can be to have those reports include identifying …
How to Add a New Worksheet in Excel 2010
The Microsoft Excel files that you have saved on your computer, and that you occasionally share with work colleagues or teachers, have file names with …
How to Change a Worksheet Name in Excel 2010
Splitting data up into individual worksheets in a Microsoft Excel file is an efficient way to organize information. It also prevents you from needing to …
Copy Cell Formatting from One Cell to Another in Excel 2010
Cell formatting, much like the formulas that you use within those cells, is an important element of how data in an Excel 2010 spreadsheet is …
How to Show Hidden Cells in Excel 2013
Excel workbook creators often hide rows or columns that contain irrelevant information, or information that is not important for the task that is currently being …
How to Delete a Worksheet Tab in Excel 2013
Large spreadsheets and excessive requests for edits can leave you swimming in data in your Excel workbook. Once you have finalized the file and are …
How to Sort by Date in Excel 2010
Arbitrarily searching for data in Microsoft Excel 2010 can be very time-consuming, especially when the fields that you need to locate are not listed anywhere …
Removing Cell Formatting in Excel 2013
Large Excel files can be difficult to read, especially when they contain a lot of data, only some of which might be relevant to a …
How to Change the Date Format in Excel 2010
Microsoft Excel 2010 is pretty good at recognizing data that fit into certain criteria and converting that data to the appropriate format. One case where …
How to Display More Decimal Places in Excel 2010
Learning how to increase the number of decimal places in Excel 2010 is important for anyone that is working with spreadsheets where two decimal places …