Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I have an Excel document that I have used in my old workplace to track Petty
Cash. I am now using it within my new work environment, and want to change the house name, dates, etc.. so they are on all sheets. For some reason on the tabs, not all options are able to access (they are grey, instead of black). I also want to bold the name of the house, but the bold, underline and italicize options aren't able to be pushed.. Why and any quick ways to get around that? It is asking me for a password when I look to unprotect the sheet, but I have no idea of it, can i get around that? james |
#2
![]() |
|||
|
|||
![]()
Hi James,
I think you will have to copy / paste all of this into a new sheet. I don't know of a way to get around a password. If we did then protection would be a useless feature I guess. Ken "jamesbialek" wrote: I have an Excel document that I have used in my old workplace to track Petty Cash. I am now using it within my new work environment, and want to change the house name, dates, etc.. so they are on all sheets. For some reason on the tabs, not all options are able to access (they are grey, instead of black). I also want to bold the name of the house, but the bold, underline and italicize options aren't able to be pushed.. Why and any quick ways to get around that? It is asking me for a password when I look to unprotect the sheet, but I have no idea of it, can i get around that? james |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HIDING ROWS IN PROTECTED WORKSHEETS | Excel Discussion (Misc queries) | |||
How do I unlock specific cells in a spreadsheet that I protected? | Excel Discussion (Misc queries) | |||
How do I unlock a spreadsheet that is password protected? | Excel Worksheet Functions | |||
Protected Worksheets | Excel Worksheet Functions | |||
Sorting protected worksheets | Excel Discussion (Misc queries) |