Excel Forum
Similar Content
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
Macro: This free Excel macro illustrates all of the possible parameters and arguments that yo...
Quickly Add, Edit, & Manage Business Specific Diagrams in Excel (SmartArt)
Tutorial: In this tutorial I am going to show you how to add, edit, and manage Business oriented dia...
Count the Number of Cells that Contain Specific Text in Excel
Tutorial: How to count the number of cells that contain specific text within a spreadsheet in Excel....



Excel Magic Trick 689: Fill Column With 1 to 1000 Two Methods: 1) Series & 2) GoTo


See 2 methods to quickly fill a column with the numbers 1 to 1000:
Series Method:
1) type number 1 into cell A1 and Ctrl + Enter to keep cell selected
2) right-click fill-handle, drag to cell A2, drag back to A1, let go of right-click
3) In pop-up drop-down menu click on "Series..."
4) Select options button for "Series in"
5) Enter a "Stop value" of 1000
6) Hit Enter
GoTo Method:
1) Enter formula in cell
2) Copy Cell
3) Hit F5 for GoTo
4) Enter cell address: B1000
5) Hold Shift
6) Hit Enter
7) Use Ctrl + V to Paste formula into selected range

Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm





Got a Question? Ask it Here in the Forum.