Solved

Loosing function of validation column D

Posted on 2011-03-22
2
235 Views
Last Modified: 2012-05-11
If I enter data on a new row, and then subsequently remove that data, I loose the functionality of that row.  Is there any easy way to get that back once data that is no longer needed has been removed >>  https://spreadsheets.google.com/ccc?key=0ApGg6c9aeywQdGZ5VzcxZHljZkJjQmJ5Y2hJMFgzYUE&hl=en#gid=0
0
Comment
Question by:rtod2
2 Comments
 
LVL 18

Accepted Solution

by:
Curt Lindstrom earned 500 total points
ID: 35203588
Not entirely sure what your problem is but if the title "Loosing function of validation column D" is the actual problem it should be easy enough to fix by
1. Select a working row
2. Click the "Paint format" (Paint brush icon)
3. Select row to be fixed

The last row selected should now have the same validation rules as the first row selected.

Curt
0
 

Author Closing Comment

by:rtod2
ID: 35220895
great stuff!
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

In this article, I will show you HOW TO: Suppress Configuration Issues and Warnings Alert displayed in Summary status for ESXi 6.5 after enabling SSH or ESXi Shell.
Find out what the Office 365 disclaimer function is, why you would use it and its limited ability to create Office 365 signatures.
Viewers will learn what comprises a theme in Excel 2013, as well as how to customize them.
Viewers will learn the basics of printing in Excel 2013 and how to adjust some common settings.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now