Magic Excel formula?????
sexy_miss
-
Raymond PENTIER Posted messages 58209 Registration date Status Contributor Last intervention -
Raymond PENTIER Posted messages 58209 Registration date Status Contributor Last intervention -
Hello,
I have an Excel file where, in column "F", the terms YES and NO must appear. Manually, I have entered the cells that contain the word YES. Now, I would like the empty cells to display NO automatically.
What should I do for that? I can't find the right formula, help me!
Thank you for your help
Lili
I have an Excel file where, in column "F", the terms YES and NO must appear. Manually, I have entered the cells that contain the word YES. Now, I would like the empty cells to display NO automatically.
What should I do for that? I can't find the right formula, help me!
Thank you for your help
Lili
Configuration: Windows XP Internet Explorer 6.0
11 answers
-
hello
freeze the top rows for display or printing?
1- for display: select the line immediately below (for example if you freeze lines 1 and 2 you select line 3) then Window / Freeze Panes
it works for rows and columns you must select the cell below and to the right of the rows and columns you want to freeze
2- for printing: File / Page Setup / tab "Sheet" / select the rows and/or columns to repeat
--
(_Usul d'Arrakis
Serial_Dreamer_)
