Excel Video 272 Use Go To Constants to Create a Reusable Form from my cell a1 Watch Video
Preview(s):
Gallery
Play 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!)
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
Play 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!)