0
Is it true that You must apply borders to all the cells in a worksheet?
Wiki User
∙ 7y ago
You apply borders to some or all cells. Don't confuse borders with gridlines. Gridlines show the cells. A new worksheet has no borders, just gridlines. You can then put borders around whichever cells you want or just around parts of a cell, so not all 4 sides. Gridlines can be turned off to give more effect to borders.
Wiki User
∙ 7y ago
Wiki User
∙ 10y agoBorders can be applied to whatever cells you want, in whatever style you want. Gridlines show for all cells, so that every cell can be distinguished. Borders and gridlines should not be confused.
Add your answer:
Earn +20 pts
Can you set password for coluom or row in excel spread sheet?
No, you can not password protect only a part of a worksheet, you must protect the entire worksheet. However, you can format everything, except the section you want to protect, to unprotect. That way, when you turn the worksheet protection on you can set the protection status to allow access only to unprotected cells.
How do you change multiple hyperlinks in Excel worksheet?
Hyperlinks can only be changed one at a time. You can select a range of cells and apply the same link to all of them, even without text in them. Select the cell or cells and press Ctrl - K to open the dialog box. You cannot put different links into the cells at one time. So if your cells are to have different links, then they have to be done one at a time. If one block of cells have all set to have the same link, then that can be removed at once. If there are different links in a block of cells, then each link must be removed individually.
How do you protect file in Excel?
If you have Microsoft exel 2007, all you have to do is go onto review, then go to protect sheet (or workbook, it depends how you want to lock it - if your not sure, hover over each one and it'll tell you), then enter the password you want, then click Ok.
Can you enter formulas at the bottom of columns and at the end of rows?
A formula can be in the last cell of a row or column, but not actually outside of the worksheet itself. Formulas must be in actual cells.
When you save a workbook each worksheet will have a different file name?
No. The workBOOK is saved as a single file including every workSHEET.
Can you give me an example of a sentence using the word apply?
You must apply to college. You must apply yourself to your studies. You should apply sunscreen before going to the beach.
How can you use apply in two sentences?
In order to be eligible a grant, you must apply before the deadline.You must apply the medication directly on the wound.
Is 'apply' a verb?
Yes. "You must apply yourself."
Is it true each time you save a worksheet you must open the save as dialog box?
yes
Which symbol is used for including formulas in an excel worksheet?
A formula must begin with an equals sign (=).
When entering numbers in a worksheet you must put if the number is to be used as currency true or false?
False
What is a good sentence for the word transparent?
To see a worksheet clearly on an overhead projector, it must be transparent.
