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
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)
While you might have a good idea of the layout of the data that you are adding to a spreadsheet, changes in the scope of a project, or the addition of more data could change that. It can be frustrating to cut and paste a lot of data in Excel when you need to move… Continue Reading How to Switch a Row to a Column in Excel 2013
Is the font that is currently applied to some of the cells in your spreadsheet difficult to read? Or maybe it just doesn’t look good or match the font of the other spreadsheets that you create. Regardless of the reason why you may not like the current font, you have the ability to switch to… Continue Reading How to Change Cell Font in Excel 2013
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?
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?
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
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
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
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