Many of the formatting changes that you can use in Excel are visible on one of the tabs in the navigational ribbon. Occasionally these tools will have options that specifically apply to an entire worksheet, but many only apply to the current selection. So if you need to know how to expand all of your … Read more
Excel formulas present you with a number of options for editing your data. But there is one less commonly used formula that allows you to remove the first character from a cell in Excel. A lot of data that you encounter will not be formatted the way that you need it. Whether a colleague likes to … Read more
When you want to make the same change to multiple cells in a Microsoft Excel worksheet, then you can usually do so by selecting all of the cells that you want to edit. The same rule applies to entire worksheets in Excel, and one of the things you can edit in bulk are headers. You … Read more
Learning how to calculate a median in Excel 2013 is similar to learning how to perform most other mathematical functions within the program, such as subtracting in Excel. If you are new to using formulas in Excel, then this article can be helpful. Excel uses a formula that takes the values in a range of … Read more
Working with data in Microsoft Excel can have an extra element of difficulty when printing is involved. Often it can make things a bit easier when you can see how the worksheet will look when it prints. You can switch to Print View in Microsoft Excel 2013 by going to the View tab, then clicking … Read more
Occasionally you will need to display content in a spreadsheet in a location other than a cell. Creating a text box can be a good solution to this, as text boxes are very versatile. If you need to add an outline to an excel text box then you can select the text box, click the … Read more
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