How to link cells and keep number format altogether
Hi,
I wanted to let Cell A in worksheet1 to display the value of Cell B in worksheet2 by linking. According to Excel help, I first copy Cell B in worksheet2, and then paste it to Cell A in worksheet1, and then choose Paste Options, Link Cells. The value now is linked but I wanted to copy the number format as well at this moment. Is there a way to link the cells and keep the number format in one step? Many thanks, -- Yi Chu |
All times are GMT +1. The time now is 08:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com