Using the correct formatting option when you are working with data in an Excel spreadsheet can make it much easier for both you and your spreadsheet readers to understand your data. This formatting can often be as simple as choosing the right type of data, but it might also involve customizing the format settings until… Continue Reading How to Format Money Without the Dollar Sign in Excel 2013
Microsoft Excel spreadsheets, unlike ones that you create in Google Sheets, will not print gridlines or cell borders by default. Sometimes this is helpful, but other times it can be a problem. You can add gridlines or borders as needed in Excel, either from the Page Layout tab or the Home tab. If you need… Continue Reading How to Print Excel Without Lines in Microsoft Office 2013
You may already be familiar with the use of hyperlinks in Microsoft Word documents or on Web pages that you view in a browser like Google Chrome, Microsoft Edge, or Mozilla Firefox. Microsoft Excel also has a tool that you can use to add links to cells, but it also allows you to add links… Continue Reading How to Add a Hyperlink to a Picture in an Excel 2013 Spreadsheet
Microsoft Excel provides a large variety of options that can help you to properly format your data. If you have ever worked with currency cells in a spreadsheet, for example, then you might already be aware of how useful this can be. To format UPC cells in Excel you need to select the cells, right-click… Continue Reading How to Format UPC Codes in Excel
If you have ever needed to re-enter a large amount of data in a spreadsheet then you know how tedious it can be. Thie re-entry is also prone to error, and it can be frustrating to perform a lot of work simply because you need to switch some formatting. Fortunately, you can use the =UPPER(XX)… Continue Reading How to Make All Letters Capital in Excel 2013
When you create a hyperlink in a Microsoft Office application like Microsoft Excel, you will typically change the linked text in ways other than making that text clickable. This includes changing the color of the text and adding an underline to it. You can remove the underline from a link in Excel 2013 by going… Continue Reading How to Remove Underline in Excel 2013 Hyperlinks