From the course: Excel Quick Tips (2023)

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Add and reference worksheets

Add and reference worksheets - Microsoft Excel Tutorial

From the course: Excel Quick Tips (2023)

Start my 1-month free trial Buy for my team

Add and reference worksheets

“

- [Instructor] You can easily insert a new sheet to your workbook by clicking the plus sign at the bottom of the screen. Rename the sheet by right-clicking, and choose Rename. Type in the new name, and press Enter on your keyboard. Fill in the data in your new sheet. (keyboard clicks) Now you can pull the content from the new sheet into any other sheet in your workbook by typing an equal sign in a cell, followed by the name of the sheet, (keyboard clicks) followed by an exclamation mark and the cell number from that sheet that you're pulling the content from. Note that if the name of the sheet is more than one word, you need to put the name between single quotation marks.

Contents