How to Insert a Header in Excel 2013

When you are creating files in Excel that are meant to be printed and shared with others, you often need to include information that is not contained within the spreadsheet. This can typically require you to weirdly format the top rows and columns of the spreadsheet, which can make it very messy when you need […]

How to Print Excel with Lines

Learning how to print gridlines in Excel 2013 is a necessity for anyone that often needs to print large spreadsheets. Information in cells can be difficult to read without them, and can lead to mistakes. Data on your screen in Microsoft Excel 2013 is organized efficiently into cells that are separated by gridlines. But when […]

How to Print Each Worksheet of an Excel 2013 Workbook on One Page

Last updated: January 12, 2017 Microsoft Excel is a great program for managing your data, but it can be a frustrating one when you need to print out that data in a manner that is easily digestible. Worksheets can easily run off of a single page and wind up wasting a lot of paper, or […]

How to Print the Top Row On Every Page in Excel 2013

A spreadsheet with a lot of data can quickly turn into a jumbled mess. You can help make it easier to read by using column and row headings, but endless cells of data all containing similar values are just difficult to read. And if you need to print that spreadsheet for someone to view on […]

How To Paste from Horizontal to Vertical in Excel 2013

Getting all of your spreadsheet data into Excel is usually the first step in making your data easier to understand. But once that data is in your worksheet, the organization can be just as important as merely having the information. Unfortunately this can lead to situations where you have incorrectly organized your data, or you […]

How to Unhide Columns in Excel

Last updated: August 16, 2018 Learning how to unhide columns in Excel is important for anyone that has data in their spreadsheet that they might need to hide from their audience. Hiding a column allows you to leave data in a spreadsheet, while simultaneously making it more difficult to view or accidentally edit it. Microsoft […]

How to Print All Columns on One Page in Excel 2013

It can be very difficult to manage a large, printed-out Excel spreadsheet when you have columns, rows and data that are all spread out across multiple pages. We have previously written about how to print an entire Excel spreadsheet on one page in Excel 2010, but this might not be a practical option for larger […]

How to Create a Pivot Table in Excel 2013

Last updated: January 25, 2017 Learning how to make a pivot table in Excel 2013 will give you a new tool in your Excel utility belt that can make sorting and analyzing data much simpler. A pivot table in Excel 2013 offers a variety of options for comparing data in columns, and grouping similar data […]