Default cell values...etc

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

Hi all,

I would like to set a numeric value cell to 0 anytime it is empty. I
have tried the IF function to check for a "", but if a user DELETES the
value within a cell is this "null" value. If so how can I accomplish
setting it to ZERO?

I am also hoping to print the column headers at the top of every page
(after the first one), however what I want to use as headers are in row
12 after some other preliminary data. Can these headings still be used
to print at the top of pages 2, 3, 4 and so on?

TIA,

Michelle
 
You need to set up a worksheet with the formatting that you want to be
repeated every time and then save it as a template. It doesn't matter where
on the worksheet the formatting is.

As for the "0", use conditional formatting to accomplish this.

S VanN
 
Back
Top