Skip to content
Solve Your Tech
Menu

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.

clear the rules from an entire sheet in microsoft excel 2010

How to Clear Rules From Entire Sheet in Excel 2010

Last Updated On June 13, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel How-To Guides, Worksheets
how to stop excel 2010 from changing numbers to dates

Why Does Excel Keep Changing My Numbers to Dates?

Last Updated On June 30, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel How-To Guides, Worksheets
how to create a named range in google sheets

How to Create a Named Range in Google Sheets

Last Updated On May 30, 2023 by Matthew Burleigh

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, …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Worksheets
uncheck the show sheet right to left option

Why is My Worksheet Backwards in Excel 2010?

Last Updated On July 5, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Columns, Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Worksheets
enter the new name for the worksheet tab

How to Rename a Worksheet Tab in Excel 2013

Last Updated On June 12, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Worksheets
select a sheet, then click OK

How to Unhide a Worksheet in Excel 2010

Last Updated On June 19, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Worksheets
click the print selection button

How to Print Part of a Worksheet in Excel 2013

Last Updated On June 19, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Printing, Worksheets
how to delete a worksheet in excel 2010

How to Delete a Sheet in Excel 2010

Last Updated On June 29, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Worksheets
click the page layout tab

Why Isn’t My Entire Spreadsheet Printing in Excel 2010?

Last Updated On July 20, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Worksheets
click the custom header button

How to Add Same Header to All Sheets in Excel 2013

Last Updated On July 5, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Header, Microsoft Excel 2013, Microsoft Excel How-To Guides, Workbooks, Worksheets
smaller image of blank Excel worksheet

What is the Difference Between a Workbook and a Worksheet in Excel 2010?

Last Updated On July 28, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Workbooks, Worksheets
how to create a new worksheet in excel 2013

How to Insert a New Worksheet in Excel 2013

Last Updated On July 20, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Worksheets
click the text box button

How to Make a Text Box in Excel 2010

Last Updated On July 1, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Worksheets
how to merge cells in google sheets

How to Merge Cells in Google Sheets

Last Updated On June 30, 2023 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Featured Sheets, Google Sheets How-To Guides, Worksheets
How to Insert Excel Into Word 2016

How to Insert Excel Into Word 2016

Last Updated On June 18, 2023 by Matthew Burleigh

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. …

Read More

Categories Programs Tags Microsoft Excel How-To Guides, Microsoft Word How-To Guides, Worksheets
How to Stop Freezing Rows in Google Sheets

How to Stop Freezing Rows in Google Sheets

Last Updated On May 30, 2023 by Matthew Burleigh

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. …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Rows, Worksheets
3 Ways to Create a New Worksheet in Google Sheets

3 Ways to Create a New Worksheet in Google Sheets

Last Updated On August 22, 2023 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Worksheets

How to Lock Cells in Google Sheets

Last Updated On July 20, 2023 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Worksheets
how to delete a comment in google sheets

How to Remove Comments from Google Sheets

Last Updated On June 30, 2023 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Worksheets
how give worksheet different name excel 2013

Can I Name a Worksheet Something Other Than Sheet1, Sheet2, etc in Excel 2013

Last Updated On June 13, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Worksheets
how to delete all comments in excel 2013

How to Delete All Comments from a Worksheet in Excel 2013

Last Updated On June 5, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Worksheets
why are column labels numbers instead of letters in excel 2013

Why Are My Column Labels Numbers Instead of Letters in Excel 2013?

Last Updated On June 22, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Worksheets
insert a comment in excel

How to Insert a Comment in Excel 2013

Last Updated On June 29, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Worksheets
how to format as date only in excel 2013

How to Only Display the Year for a Date in Excel 2013

Last Updated On July 5, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Worksheets
how to remove gridlines in excel 2013

How to Remove Gridlines in Excel 2013

Last Updated On June 8, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Worksheets
view list of worksheets in excel 2013

How to View a List of Worksheets in Excel 2013

Last Updated On June 1, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Worksheets
how to unhide a worksheet in excel 2013

How to Unhide a Worksheet in Excel 2013

Last Updated On May 30, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Worksheets
insert from file, then click browse

How to Insert an Excel Spreadsheet Into Powerpoint 2013

Last Updated On July 18, 2023 by Matthew Burleigh

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, …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Microsoft Powerpoint 2013, Microsoft Powerpoint How-To Guides, Worksheets
excel 2010 dates as weekdays

How to Format Dates as Days of the Week in Excel 2010

Last Updated On June 9, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Worksheets
click the worksheet tab, then click rename

How to Rename a Worksheet in Google Sheets

Last Updated On July 5, 2023 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Worksheets
click the sheet name button

How to Put the Worksheet Name in the Footer of an Excel 2010 Worksheet

Last Updated On July 21, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Worksheets
locate the worksheet tabs

How to Add a New Worksheet in Excel 2010

Last Updated On June 1, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Worksheets
type the new worksheet name

How to Change a Worksheet Name in Excel 2010

Last Updated On June 16, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Worksheets
click the format painter button

Copy Cell Formatting from One Cell to Another in Excel 2010

Last Updated On May 30, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Worksheets
click the format button

How to Show Hidden Cells in Excel 2013

Last Updated On June 30, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Worksheets
right-click the tab that you want to delete, then click delete

How to Delete a Worksheet Tab in Excel 2013

Last Updated On July 17, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Worksheets
how to sort by date in excel 2010

How to Sort by Date in Excel 2010

Last Updated On July 1, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Worksheets
how to remove cell formatting in excel 2013

Removing Cell Formatting in Excel 2013

Last Updated On May 31, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Worksheets
how to change the date format in Excel 2010

How to Change the Date Format in Excel 2010

Last Updated On June 8, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel How-To Guides, Worksheets
display more decimal places in Excel 2010

How to Display More Decimal Places in Excel 2010

Last Updated On May 30, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Worksheets

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

  • iPhone
  • iPad
  • Apple Watch
  • Google Docs
  • Google Sheets
  • Google Slides
  • Google Chrome
  • Microsoft Excel
  • Microsoft Outlook
  • Microsoft Powerpoint
  • Microsoft Windows
  • Microsoft Word
  • Firefox
  • Photoshop
  • Gmail
  • Amazon Fire TV
  • Google Drive
  • Microsoft Edge

info@solveyourtech.com
4845290651
2138 W. Union Blvd.
#1037
Bethlehem, PA 18018
United States

  • SolveYourTech YouTube
  • SolveYourTech Facebook
  • SolveYourTech Instagram
  • SolveYourTech Twitter
  • SolveYourTech Pinterest
  • SolveYourTech LinkedIn
  • SolveYourTech TikTok
  • Newsletter
  • Affiliate Disclaimer
  • Terms of Use
  • Privacy Policy
  • Contact
  • About Us
© SolveYourTech.com 2023
  • Featured
  • Categories
    • Article Topics
    • Application Guides
    • Device Guides
    • Reviews
  • Programs
    • Excel
    • Outlook
    • Powerpoint
    • Windows
    • Word
  • Devices
    • iPhone
    • iPad
    • Apple Watch
    • Fire TV
  • Web Apps
    • Chrome
    • Docs
    • Sheets
    • Slides
  • Store