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 … Read more
Printers and printing can be frustrating, so it would be great if everyone would view spreadsheets, grids, and other similar types of documents on their screen inside the Microsoft Excel program. However, that is an impractical solution for many situations, so you will often find yourself printing out the spreadsheets you have created. But if … Read more
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 … Read more
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 … Read more
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) … Read more
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 … Read more