how to move a column in excel 2013

How to Move a Column in Excel 2013

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

add the cell borders that you want

How to Add Borders in Excel 2013

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

how to insert a new row in Excel 2013

How to Insert a Row in Excel 2013

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

how to print gridlines in excel 2013

How to Print Excel with Lines

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

delete the password, then click the ok button

How to Remove a Password in Excel 2013

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

Click Insert, then PivotTable

How to Create a Pivot Table in Excel 2013

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

click the autofit column width option

How to AutoFit All Columns in Excel 2013

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

formula bar showing average

How to Find an Average in Excel 2013

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