How to Remove Strikethrough in Excel 2010

Text formatting effects like bold, italic, and underline can be useful when displaying data in Excel. But if some of your data has a line through it, then you may be looking for a way to remove strikethrough in Excel. The strikethrough effect in Microsoft Excel 2010 is helpful when you wish to indicate that […]

How to Remove a Password from an Excel 2010 Spreadsheet

Locking a worksheet in Excel can be a useful tool depending on how that worksheet is being shared. But someone viewing a locked spreadsheet might need to edit it, so it’s helpful to know how to remove a password in Excel 2010. Microsoft Excel files are often shared between students and colleagues who are attempting […]

How to Create a Drop-Down List in Excel 2010

Creating a drop down list in Excel 2010 is something that seems like it should be fairly simple, as its a helpful item to have, and there are a lot of uses for it. But if you’ve ever tried to make a dropdown in Excel, then you may have found that it’s a little more […]

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