<div>
Hello,<br />
<br />
you cannot do that with formulas. You either need to copy and paste the cell manually, or use VBA to do that.<br />
<br />
Would that be an option?<br />
<br />
cheers, teylyn
</div>


Hello,

you cannot do that with formulas. You either need to copy and paste the cell manually, or use VBA to do that.

Would that be an option?

cheers, teylyn

<div>
gtg, selecting cells is slow and hardly ever necessary.
</div>


gtg, selecting cells is slow and hardly ever necessary.

<div>
<div class="content wysiwyg-content">
I have a cell that I want to fetch the value from another cell. I want it to copy all the stuff from the cell, like the text in it, the text type, the background color, the text colour and so on. How do I do that? Is it possible to do by refereing in the cell that I just dont want to get the text in it?
</div>
</div>


I have a cell that I want to fetch the value from another cell. I want it to copy all the stuff from the cell, like the text in it, the text type, the background color, the text colour and so on. How do I do that? Is it possible to do by refereing in the cell that I just dont want to get the text in it?

Formula to copy cell to another cell

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.