First, let me say THANKS!!!

  • Thread starter Thread starter Sami66
  • Start date Start date
S

Sami66

I am in the process of learning excel. Ive come to this forum with
couple of questions and have gotten them answered. Let me sa
THANKS!!!

I have two more questions, probably dumb, but......:rolleyes:

I made a copy of my payroll and I want to delete the data BUT keep th
formulas...how??

Also, what does it mean if I am asked for the "format code" that wil
print the worksheet name???

Thanks again!
 
Select your cells. Choose Edit/GoTo/Special. Select the constant radio
button, and click OK. Hit Delete.
 
Sami
Usually you can highlight all of the cells that you have
put information into and delete them without any problems.
Once they are deleted the formula cells will appear empty
but the formulas will still be there.
Cells that contain a formula get their info from another
location that has been usually filled by you.
Make a copy of the spreadsheet before you delete anything
just in case you get carried away.

On the second problem, I think a little more information
is required, as I have never struck that problem before.

Regards
Michael
 
Asked by whom?

For headers and footers, the code is "&A".

In a cell: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
 
JE
I didn't know that !! Live and learn
But,it might also pay to uncheck the boxes beneath the
formula checkbox that you don't need. You might not really
want to remove text from your spreadsheet.
Regards
Michael
 
I needed to name the "format code that will print the wprkshee
name".......I have no idea whats meant by that.....
 
Back
Top