So, you want to know how to create a scatter plot in Excel. ... This will produce the Format Chart Title panel on the right so you can spruce the heading up with a background fill or border.

In Excel 2013 Home Menu, select Blank workbook.. Sheet title and custom date. In cell A1, type January 2014.Excel changes the format to Jan-14. Right-click the mouse in that cell and choose Format ...

Microsoft Excel can save you time in lots of little ways, like adding a drop-down list to cells so that only pre-written text can be entered.

Image: AndreyPopov, Getty Images/iStockphoto. The data you want to use in an Excel drop down list usually won’t be in the same sheet as the drop down. The good news is that identifying a list on ...

How to Create a Correlation Wedge Chart in Excel. ... you might have category titles down column A and category figures down column B. Click and drag your mouse across these cells to highlight them.

Print Titles is a feature in Microsoft Excel that enables its users to print a row or a column heading on each page of a report. This makes your printed copy easier to read and spot vital details ...

How to create an Excel table. 1. First, enter the field names in the columns across the top, and then enter some records/data in the rows under each column.

Your Excel 2013 spreadsheets can benefit from page headers and fixed column titles, ... Create the column titles you want to use in the first row of your spreadsheet.