Is there a way to prevent particular rows and columns with important data, and locking them up, so when you delete rows that are to the left of this information, if would not delete those rows? I have important data with formulas in F6:FG on rows 6,7,& 8. The the left of this data, in Columns A, B,C,D,& E I have employee names, date of births, etc. but there are times we deleted rows when we need to insert new names, or more importantly, delete rows and I don't want my important data deleted.
Of course I thought about the Polish way (hey, I'm polish, I can say that
and putting my data which consists fo 8 rows and 2 columns at the very top of the page, and push down the other infomation, but it makes the spreadsheet appear so grade school. And the I thought about inserting in on another tab/sheet within the same document, however, I don' remember the formula for grabbing info and formula's from Sheet and inputting it on Sheet 2. I remember doing it many, many years go. And I still don't think that's the proper way of doing this.
As always -- thank U so much!
Of course I thought about the Polish way (hey, I'm polish, I can say that
and putting my data which consists fo 8 rows and 2 columns at the very top of the page, and push down the other infomation, but it makes the spreadsheet appear so grade school. And the I thought about inserting in on another tab/sheet within the same document, however, I don' remember the formula for grabbing info and formula's from Sheet and inputting it on Sheet 2. I remember doing it many, many years go. And I still don't think that's the proper way of doing this.As always -- thank U so much!
