Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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
Reply



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 01:11 AM.


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