how to wrap text for all cells in excel 2013 spreadsheet

How to Wrap Text for Every Cell in a Spreadsheet in Excel 2013

Occasionally some of the text in some of your Microsoft Excel cells won’t be visible. This happens when there are more characters in the cell that can fit within the visible cell boundaries. While you might have tried adjusting the row height and column width before, another option would be to wrap the text in… Continue Reading How to Wrap Text for Every Cell in a Spreadsheet in Excel 2013

type the subtraction formula into the cell

How to Subtract in Excel 2013 with a Formula (An Easy 4 Step Guide)

There is a pretty steep learning curve when you start to see all of the different things that you can do in Microsoft Excel. It’s an incredibly powerful application with a nearly infinite number of potential uses. But one of the more useful things that you can do is learn how to subtract in Excel.… Continue Reading How to Subtract in Excel 2013 with a Formula (An Easy 4 Step Guide)

how to change the default font size in excel 2013

How Do I Make My Font Smaller or Larger by Default in Microsoft Excel?

Is the font in your spreadsheets difficult ot read because it’s so small? Or are you having trouble seeing all of your data because the text is too large? While Microsoft Office applications like Excel have default font settings that are meant to be easy to read for everyone, that may not be the case… Continue Reading How Do I Make My Font Smaller or Larger by Default in Microsoft Excel?

display all files in the folder

Why Isn’t Excel 2013 Showing the Files That I Want to Open?

Are you trying to open a file that you know is compatible with Excel, but it’s not showing in File Explorer? When you click Open in the Excel backstage menu you can select one of the folders on your computer. By default, Excel will show you all of the Excel files that are stored in… Continue Reading Why Isn’t Excel 2013 Showing the Files That I Want to Open?

click breaks, then click insert page break

How to Insert a Page Break in Excel 2013

Have you been trying to get your spreadsheet to print correctly? If so, then you may have discovered that it is surprisingly difficult. Whether the gridlines aren’t visible or you have columns or rows that are printing on their own pages, there are a lot of things you might need to change. One tool that… Continue Reading How to Insert a Page Break in Excel 2013

click the print selection button

How to Print Part of a Worksheet in Excel 2013

It’s really easy to make a mistake when you are trying to print an Excel spreadsheet. But even if you have gone through and made adjustments to your worksheet so that the data is configured to print well, you might find that you only need to print a small subset of your cells. While you… Continue Reading How to Print Part of a Worksheet in Excel 2013

autofit column width

How to Use the AutoFit Excel Shortcut for Columns and Rows

Adjusting the height of rows or the width of columns in Microsoft Excel is a common activity. But if it’s something that you do a lot, then you might be looking for a faster way. Luckily there is an AutoFit Excel shortcut that can make it much simpler for you to automatically adjust the height… Continue Reading How to Use the AutoFit Excel Shortcut for Columns and Rows

how to display a zero instead of #n/a in excel 2013 vlookup formula

How to Display a “0” Instead of #N/A When Using VLOOKUP in Excel 2013

The VLOOKUP formula in Microsoft Excel is one of the most efficient ways to find data in spreadsheets. Along with the concatenate formula, I have found it to be one of the more useful tools in Excel. It can save an incredible amount of time when compared to manually searching for cell data, and has… Continue Reading How to Display a “0” Instead of #N/A When Using VLOOKUP in Excel 2013