Independence Day (1996)
in Movies ·
The best quote from the movie "not wanting to die a virgin" 🤣🤣🤣
Home ›
urbanangler11 › Posts
Posts by urbanangler11
3 posts shown.
Excel - auto-fill settings
in Software ·
It works for me, whether there’s a space or not. 🤷
Excel - auto-fill settings
in Software ·
Here’s how you handle it:
Problem1
In the cell where you want to start, type in Buyer1. Hit Enter. Once you do, the selection will move down to the next row. Click on the cell you just typed in; you'll see a tiny black square in the bottom right corner. Grab that little square with your mouse and drag it down as far as you need to go—just make sure you keep the mouse button held down while you're dragging.
Problem2
It’s basically the same process as Problem1. Type in the date you want—let's say 1/1/2001—but whatever you do, don't put a period after the year. If you do, Excel won't recognize it as an actual date (some kind of glitch, I suppose). Just type 1/1/2001 and drag that little square down until you reach the end date. When you're done, the dates should be highlighted in blue. That's what we want. Don't click anywhere else while they're selected, or you'll lose the highlight and have to start all over again. While they're still highlighted, go to Format -> Cells -> Date and pick your preferred style, like 1/1/2001. Select 1/1/2001 and hit OK. It'll add the necessary punctuation for you.
That's about as much detail as I can provide.👍
Problem1
In the cell where you want to start, type in Buyer1. Hit Enter. Once you do, the selection will move down to the next row. Click on the cell you just typed in; you'll see a tiny black square in the bottom right corner. Grab that little square with your mouse and drag it down as far as you need to go—just make sure you keep the mouse button held down while you're dragging.
Problem2
It’s basically the same process as Problem1. Type in the date you want—let's say 1/1/2001—but whatever you do, don't put a period after the year. If you do, Excel won't recognize it as an actual date (some kind of glitch, I suppose). Just type 1/1/2001 and drag that little square down until you reach the end date. When you're done, the dates should be highlighted in blue. That's what we want. Don't click anywhere else while they're selected, or you'll lose the highlight and have to start all over again. While they're still highlighted, go to Format -> Cells -> Date and pick your preferred style, like 1/1/2001. Select 1/1/2001 and hit OK. It'll add the necessary punctuation for you.
That's about as much detail as I can provide.👍