- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel Shapes with text inside
Posted on 7/12/17 at 9:46 am
Posted on 7/12/17 at 9:46 am
I have a few files each month where we have a rounded rectangle shape where we put some text inside. What we normally do is copy the prior month's text, and then update it with current month and numbers. The only problem is the text formatting changes when I paste it into the box. Right click > Edit Text, then Ctrl+V. We have Arial font at 10pt, but it always pastes in as Calibri at 11pt. Is there something simple I'm missing to where it would keep my formatting upon pasting? No big deal if not, but thought I'd ask if something simple would save me from changing formatting on a few dozen text boxes each month.
Posted on 7/12/17 at 10:06 am to TU Rob
After you format it the way you want right click the shape border and left click on set as default shape
Posted on 7/12/17 at 1:40 pm to junkfunky
Paste without formatting?
Instead of keyboard short cutting it, right click - paste - there should be several paste options. Choose the one that keeps it the same
Instead of keyboard short cutting it, right click - paste - there should be several paste options. Choose the one that keeps it the same
This post was edited on 7/12/17 at 1:43 pm
Back to top
Follow TigerDroppings for LSU Football News