Hello! I am new here and if it is ok, I would like to ask for some little help.
I saw once in an Excel sheet that everything I typed there was automatically copied and displayed in other cells from the same sheet and also another sheets.
Can you please tell me how to do that?
All I want is to type some pure text and this text should be automatically copied and displayed in the next column and/or rows
I even attached a file.
Thank you very much!
=$A$5
and drag the formula up, down, left or right....
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh
Click on A5 using the left mouse key and keep the mouse key depressed.
Move the mouse to B5 keeping the mouse key depressed.
Move the mouse to B13 keeping the mouse key depressed.
Release the mouse key.
Click into the formula box at the top of excel, this is the box displaying your text.
Press these three keys in sequence keeping them depressed.
Ctrl Shift Enter
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Super fast and super easy!
Thank you so much Glenn Kennedy and mehmetcik!
There seems to be a problem if I introduce a symbol (via Insert - Symbols).
The symbol is diplayed in the original cell but in the ~teleported~ ones it displays only a number (number 5 in my case).
What should I do?
Last edited by ovi.sergiu; 10-15-2017 at 08:25 AM. Reason: misstyping
That does not make sense!!
Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).
Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
This is what I did:
- established georgia font
- put 4 lines of text into A3 cell and every line starts with the empty ssquare symbol
- copied the ~formula~ below and in the next column, BUT the symbols do not show (instead of empty square symbol appears the number 5)
See the file attached.
Exactly where did you find the symbol that you put into that cell?
I can see your problem, but can not reproduce it!!
I put the mouse cursor in front of the first word, the clicked on Insert - clicked on Symbol icon from the right and the chosed the symbol.
2017-10-15_16-14-39.jpg
Found it... Youre problem is that you're mixing your fonts in a single cell. Wingdings and Georgia. To fix this, use the square from the geometric shapes subset in font Georgia. then it's fine.
Yep, that was it. Thank you so much!
I think the only question that remains for now is that IS POSSIBLE that the ~teleported cells~ to keep the formatting from the original cell? Because it does not... If my original text is wrapped, in the teleported cells is not wrapped. I have to wrapp it manually.
If you're wanting a nice rectangle, click on the cell and drag it across and down form the source cell. It'll keep the source formatting.
It works!
Many thanks.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks