Figure E Add a calculated column that references a field in another table. You’ll notice that the formula uses the RELATED function to reference the table that isn’t in the active table, Sales.

How to freeze a column in Excel Follow these steps to freeze the first column in your spreadsheet and keep it visible while you scroll to the left or right. Go to “View” at the top menu ...

Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.

Remember, we can sort by only two fields in the visualization: Month and Sales. The new column isn’t in the visualization, and if you try to add it, you will make a mess.