Hi, I have many worksheets within the same file, what I really want is to have either a (link / go to option) from sheet1 to other sheets without using hyperlink because I want to send to others. Example: if I click on Apple from Sheet 1, I will go to Sheet2 Sheet1 Sheet2 ...

When you protect a worksheet in excel but unprotect certain cells, why can't you change the format of the cells or insert comments?

:rolleyes: I try to use excel to print an invoice, how can I put an invoice number that will auto upadate the next time I use the file?

I am using excel to record some data and I have it setup to do some math based on the info that I put into certain cells. Now what I am wondering is am I able to setup the sheet so that it will prompt me for the 4 pieces of data that I want to enter and then place those in the proper cells and then...