How to Set a 50 Percent Print Scale in Excel 2013

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 adjust the way that your data prints. One such tool is the print scale setting, where you can enter a percentage by which to grow or shrink your spreadsheet. Our […]

Free Guide – 7 Useful Excel Sheets to Instantly Improve Your Family’s Budget

Proper money management can go a long way in making sure that your family has budgeted correctly for monthly and daily expenses, while stillĀ putting some money into savings in the event of an emergency. If part of your New Year’s resolution involved getting a better handle on your budget, then simply getting started is one […]

How to Lock a Picture to a Cell in Excel 2011

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 need to move a row or column that contains pictures, you will probably run into a problem where the data in the row or column moves, but the pictures do […]

How to Remove Leading Spaces in Excel 2013

Last updated: January 19, 2017 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, and you can’t figure out why. Sorting data alphabetically is a very useful ability that can make the information in your Excel worksheet easier to […]

How to Create a New Worksheet in Excel 2013

A Microsoft Excel file is called a workbook, and a single workbook can contain multiple worksheets. This is helpful when you have a lot of data for a single purpose, but which may not necessarily belong on a spreadsheet together. Excel workbooks will typically include three worksheets by default, but that number can be modified […]

How to Add the Filename to the Header in Excel 2013

When you have a lot of printed spreadsheets lying around your workspace, it can be difficult to determine which file a spreadsheet came from. One helpful way to solve this problem is to include identifying information in the header section of your worksheets. An effective way to do this is by inserting the filename in […]

How to Only Display the Year for a Date in Excel 2013

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 storing dates in a spreadsheet will dictate the format that you select. But if the only important part of a date for your purposes is the year, then you might […]

How to Remove Gridlines in Excel 2013

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 to print gridlines in Excel 2013, but what if you have a spreadsheet where you wish to stop gridlines from printing? Or what if you want to remove the gridlines […]

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