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
Applying a formatting change to unformatted data in Microsoft Excel can be pretty straightforward. You simply select whatever text, number, or object you want to format, then you find the appropriate button or menu. But if you want to change something that is already formatted, such as if you want to remove an existing fill… Continue Reading How to Change the Excel Cell Shading Color in Excel 2010
There are several document elements that you can use in multiple Microsoft Office products, and one of those elements is the text box. You can insert a text box independently of the other information in your Excel spreadsheet, which allows it to be used in a manner that does not affect the data that has… Continue Reading How to Delete a Text Box in Excel 2013
While there are a number of techniques that you can use to organize large amounts of data, such as giving a sheet tab a more descriptive name, or color coding rows or columns inside a worksheet, you can employ title rows and create row and column headings to make cells easier to identify. Excel 2010… Continue Reading How to Print First Row on Every Page – Excel 2010
The gridlines that separate your cells in a Microsoft Excel 2010 spreadsheet are helpful for keeping cells visually distinct from one another. So when those gridlines are not visible, the data in your cells can seem very haphazard. If you are working with a spreadsheet in Excel 2010 and the gridlines have been hidden, then… Continue Reading Where Did the Gridlines Go in Excel 2010?