Excel
on channel: AuditExcel Advanced Excel and Financial Model Training and Consulting
00:00 Be careful how you delete cells (where you get Shift Up or Shift left option)
00:27 The cell you moved will show an error message (Good)
00:38 Deleting cells affects all formula below or to the right (High risk as you may not notice it)
Have you ever done something and suddenly one or a few (not all cells) have a REF error. The REF error cells need to be fixed, but watch out for the cells to the right or below as well.
Watch video Excel online without registration, duration hours minute second in high quality. This video was added by user AuditExcel Advanced Excel and Financial Model Training and Consulting 23 March 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 602 once and liked it 0 people.