As you enter information into a spreadsheet in Microsoft Excel you may not be paying attention to how that data will be displayed if you need to print it. But Excel columns and rows can often spill over onto new pages in places that are less than ideal. One way to control this is with … Read more
The Microsoft Office spreadsheet application, Microsoft Excel, offers a lot of ways that you can manipulate the values within the cells of your spreadsheets. For example, if I have a sample file of data where I want to reduce how many characters there are in a cell or range of cells, then I can use … Read more
Microsoft Excel shares a lot of options and styling capabilities with other Microsoft Office applications, such as Microsoft Word and Microsoft Powerpoint. While these applications all have different purposes, you can perform many of the same tasks. One such task involves changing the font color of numbers or letters that you have included in your … Read more
While you may already be familiar with specific formatting requirements that you need for school or work when working in Microsoft Word, it’s also possible that you need to use specific formatting options in Microsoft Excel. One such requirement is to add a filename to the header on an Excel spreadsheet. When you have a … Read more
When you are trying to change the appearance of text or data in Excel then you need to select the cell that you wish to modify and apply the new format. But what if you want the selected text to include the entire worksheet, and you want to change the font style of each selected … Read more
Taking advantage of the ability to have multiple sheet tabs in Microsoft Excel is a great way to keep similar types of data organized. For example, if you have a report that you create monthly then you might have a separate worksheet tab for each month. This makes sharing information much simpler, as you only … Read more
While much of the data that you add to a spreadsheet in Microsoft Excel will probably go inside the cells, you may find that you need to add information to a text box as well. Whether this is information that is supplementary to your data, or you are highlighting something found in a row or … Read more
Getting the size of your cells right is something that can be surprisingly tricky, depending on your needs. While you can approximate the column width or row height by dragging the borders or even autofit column widths by double-clicking one of those borders, you may want to select column widths to meet some specific requirements. … Read more
Placing your data into cells in Excel provides you with ways that you can compare and interact with your data. Typically this will involve various sorting options and formulas, but you can also create charts and graphs, if necessary. You can even learn how to make a pie chart in Excel 2013 if you have … Read more
Since Microsoft Excel spreadsheets often rely on the precision of data that is entered into cells, it’s helpful to be using the unit of measurement that is native to your current location, or that is native to the location of the people that will be using that data. Like the rest of the programs in … Read more