How to Hide Sheet Tabs in Excel 2010

Microsoft Excel separates its worksheets via a tab system that you can find at the bottom of the window. Use these steps to hide sheet tabs in Excel 2010. Open your Excel file. Click File at the top-left. Select Options at the bottom-left. Choose the Advanced tab. Click the box to the left of Show […]

How to View a Google Calendar File in Excel

Google Calendar is a great app that you can use on your computer, phone, and tablet. By simply signing into your Google account on multiple devices you can manage your calendar and get alerts when you have an upcoming event. But you may wish to backup or otherwise interact with your Google Calendar in Microsoft […]

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 […]