Let's learn how to link from one sheet to another sheet in Microsoft Excel.
In sheet1, let's say we have the weekly expenditures for the month of January.
Let's link a total expenditure to another sheet, that's to sheet2. If your total expenditure is at Column B and row 7 in sheet1, go to sheet2 and type =sheet1!b7 and hit enter on your keyboard or just type your = and go to sheet1. Now left-click on the total expenditure that you want to link and hit enter on your keyboard. Your linking function will be automatically generated where you will be automatically taken to sheet2.
Linking from one sheet to another sheet is very easy. Just type equality sign and you go to a sheet then left-click on a value that you want to link and hit enter on your keyboard.
That's it guys!
In sheet1, let's say we have the weekly expenditures for the month of January.
Let's link a total expenditure to another sheet, that's to sheet2. If your total expenditure is at Column B and row 7 in sheet1, go to sheet2 and type =sheet1!b7 and hit enter on your keyboard or just type your = and go to sheet1. Now left-click on the total expenditure that you want to link and hit enter on your keyboard. Your linking function will be automatically generated where you will be automatically taken to sheet2.
Linking from one sheet to another sheet is very easy. Just type equality sign and you go to a sheet then left-click on a value that you want to link and hit enter on your keyboard.
That's it guys!
Learn how to make a blogger theme responsive at https://v815.blogspot.com/2020/01/how-to-make-your-blogger-theme-fully.html
No comments
Post a Comment