View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default How do I delete the same row in a multisheet spreadsheet

Do you mean that if you delete row 4 in one sheet row 4 should be deleted in
all the sheets

If you group the sheets before you do this they all will be deleted

(click first tab, hold down shift and click last tab.

Don't forget to ungroup the sheets when you are done

--


Regards,


Peo Sjoblom

"John M.Lees" <John wrote in message
...
How do achieve the above please?
I am using a complicated multi sheet spreadsheet which reads from the
first
sheet which comprises of fixed data.
I want to delete data row by row from the data sheet,which will then
delete
corresponding rows from each following sheet.
Thank you