To pull data from Sheet 1 into Sheet 2 using cell references, click on the tab for Sheet 2, and set up your column headers (in cells A1, B1, and C1) In cell A2 of Sheet 2, enter the formula to ...

From now on, any changes made to data in the selected cell will show up on your totalling worksheet as well. Warnings Information in this article applies Excel 2013.

How to set print area in Excel. For the sake of this example, we use a small set of data about employees of a fictitious company. The dataset includes position, division, city, and date of hire.

If you're a spreadsheet jockey but you're not keen on Excel's default settings, reader Curare details how to set up a custom Excel template so the data-wrangling app always uses the workspace you ...

You can freeze a row in Excel so it's easier to compare data as you scroll through the spreadsheet. You can choose to only freeze the first visible row in your Excel sheet, or freeze multiple rows.

Image: monticellllo/Adobe Stock. A large set of Microsoft Excel data without good formatting is difficult to read. Table objects automatically apply alternating colors from one row to the next ...