Embedded Files
In the last class we had learnt two ways of referencing cells in other sheets: by entering the formula directly using the keyboard or by using the mouse. In today's class we will look at the method of creating hyperlink in a sheet.
In the last class we had learnt two ways of referencing cells in other sheets: by entering the formula directly using the keyboard or by using the mouse. In today's class we will look at the method of creating hyperlink in a sheet.
Hyperlinks can be stored within your file as either relative or absolute.
Hyperlinks can be stored within your file as either relative or absolute.
An absolute link will stop working only if the target is moved. A relative link will stop working only if the start and target locations change relative to each other. For instance, if you have two spreadsheets in the same folder linked to each other and you move the entire folder to a new location, a relative hyperlink will not break.
An absolute link will stop working only if the target is moved. A relative link will stop working only if the start and target locations change relative to each other. For instance, if you have two spreadsheets in the same folder linked to each other and you move the entire folder to a new location, a relative hyperlink will not break.
To change the way that OOo saves the hyperlinks in your file, select Tools > Options > Load/Save > General and choose if you want URLs saved relatively when referencing the File System, or the Internet, or both.
To change the way that OOo saves the hyperlinks in your file, select Tools > Options > Load/Save > General and choose if you want URLs saved relatively when referencing the File System, or the Internet, or both.
You can insert and modify links using the Hyperlink dialog. To display the dialog, click the Hyperlink icon on the Standard toolbar or choose Insert > Hyperlink from the menu bar. To turn existing text into a link, highlight it before opening the Hyperlink dialog.
You can insert and modify links using the Hyperlink dialog. To display the dialog, click the Hyperlink icon on the Standard toolbar or choose Insert > Hyperlink from the menu bar. To turn existing text into a link, highlight it before opening the Hyperlink dialog.
Let's watch the following video to understand the procedure of creating a hyperlink in a sheet.
Let's watch the following video to understand the procedure of creating a hyperlink in a sheet.
Let's answer the following questions in the classwork notebook:
Let's answer the following questions in the classwork notebook:
- What is a hyperlink?
- What all things cab be hyperlinked in Open Office Calc?
- To create a hyperlink, click on the __________________________ tab, in the _______________________ group and then click Hyperlink .
- What is the shortcut key to create a hyperlink in Open Office Calc?
In most of the organizations, there is a shared drive where people can store common files for everyone to use.
In most of the organizations, there is a shared drive where people can store common files for everyone to use.
When we try to access a shared file, it usually leads to sighting of the message: “The document [file name] is locked for editing by another user. To open a read-only copy of this document, click“!! This message appears because someone else already has the file open. Sometimes however, it is necessary to have multiple people working on a file at the same time. This can be to either speed up data entry or simply make things easier for collaboration purposes.
When we try to access a shared file, it usually leads to sighting of the message: “The document [file name] is locked for editing by another user. To open a read-only copy of this document, click“!! This message appears because someone else already has the file open. Sometimes however, it is necessary to have multiple people working on a file at the same time. This can be to either speed up data entry or simply make things easier for collaboration purposes.
Spreadsheet software allows the user to share the workbook and place it in the network location where several users can access it simultaneously. Let's explore this feature of spreadsheet.
Spreadsheet software allows the user to share the workbook and place it in the network location where several users can access it simultaneously. Let's explore this feature of spreadsheet.
To share the spreadsheets do the following.
To share the spreadsheets do the following.
• Click on Share workbook option under Changes group in the Review tab.
• Click on Share workbook option under Changes group in the Review tab.
• A dialog box appears.
• A dialog box appears.
· Check the option Allow changes by more than one user at the same time. This also allows workbook merging.
· Check the option Allow changes by more than one user at the same time. This also allows workbook merging.
· Click OK.
· Click OK.
Note: Most spreadsheets software automatically turns off some features in shared work books. This is to simplify the workbook since multiple people can be working on the file at the same time. For example, shared workbooks don’t allow merging cells, conditional formatting, or inserting pictures/graphs/etc.
Note: Most spreadsheets software automatically turns off some features in shared work books. This is to simplify the workbook since multiple people can be working on the file at the same time. For example, shared workbooks don’t allow merging cells, conditional formatting, or inserting pictures/graphs/etc.
Discussion Board
Discussion Board
While going through the concepts again, we might have some questions in our mind. Feel free to ask them by posting it on the discussion board. The link of the same is shared below.
https://jamboard.google.com/d/1yU91VXjGo2kCGr2WFy580GhvI5qvCN1JqlAGaVGuhjs/edit?usp=sharing
Please make it a platform to share your learning or doubts. You can also answer the questions of your peers. But refrain from any negative remarks.
Next week we will explore another very important feature of spreadsheet known as Macros. They reduce the possibility of human error that increases with many, repetitive keystrokes and tasks. Macros reduce the amount of time that must be spent performing basic computing tasks. They also make complex computations easier to perform. Please re-read the concepts covered till date for a 10 minute viva in the next class.
Page updated
Report abuse