How to Copy a Worksheet in Excel 2013
I’ve created many Excel workbooks that contain multiple copies of the same worksheet. Whether the workbook is for a weekly or monthly report where each …
Articles to help you answer questions and fix problems that you might be having with different versions of the Microsoft Excel spreadsheet application.
Not sure where to start? Check out our featured Microsoft Excel guides below:
I’ve created many Excel workbooks that contain multiple copies of the same worksheet. Whether the workbook is for a weekly or monthly report where each …
Microsoft Excel has a variety of different view settings that you can customize to change the appearance of your data. Including among these options is …
When entering data into a spreadsheet in Microsoft Excel 2013, it is not uncommon to have blank spaces that are missing data. On small spreadsheets, …
Excel 2013 has a lot of helpful tools and tricks that you can use to find information about data contained in a worksheet. One of …
Comments in Microsoft Excel 2013 allow you to identify a problem or question that you have about data in a cell without affecting the data …
There are many ways to store data in Excel spreadsheets, and one common choice is placing each piece of data in a separate column. This …
Excel 2013 has an AutoComplete option that can be turned on or off depending on individual user preference. So if you use Excel 2013 on …
There are many reasons why you might insert a picture into an Excel 2013 worksheet, but you may find that the picture is problematic when …
Excel spreadsheets that span multiple pages can be difficult to read on the printed page. Fortunately, Excel has several tools that you can use to …
Occasionally you will need to add a picture to a spreadsheet, or someone will send you a spreadsheet with pictures in it. But if you …
You might discover that you need to know how to remove leading spaces in Excel when you have data that is difficult to work with …
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 …
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 …
Most workbooks in Microsoft Excel 2013 will include three worksheets by default. Using multiple worksheets within an Excel workbook is helpful when you have a …
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 …
It’s helpful to know how to remove indent in Excel when you encounter a spreadsheet where many of the cells have an unwanted space at …
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 …
The navigation within the Microsoft Excel 2013 program is centered around a series of tabs at the top of the window. Each of these tabs …
The default behavior for page numbering in Excel 2013 is to number the first page of the spreadsheet as “1”, then continue increasing that number …
While you may have already figured out how to change the height of a row or the width of a column by dragging their borders, …
Microsoft Excel files are workbooks that can contain individual worksheets within them. You can learn more about the difference between workbooks and worksheets here. You …
There are some things that you take for granted in applications like Microsoft Excel that you use all the time. One of those things is …
Occasionally you might need to do something a little unusual in an Excel spreadsheet. This could mean adding a shape or an object or even …
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, …
Formatting is a crucial part of working in Microsoft Excel, and Excel 2003 users often use different types of formatting to make their data easier …
There are a lot of different formatting choices that you can make for the data in your Excel 2013 worksheets. Whether you wish to format …
Separating data into multiple worksheets within a workbook can be helpful in a lot of situations for which you would use Microsoft Excel 2010. But …
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 …
It is a common thing in Excel 2010 to fill a group of cells with the same value, or to fill a group of cells …
Occasionally your Microsoft Excel 2010 worksheet will show a series of black dotted lines that indicate the page breaks for the worksheet. These page breaks …
The print resolution that is specified by a document or image on your computer can have a big impact on both the quality of the …
When the cells in a Microsoft Excel worksheet are nearly filled with similar data, it can be difficult to read and understand the information contained …
Sometimes the amount of data in a spreadsheet can be so overwhelming that you have difficulty focusing on the important parts. This might have led …
File that you create in Microsoft Office programs, such as Microsoft Excel, include information that describes the file. This information is called metadata and can …
When you discover an error in Microsoft Excel, and that error is part of a formula, then the level of difficulty in resolving the problem …
Microsoft Excel 2010 will automatically include page breaks in your printed worksheet based on your paper size and margins. Unfortunately these page breaks do not …
A new, blank worksheet in Microsoft Excel consists of a series of cells that are split into rows and columns. You can visually distinguish these …
A worksheet that you print in Microsoft Excel 2010 will not include gridlines by default. However, many people adjust the settings of their worksheets to include …
Microsoft Excel windows can easily become cluttered, which can make it difficult to concentrate on the task you are trying to complete. One way to …
A common way to format a spreadsheet is to include a row of cells at the top or a column of cells at the left …
If you have ever run into issues with cell references in Excel formulas, then you may be looking for another way to use them. Or …
When you create a new text box in your Microsoft Excel 2010 worksheet, it will have a border. Typically this border is dark grey and …
Highly customized spreadsheets in Microsoft Excel often go through several different versions before they are finalized and ready to be used or seen by their …
Unhiding the first column, or column “A” in an Excel spreadsheet presents a unique challenge. The typical method for unhiding a column will not apply …
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 …
Microsoft Excel 2010 can do a lot of different things, leading many users to take advantage of the program whenever possible. But there are certain …
The Normal view in Microsoft Excel 2010 is simply a large, continuous grid of cells that are organized into rows and columns. This view makes …
When you are working on a spreadsheet in Microsoft Excel 2010, the focus is usually on the data that you are adding, and the information …
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 …
The navigational system in Microsoft Excel 2013 is based around a ribbon of tools and options at the top of the window. Different settings and …