The cells in your Microsoft Excel spreadsheet are split up into rows or columns that run horizontally or vertically across the screen or the page. You can type data, or copy and paste data, into your cells, then you can format it or perform mathematical operations upon it. But you might discover that you need … Read more
Excel spreadsheets show a pattern of lines on the screen that represent the perimeters of the cells. These are called gridlines, and they make it easier to distinguish different cells from one another. But gridlines can be overridden by cell fill colors, so you may be looking for a way to regain those cell perimeters. … Read more
Have you ever meticulously entered a lot of data into a spreadsheet, only to find that you need to add something between two existing rows? You may have solved this issue by cutting all of your data and pasting it one row lower, or you might have even deleted a bunch of data to make … Read more
A Microsoft Excel workbook can frequently include a number of different tabs called worksheets. Each worksheet in your Excel file might include important information that you need to print. But if your needs require you to include more than one worksheet on a page when printing in Excel, then you may be wondering if there’s … Read more
A default spreadsheet in Microsoft Excel 2013 is going to display rows and columns of cells that are separated via a sequence of lines. These are called gridlines, and are useful for making data easier to read. But these gridlines aren’t going to print if you don’t change the default settings, which can leave you … Read more
Sometimes when you are editing an Excel file you are working with sensitive information. Since anyone with access to your computer or the Excel spreadsheet would be able to view that information, it can be helpful to apply an Excel password to the file. But it may be necessary to later learn how to remove … Read more
Microsoft Excel is full of useful tools that can help you get the information that you need from your source data. But if you have heard of or seen a pivot table before, then you might be curious about how to create a pivot table in Microsoft’s spreadsheet application. Learning how to make a pivot … Read more
Converting units of measurement is a necessary evil for a lot of people in a wide variety of fields. Fortunately if you want to convert millimeters to inches in Excel 2013 then you have a way to do so in the application with the use of a formula that we will discuss below. Learning how … Read more
While Microsoft Excel will usually adjust your column width and row height based on the widest cell contained within that column, you may still need to adjust your rows and columns to more appropriate sizes. Fortunately you can use autofit in Excel if you want to quickly change your column width or row height to … Read more
Microsoft Excel includes a number of different ways that you can calculate totals or values based on your cell data. But if you need to know how to find an average in Excel 2013 then you may be struggling to locate the average function in Excel 2013. You may know how to calculate an average … Read more