Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-02-2021, 09:18 PM
yacov yacov is offline long list Windows 10 long list Office 2016
Competent Performer
long list
 
Join Date: Oct 2019
Posts: 139
yacov is on a distinguished road
Default long list

Hi.


Question for beginners, I want to make a list of consecutive numbers in column B, which will end when column A ends.
In column A there are 24000 rows, dragging the cursor all the way to the end will be difficult.
Is there a command in excel instead of pulling the cursor.
Thanks
Attached Images
File Type: jpg concordane.jpg (130.7 KB, 15 views)
Reply With Quote
  #2  
Old 08-02-2021, 09:56 PM
ArviLaanemets ArviLaanemets is offline long list Windows 8 long list Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Fill 2 first numbers (1 and 2) into column B;
Select both cells you entered numbers in;
Place cursor on lower right corner of selection (a cross is displayed);
Dobule-click. Unless there are gaps in column A, column B will be filled until end of current datarange.
Reply With Quote
  #3  
Old 08-02-2021, 10:29 PM
Purfleet Purfleet is offline long list Windows 10 long list Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

ArviLaanemets answers is the simplest way and should work well, but if you do have any gaps in columns it will stop there, so as a workaround you can go to the last cell then in column b input (where 24000 is the cell you are in)

=ROW(B24000)

then copy the cell (ctrl + c) and press ctrl+shift+arrow up to select all cells above the active cell then ctrl +v to paste
Reply With Quote
  #4  
Old 08-03-2021, 02:41 AM
yacov yacov is offline long list Windows 10 long list Office 2016
Competent Performer
long list
 
Join Date: Oct 2019
Posts: 139
yacov is on a distinguished road
Default

thanks a lot.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
long list In a long numbered list, the period disappears after 100. ryannah05 Word 1 12-28-2017 05:55 PM
Trying to make a long list sequential. icecream Word 2 01-03-2014 12:02 AM
long list Adding a long list of values to a combobox in Word 2003? ll4u76 Word VBA 1 04-13-2012 03:37 AM
2010 Outlook Favorites list too long Emerogork Outlook 1 06-16-2011 05:05 PM
Long List for drop down box DLo99 Word 0 02-28-2010 08:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:13 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft