[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Excel is a great tool to use when dealing with large amounts of data. Often, a dataset in one of your workbooks may need to pull data from another sheet in Excel. Luckily, Excel offers multiple ways for you to reference Excel data from a cell, reference a range of cells, or pull data from another sheet in Excel.<\/p>\n
Externally referencing Excel files is common in many day-to-day operations. For example, you may want to pull data from last year\u2019s sales data to compare it to this year\u2019s results. You can control how much data you reference, from a single cell, all the way up to an entire worksheet. What\u2019s more, you can reference data dynamically, meaning that whenever your cell values change from the source file, they will automatically be updated in your destination file where the reference has been created.<\/p>\n
In this article, you\u2019ll learn how to reference data from the same worksheet, different worksheets, and different workbooks in Excel. This article will cover referencing a single cell, a range of cells, multiple columns, and even entire worksheets.<\/p>\n
You will also learn about an alternative, Sheetgo<\/a>, an AI-powered data automation platform that lets you automatically connect your files and transfer data without having to use cell references or formulas.<\/p>\n Don\u2019t tend to work in Excel? Check out our article on Google Sheets reference another sheet<\/a>.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-reference-cells-in-the-same-sheet” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n A cell reference refers to the data within a cell(s) to another within your Excel worksheet or workbook.<\/p>\n Let\u2019s say I have an Excel sheet containing the monthly data from my 2021 sales. In this sheet, I want to reference some of these cells again – I don\u2019t need to exit my sheet or reference any external data – I\u2019m simply referencing cells within my current worksheet.<\/p>\n To reference a cell in the same Excel worksheet you\u2019re working in, you can enter a simple formula: an equals sign followed by the cell reference, such as =A1.<\/p>\n There are multiple ways you can reference data from the same worksheet. Let\u2019s explore each type of Excel reference you may need and the best method for each one.<\/p>\n To reference a single cell in the same Excel worksheet, simply add the cell number after an \u201c=\u201d sign, e.g. =A1<\/p>\n For example, let\u2019s say I want to reference the month with the highest monthly sales in 2021:<\/p>\n 1.<\/strong> Click on the cell you wish to add your reference to and enter =B13.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-reference-same-sheet-cell-formula.webp” alt=”Excel reference in the same sheet \u2014 =B13 typed in cell G2 under Top month next to the Total sales 2021 table” title_text=”=B13 typed in cell G2 under Top month next to the Total sales 2021 table” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Excel will replicate the value in B13 to the empty cell in the same worksheet.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-reference-same-sheet-cell-result.webp” alt=”Excel reference in the same sheet \u2014 cell G2 returns the December total of $9,369.88″ title_text=”Cell G2 returns the December total of $9,369.88″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n There are different ways to share an Excel file. Here’s how to share an Excel file with multiple users<\/a> for easy collaboration.<\/p>\n If you want to reference a range of cells in the worksheet, use the same formula, but this time, enter the beginning cell and end cell of your range, separated by a colon.<\/p>\n Let\u2019s say I want to add the first-quarter total sales to another part of my sheet.<\/p>\n 1.<\/strong> Click on the cell you wish to add your reference to and enter =B2:B4<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-reference-cell-range-formula.webp” alt=”Excel cell range reference \u2014 =B2:B4 in cell G2 under 1 Quarter sales with January to March selected” title_text=”=B2:B4 in cell G2 under 1 Quarter sales with January to March selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> This will replicate the values in cells B2 through to B4 of the worksheet.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-reference-cell-range-result.webp” alt=”Excel cell range reference \u2014 January to March sales returned in cells G2 to G4″ title_text=”January to March sales returned in cells G2 to G4″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You can also reference cells by column or multiple columns with the same format as the previous step.<\/p>\n Let\u2019s say I want to duplicate my two current columns in the same sheet.<\/p>\n 1.<\/strong> Click on the cell you wish to add your reference to and enter =A1:B13<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-reference-multiple-columns-formula.webp” alt=”Excel reference multiple columns \u2014 =A1:B13 in cell G1 with the Month and Total sales 2021 columns selected” title_text=”=A1:B13 in cell G1 with the Month and Total sales 2021 columns selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> This will replicate the multiple rows of data within the two columns.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-reference-multiple-columns-result.webp” alt=”Excel reference multiple columns \u2014 Month and Total sales 2021 columns repeated in columns G and H” title_text=”Month and Total sales 2021 columns repeated in columns G and H” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to-reference-another-sheet-in-excel” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n When referencing another worksheet within the same workbook, the principle remains the same. In this case, you just need to add the name of the alpha sheet or source sheet (the sheet containing the original data) as part of the formula.<\/p>\n To reference a cell or a cell range in another worksheet in the same workbook, simply put the \u201cworksheet name\u201d followed by an exclamation mark \u201c!\u201d, then the cell reference.<\/p>\n In this example, I have my 2020 sales data in another sheet in the same workbook.<\/p>\n Please note:<\/strong> If your worksheet name contains spaces or special characters, always remember to wrap it in single quotes, and make sure it is referenced exactly, e.g. \u2018Sales 2020\u2019.<\/p>\n Let\u2019s say I want to add the January 2020 sales total to my 2021 sheet.<\/p>\n 1.<\/strong> Click on the cell you wish to add your reference to and enter =\u2019Sales 2020\u2019!B2 to reference cell B2 in the sheet named \u201cSales 2020\u201d in this workbook.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-reference-another-sheet-cell-formula.webp” alt=”Excel reference another sheet \u2014 =’Sales 2020′!B2 typed in cell C2 under Total sales 2020″ title_text=”=’Sales 2020′!B2 typed in cell C2 under Total sales 2020″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> This will pull the cell value from the \u201cSales 2020\u201d sheet into your current sheet.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-reference-another-sheet-cell-result.webp” alt=”Excel reference another sheet \u2014 cell C2 returns the January 2020 total of $2,749.02″ title_text=”Cell C2 returns the January 2020 total of $2,749.02″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Follow the same steps as above, adding your cell range to the formula. In this example, I\u2019ll reference the entire cell range containing the monthly sales for 2020.<\/p>\n 1.<\/strong> Click on the cell you wish to add your reference to and enter =\u2019Sales 2020\u2019!B2:B13 to reference cell range B2:B13 in the sheet named \u201cSales 2020\u201d in this workbook.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-reference-another-sheet-range-formula.webp” alt=”Excel reference another sheet \u2014 =’Sales 2020′!B2:B13 typed in cell C2 next to the 2021 totals” title_text=”=’Sales 2020′!B2:B13 typed in cell C2 next to the 2021 totals” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> This will add the cell range from the \u201cSales 2020\u201d sheet into your current sheet.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-reference-another-sheet-range-result.webp” alt=”Excel reference another sheet \u2014 monthly 2020 sales filled into column C beside the 2021 totals” title_text=”Monthly 2020 sales filled into column C beside the 2021 totals” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to-reference-another-workbook-in-exc” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n It\u2019s common that the data you wish to reference is located in an external workbook. To reference another open workbook in Excel, you need to use the following formula: =[Book1.xlsx]Sheet1!A1. For example, ='[Sales 2020.xlsx]Sales 2020′!B2 returns cell B2 from the Sales 2020 sheet in the Sales 2020.xlsx workbook. When the workbook or sheet name contains spaces, wrap both in single quotes, as in this example.<\/p>\n To reference from an open workbook, you don\u2019t have to necessarily manually enter the entire formula. Here\u2019s a shortcut:<\/p>\n 1.<\/strong> In your destination file, click on the cell you wish to add your reference to and type =<\/p>\n 2.<\/strong> In the source file, highlight the cell you wish to reference and press Enter.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-reference-another-workbook-source-range.webp” alt=”Excel reference another workbook \u2014 Sales 2020.xlsx open with B2:B13 selected and the external reference in the formula bar” title_text=”Sales 2020.xlsx open with B2:B13 selected and the external reference in the formula bar” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Excel will return you to the destination file and display the reference from the source in the cell.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-reference-another-workbook-result.webp” alt=”Excel reference another workbook \u2014 2020 totals pulled into column C from the Sales 2020.xlsx file” title_text=”2020 totals pulled into column C from the Sales 2020.xlsx file” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Please note:<\/strong> To reference a cell from a closed workbook, you must enter the entire path of the workbook – this may be either a file path from your personal computer folder or a link if you\u2019re using Excel online.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-reference-closed-workbook-file-path.webp” alt=”Excel reference closed workbook \u2014 full file path to Sales 2020.xlsx in the formula bar for cell C2″ title_text=”Full file path to Sales 2020.xlsx in the formula bar for cell C2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n If you\u2019re using Excel online, here is another way to reference an entire workbook. You can create an external reference using the simple copy and paste link.<\/p>\n 1.<\/strong> In your source file, highlight the cell\/range of cells you wish to reference, right-click and select \u201cCopy\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-paste-link-copy-source-range.png” alt=”Excel paste link \u2014 right-click menu with Copy on the selected 2020 sales range” title_text=”Right-click menu with Copy on the selected 2020 sales range” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> In your destination file, click on the cell you wish to add your reference to, right-click and click on the \u201cPaste link\u201d icon shown below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-paste-link-option.png” alt=”Excel paste link \u2014 Paste Options in the right-click menu with the Link icon highlighted” title_text=”Paste Options in the right-click menu with the Link icon highlighted” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> The data will be added to your destination file immediately.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-paste-link-workbook-reference.png” alt=”Excel paste link \u2014 2020 sales linked into column C with a SharePoint workbook path in the formula bar” title_text=”2020 sales linked into column C with a SharePoint workbook path in the formula bar” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Using Sheetgo<\/a>, an AI-powered data automation platform, you can automatically connect your Excel workbooks and transfer data between them without having to use references or formulas. In fact, you can connect your data across multiple formats, including Excel, Google Sheets, and CSV.<\/p>\n Sign up to Sheetgo for free<\/a> and connect your files in two steps: choose your source file, then choose your destination file.<\/p>\n [\/et_pb_text][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Excel is a great tool to use when managing large amounts of data. With just a simple formula, you can reference anything from a single cell up to an entire dataset, from any worksheets or workbooks you have. Referencing cells in Excel is an effective way to evaluate and analyze different data in one place. However, if you\u2019re looking for a more comprehensive and automated solution that requires no formulas or references, sign up for Sheetgo<\/a>, an AI-powered data automation platform, and start saving time today.<\/p>\n Need to do the same task but in Google Sheets? Take a look at our article on how to reference another sheet in Google Sheets<\/a>.<\/p>\n Here are some other articles you may find useful:<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Aprenda a f\u00f3rmula do Excel para fazer refer\u00eancia a outra planilha e como puxar uma c\u00e9lula, um intervalo ou colunas inteiras de outra planilha ou pasta de trabalho.<\/p>","protected":false},"author":2,"featured_media":264755,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[51],"tags":[],"class_list":["post-264738","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-features"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/264738","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=264738"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/264738\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/264755"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=264738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=264738"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=264738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}How to reference cells in the same sheet in Excel?<\/h2>\n
Reference a cell in the same sheet in Excel<\/h3>\n
Reference range of cells in the same sheet in Excel<\/h3>\n
Reference a column or multiple columns in Excel<\/h3>\n
How to reference another sheet in Excel?<\/h2>\n
Reference a cell from another sheet in Excel<\/h3>\n
Reference a range of cells from another sheet in Excel<\/h3>\n
How to reference another workbook in Excel?<\/h2>\n
Reference from another workbook in Excel<\/h3>\n
Reference another workbook in Excel with copy and paste link<\/h3>\n
Automatically import data from another Excel workbook with Sheetgo<\/h3>\n
Conclusion<\/h2>\n
\n