Sometimes a spreadsheet that you are trying to print in Microsoft Excel 2011 is going to have one too many rows or columns to naturally fit on one page. You can attempt a couple of different options to resolve this problem, but there is actually an option in Excel 2011 specifically meant to handle this … Read more
Microsoft Excel workbooks can often contain important or sensitive data that you may not want anyone with the file to be able to see. One way that you can help to protect that data is by adding a password to the file. Our tutorial will show you how to protect a workbook in Excel 2011 … Read more
The cells in a Microsoft Excel spreadsheet can have som many different formats applied to them that you could spend several minutes trying to get rid of all of them individually. This is not only frustrating and time-consuming, it’s also prone to error. Our tutorial below will show you how to clear all cell formatting … Read more
When you work with bigger spreadsheets, it can be difficult to remember what data goes in which column. If you have been scrolling all the way back up to check the header row, then you have probably discovered how annoying that can be. Our tutorial below will show you how to freeze the top row … Read more
Do you want to print some of the data in your Excel spreadsheet, but you don’t want to waste ink or paper printing a lot of things that you don’t need? While you may have experimented with hiding rows or columns, that can be tedious, and you may need to undo it each time you … Read more
Excel spreadsheets have a lot of potential applications, and some of those applications involve the integration of other programs on your computer. Once such program is your Web browser. For example, the format of your spreadsheet might dictate that you include a cell with a link to a particular Web page. But rather than type … Read more
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 … Read more
Excel spreadsheets can often be customized to meet your specific needs, so if you need to know how to hide zero values in Excel for Mac 2011, you will be able to adjust your settings to do so. Excel spreadsheet views can be customized in other ways as well, such as if you wanted to … Read more
There are several reasons why you might want to switch to landscape orientation in Excel 2011, but most of them will have something to do with printing. Excel is notoriously difficult to print without a significant amount of settings adjustments, and many spreadsheets simply fit better on the page in landscape orientation. If you are … Read more
If you’ve ever used a calculator while you were putting data into a spreadsheet, you may be wondering if there is a faster method of how to add up a column in Excel 2011. Fortunately, Excel has a number of tools available that you can use when you want to compare, sum, or otherwise mathematically … Read more