If you don’t want to use drag and drop or double-click toautofill numbersin Excel, you can achieve the same effect using theFill command on the Ribbon. Autofill Using Fill Command on the Ribbon Select the range of cells – including the initial value – where you want numbers to be po...
"id":"text:en_US-shared/client/components/common/Loading/LoadingDot-1745505309764","value":{"title":"Loading..."},"localOverride":false},"CachedAsset:quilt:o365.prod:pages/forums/ForumMessagePage:board:ExcelGeneral-1745502712750
Cambosityhello there. External links areHIGHLYnot recommended. They are very problematic and, as you can tell already, difficult to deal with. I also understand some people who use spreadsheets do not have total control over what they are using, so what I say next should be taken in the c...
FREE EXCEL TIPS EBOOK - Click here to get your copy What do you do when you have to enter a sequence of serial numbers in a column in Excel? For example, entering numbers 1 to 1000 in cell A1:A1000. The regular way of doing this is: Enter 1 in cell A1. Enter 2 in cell A2....
Numbering with prefix, without dragging Hi, please, how thousands of rows in one column could be numbered, without dragging and with a letter prefix? Example: AHJS1000 AHJS1001 AHJS1002 ... thank you
ExcelGeneral"},"parent":{"__ref":"ForumTopicMessage:message:1545341"},"subject":"Re: Numbering with prefix, without dragging","moderationData":{"__ref":"ModerationData:moderation_data:1545430"},"body":"Let's say you want to start in row 2.\nSelect the range, starting...
In this page I have all my folder numbers listed, so it displays the number on my main page vs. the hyperlink code. ","author":{"__ref":"User:user:380356"},"isEscalated":null,"postTime":"2020-01-04T10:37:19.863-08:00","parent":{"__ref":"ForumReplyMessage:m...
I have a hidden page on the ABC Folder that I call "Formula Page". In this page I have all my folder numbers listed, so it displays the number on my main page vs. the hyperlink code. SergeiBaklan Thank you. I realized why it wasn't working when I saw your code....
ExcelGeneral"},"conversation":{"__ref":"Conversation:conversation:1545341"},"readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:1545341"},"body@stripHtml({\"truncateLength\":200})":" Hi, please, how thousands of rows in one column could be ...
Hi, please, how thousands of rows in one column could be numbered, without dragging and with a letter prefix? Example: AHJS1000 AHJS1001 AHJS1002 ... thank you How to do it so that the numbers remain the same even after moving to another row? To make them static values....