How to Change the Default Paper Size in Excel 2010

Excel printing problems come in a number of shapes and sizes. Whether you have a column that keeps trying to fit on its own page, or the spreadsheet is using way more paper than it should, finding the proper formatting can be a frustrating endeavor. But if you find that you print a lot of […]

How to Change the First Page Number in Excel 2010

It is helpful to add page numbers to your Excel 2010 worksheet if there are a lot of pages, or if you think it is likely that the pages might become separated. But if your worksheet is part of a larger printed document, then it could be confusing to the reader if the page numbers […]

How to Make Page Layout the Default View in Excel 2010

Excel 2010 has a handful of different views that you can select between when viewing the data in a spreadsheet. We have previously shown you how to switch to the “Page Layout” view in the program, but that method will only allow you to change the view for the current sheet. If you create a […]

How to Turn Off the Auto Fill Options Button in Excel 2010

The Auto Fill feature in Microsoft Excel 2010 is very useful when you need to fill a series of cells with a series of numbers. In fact, it can be a real time-saver when you need to number rows in a spreadsheet.   But the Auto Fill feature often includes a pop-up Auto Fill Options […]

How to Enter Data Into Multiple Worksheets at the Same Time in Excel 2010

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 if you need to add the same data to each of those worksheets, then it can be tedious to do so individually. Excel has a feature that allows you to group […]

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 so that our data can be displayed how we prefer it. One commonly adjusted formatting setting is that which is applied to dates that have been entered into cells. Excel […]

How to Display or Hide the Fill Handle in Excel 2010

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 with a sequence. This can save you a lot of time, and it can help to avoid mistakes. This functionality is made possible with the help of the Fill Handle, […]

Why is My Worksheet Backwards in Excel 2010?

Did you open a file in Excel 2010 and the row numbers were at the right side of the worksheet, and the column letters were in the reverse order? This happens because a setting in the Excel options menu called “Show sheet right to left” has been turned on. This can be a frustrating change to […]

How to Hide Page Breaks in Excel 2010

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 typically appear after you have switched views for your worksheet, and have returned to the Normal view. These page breaks can be distracting or confusing, which can lead you to look […]

Fill a Selection of Cells With the Same Value in Excel 2010

It is very common when working with spreadsheets in Microsoft Excel to have one value that repeats among a high number of cells. Whether it is a price that is common to a high number of products, or simply putting the number “0” into a lot of cells that do not have a value, you […]