excel 2013

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

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

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