_excel-video-272-use-go-to-constants-to-create-a-reusable-form.jpg "Excel Video 272 Use Go To Constants to Create a Reusable Form from my cell a1 Video Screenshot Preview")
GalleryPlay Video:
(Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)
⏲ Duration: 1 min 98 sec
✓ Published: 21-Mar-2015
✓ Published: 21-Mar-2015
Description:
Excel Video 272 is the first of several Excel Videos with practical examples using Go To Special.Today we’ll create a reusable expense form that makes it easy to delete all of last month’s data without having to recreate the form to enter this month’s data.There are two tricks to make the form work.The first is using Go To Constants to select and then either clear or delete those cells.If you use Clear, make sure to just clear the cell contents.If you clear all, you’ll lose the
Excel Video 272 is the first of several Excel Videos with practical examples using Go To Special.Today we’ll create a reusable expense form that makes it easy to delete all of last month’s data without having to recreate the form to enter this month’s data.There are two tricks to make the form work.The first is using Go To Constants to select and then either clear or delete those cells.If you use Clear, make sure to just clear the cell contents.If you clear all, you’ll lose the
Share with your friends:
Whatsapp | Viber | Telegram | Line | SMS
Email | Twitter | Reddit | Tumblr | Pinterest
Related Videos
_excel-how-to-use-cell-a1.webp "Nicki Berry")
_shortcut-to-quickly-reach-the-a1-cell-of-spreadsheet-in-excel.webp "Jignesh Gupta")
_worlds-first-head-transplant-system-unveiled.webp "The world’s first head transplant system has been unveiled.<br/><br/>Neuroscience and biomedical engineering startup BrainBridge have announced a mind-bending concept that would allow a head to be grafted onto a donor body.<br/><br/>The futuristic system would offer new hope to patients suffering from untreatable conditions such as stage-4 cancer, paralysis, and neurodegenerative diseases like Alzheimer's and Parkinson's.<br/><br/>The whole-body procedure involves transplanting a patient's head onto a healthy, brain-dead donor body, ensuring the preservation of consciousness, memories, and cognitive abilities.<br/><br/>BrainBridge say the process aims to be available within 8 years and would integrate advanced robotics and artificial intelligence to carry out the transplantation procedures.<br/><br/>The company add they will also be able to conduct face and scalp transplantation to restore functionality and aesthetic appearance. <br/><br/>BrainBridge are recruiting and have listed roles for experts in several fields including brain computer interfaces (BCI), as seen in Elon Musk's Neuralink brain chip, robotic surgery and neuroscience.<br/><br/>The concept is the brainchild of Dubai-based project lead Hashem Al-Ghaili, a biotechnologist and science communicator.<br/><br/>He says: \")
_excel-cell-references-link-or-refer-to-the-cells-across-different-worksheets-124-excel-in-minutes.webp "3 Minutes Tutorial")
⏲ 1 minute 52 seconds 👁 211.9K
_excel-how-to-use-cell-a1.jpg)
_shortcut-to-quickly-reach-the-a1-cell-of-spreadsheet-in-excel.jpg)
_worlds-first-head-transplant-system-unveiled.jpg)
_excel-cell-references-link-or-refer-to-the-cells-across-different-worksheets-124-excel-in-minutes.jpg)
![[+]](/images/menu.gif){kind=small}