To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.

In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while scrolling.

2. Click the Data tab. 3. In the Get & Transform Data group, click From Table/Range. If you haven’t formatted the data as a Table, Power Query will prompt you to do so.

Enter the new data series in the cells next to or below the source data. If there are no empty cells, insert a new row by right-clicking the row below where you want to insert the new row.

Select the "Filter" option from the "Data" menu or choose the "Sort and Filter" option from the "Home" menu followed by the "Filter" option on the drop-down list in the Excel application.

How to use AutoComplete in Excel The term AutoComplete shows up often in feature lists—it’s easy to guess what it does even if you’re not familiar with it in Excel.

This makes your data up to date with the changes. If you want to refresh a single data, right-click on it and select the Data type and click on Refresh. Geography Data missing in Excel If you are ...

To use Excel's scenario manager function, select the cells with the information you're exploring, and then go to the ribbon and select Data. Select What-If Analysis > Scenario Manager.

2. Select the column to the right of where you want a new column. (Excel will insert the new column directly in front of it.) Select an entire column by clicking on its letter name at the top. 3.