The steps in this guide are going to show you how to copy a column in Excel. We will briefly cover this process at the top of the article, then continue below into more detail with pictures for each of the steps. Open your spreadsheet in Microsoft Excel. Click the letter at the top of […]

The steps in this article are going to show you where to find the button that opens the Watch Window in Microsoft Excel. We cover these steps briefly at the beginning of the article, then go more in depth below. Open Excel. Click the Formulas tab at the top of the window. Click the Watch […]

The steps in this guide will show you how to turn off a setting that is causing Excel to zoom in or zoom out whenever you scroll the wheel on your mouse. After the listing of steps at the top of this article we provide additional information and pictures for the steps further down. Open […]

This guide is going to show you how to change the settings for a picture in Microsoft Excel so that the picture doesn’t print. We will give a brief overview of the steps at the beginning of this article, then continue the article with additional information, as well as pictures for the steps. Open the […]

An important element of many spreadsheets is a row that displays the totals of your cell values. In a work environment, these totals are often critical pieces of information that will affect business decisions. You can create the values for these totals using a formula that lets you sum the values contained with the cells […]

Have you ever worked on a large spreadsheet where you needed to keep scrolling back up to the top of the sheet to make sure that you were looking at the right column? This can be frustrating and time-confusing, while also potentially leading to mistakes. Luckily you can fix this problem by learning how to […]

Adding text and numbers to cells in Microsoft Excel is typically as easy as clicking on a cell and typing. Things get a little more involved when you need to add a picture, or change the appearance of the text that you’ve added, but it’s still a very approachable task. But things can start to […]

Have you created a spreadsheet that contains formulas? And was everything looking how you would expect, with your formula results in their cells, but now you are seeing the formulas instead? This happens because of a setting that may have been changed inadvertently which causes Excel to display the formulas themselves, rather than their results. […]

Adding pictures to a spreadsheet can be important if you are sending a list of products to a potential customer and want them to see those products, or if you are creating a personal inventory and want a record of what the items in those inventory look like. Excel makes it easy for you to […]

There are a number of different ways that you can paste information that you have copied in Excel. You can paste data without any formatting, you can paste without borders, and you can even paste formulas that will update based on the cell you paste them into. But one of the other options you may […]