Thread: EXCEL FORMATTING OF WORKSHEETS WITH WITH SHADED ROWS
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default EXCEL FORMATTING OF WORKSHEETS WITH WITH SHADED ROWS
Use format painter icon and copy down as far as needed


"LOTLITA64" wrote:

I HAVE AN EXCEL SPREADSHEET THAT HAS SHADED ROWS. EVERY OTHER ROW IS SHADED
GREY. IS THERE A WAY TO FORMAT A WORKSHEET SO THAT WHEN A ROW IS ADDED, IT
AUTOMATICALLY HAS THE EVERY OTHER ROW SHADING FORMAT SO THAT YOU DO NOT HAVE
TO GO BACK A RE-SHADE EVERY OTHER ROW GREY?
Reply With QuoteReply With Quote