Thread: I want Excel to regard emply cells as zero and display it
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default I want Excel to regard emply cells as zero and display it
Select your range then go to menu Data Filter AutoFilter Blanks enter
all 0

"gencerm" wrote:

on a selected area in the worksheet.
Reply With QuoteReply With Quote