But I want to freeze or lock row one so that the content in say C1 can not be moved altered or deleted no matter what I do to it, ((while this lock or hold or freeze is put on it.
It would be like me having the top row as the titles of all my content in the column below the title of the column. Then I want to move my cursor over to say between column "M" and column "N" and then paste all of the content (all of the values in all of the cells with all of their formatting etc, ((except the content in cells C1:C5) Does this make sense. Then I want to grab with my pointer device say column "C" and highlight column C like I normally would by right clicking on the letter "C" and then highlight the whole column(accept the cells C1:C5 and then clicking on "Cut" in the drop down list. So I want to like freeze or obstruct from any changes at all made on say the first 5 rows of data. See my first explanation it is very thorough. Imagine if you will being able to put values in a range of rows. My detailed instructions explain that I want to perform some hybrid function of locking and freezing a variable number of rows at the top of my worksheet and be able to cut/copy/paste (basically move data) below those top say 5 rows but without anything happening to the top 5 rows of data or values. Thanks for reply, but your answer does not help me, however it does not help me. I don't even know what to call this task?
#How do i freeze top 3 rows in excel how to
Perhaps someone can help or has a youtube video that could teach me how to do this.
In ROW 1 you still have the following 8 values in the range of cells from cell A1 thru cell H1 (1,2,3,4,5,6,7.8) in an untouched or uneffected state?īut in ROW 2 you have the following 8 values in the range of cells from cell A2 thru cell H2 (B.C.D.E.F.G.H A) Now, how do I somehow lock or freeze ROW 1 such that if I highlighted column A and cut it, then I attempt to paste it after Column H so that the new result would look like this. In ROW 2 you have the following 8 values in the range of cells from cell A2 thru cell H2 (A.B.C.D.E.F.G.H) In ROW 1 you have the following 8 values in the range of cells from cell A1 thru cell H1 (1,2,3,4,5,6,7.8) For example, can I freeze any number of rows on the top of a sheet, but then cut, copy, move entire columns. How do I freeze say the top 5 or 6 rows on a worksheet so that I can not change them or manupulate them whatsoever, but still be able to move, modify or manipulate ALL the data below those rows.
0 kommentar(er)
