Sorry folks - anyone know how to copy the contents of one cell to multiple cells? Obviously, I can copy and then paste it repeatedly, but is there a faster way?
Yeah, just highlight lots of cells at the same time and then paste.
Was that really what you wanted?
Just select multiple cells and then hit paste. You can use Shift if the cells are in a block, or Ctrl if they’re scattered.
Dragonbones, you’re soooooooooo sloooooooooow.
Bite me.
Wait … better not.
Ok, now I feel like an idiot. I swear I have tried that before, but must have done something weird, because it never worked until now… urgh… can someone delete this thread please…
sigh
Anyone, please. How do I automatically republish a short list of items to a second sheet within the same Excel document? I don’t want to copy and paste again, and again. Enter the data once, have it appear within a list on the second page at the same time.
Thank you.
link the cells. use the help, i forget how to do it.
[quote=“Jaboney”]sigh
Anyone, please. How do I automatically republish a short list of items to a second sheet within the same Excel document? I don’t want to copy and paste again, and again. Enter the data once, have it appear within a list on the second page at the same time.
Thank you.[/quote]
Edit, copy worksheet ?
PS Jesus christ, I’m five Weiheistaphener lagers and [strike]3/4 a of[/strike] a bottle of Chilean carmenere in, so take it for what it’s worth. However, I have also successfully hooked up my brand new iPhone up to whatever so far this evening, so there. I guess a drunk with enough ego can overcome as Motown used to say. (think of that underlined bit as inspiration )
Don’t want to copy-paste on an ongoing basis, and don’t want the entire sheet, just a few cells.
Figured it out with urodacus’ hint. Copy, Paste Special, Paste Link does the trick.
thanks