![lock individual cells in excel 2010 lock individual cells in excel 2010](https://cdn4syt-solveyourtech.netdna-ssl.com/wp-content/uploads/2012/06/lock-cell-in-excel-2010-2.jpg)
Track Changes Have you ever edited something, then realized you liked it better the way it was? Or have you ever edited something someone else wrote and wished there were a way to communicate your thoughts without typing in their document or worksheet? If either of these situations has ever applied to you, then learning how to use Track Changes and Comments in Excel 2010 will appeal to you.
#LOCK INDIVIDUAL CELLS IN EXCEL 2010 SERIES#
Keep in mind, if you only have one cell selected, which we do in the example above, it will AutoFill the other cells with the number 5 as well. It will NOT complete the series because a series is not established. You have to establish the series first. To AutoFill the rest of the series, move the mouse over the handle bar. A solid black cross (+) will appear. Once that appears, you drag the handle bar over cells to add a series. MS Excel gives you an AutoFill handle bar that you can use to complete this series automatically. The handle bar is located at the bottom right hand corner of a selected cell, as shown below. Here's an example. In the screen shot below, we wanted to number the columns 1 through 10. We started typing, but got tired at number 5. Typing any type of series in MS Excel 2010 just takes a matter of minutes if you know what you're doing. You can easily start a series, whether it's a series of numbers, dates, or a built in series for days, weeks, months, and years. You can, however, see the information in the Formula Bar, and it can be overwritten if you enter anything else in the cell.Remember those tests in school where the teacher would make you number a piece of paper from 1 to 10? Have you ever used MS Excel to make a list and put a number in each cell by typing one number at a time, one cell at a time? What about a date? Now the information in the cell is not visible, nor will it print.
![lock individual cells in excel 2010 lock individual cells in excel 2010](https://i1.wp.com/superpctricks.com/wp-content/uploads/2017/10/how-to-protect-cells-in-excel-2016.png)
Ruby wondered if there was a way to hide the contents of individual cells, as well.
![lock individual cells in excel 2010 lock individual cells in excel 2010](https://www.excelhow.net/wp-content/uploads/2019/01/lock-hidden-columns1.gif)
Part of preparing her data for printing involves hiding or displaying some rows and some columns, as appropriate. Ruby has a worksheet that she needs to print out in a couple of different ways, for different users.