• Welcome to Overclockers Forums! Join us to reply in threads, receive reduced ads, and to customize your site experience!

microsoft excel

Overclockers is supported by our readers. When you click a link to make a purchase, we may earn a commission. Learn More.

rick_323

Registered
Joined
Aug 23, 2003
I have a spread sheet that has the number 1 thru 100 using as labels. I want to change the 1 to 101 and the rest of the labels to adjust accordingly as well... example...

101,102,103,104,105... thru 200....etc etc,....


How do I achieve this without changing each number manually ? thanks,.
 
Select 2 thru the end. Delete. Change 1 to 101. Highlight 101, copy. Select the rest of the original cells. Paste. Should autonumber.
 
Back