Sunday, March 1, 2009

Easy way to copy one cell to a lot of cells in Excel

Microsoft Excel Tips

I am sure when using excel sometime you will do copying one cell to other cell but how about if you want to copying one cells to a lot of cell?
Follow this tips below for how to copy one cell to a lot of cells:

1. Open your Excel Program
2. In cell A1 input the data Ex: 123 then press Enter
3. Place the cursor to cell A1 then press Ctrl + C
4. Sort the range A2:G16 then press Ctrl+V



Related Topics :
How to configure Word, Excel 2007 options to save file into 97-2003 format?
How to set, change or remove password a document, workbook or presentation in Microsoft Office
Easy way to copy one cell to a lot of cells in Excel
How to Formatting Cells Values in Microsoft Excel 2007
Minimize the Ribbon for wider work area in Microsoft Office
Customizing a Quick Access Toolbar in Word 2007
How to preview the word documents without opening?
How to Change Saving Default File Location in MS Word 2007
How to Hide and Protect Pattern / Formula in Microsoft Excel 2007

No comments:

Post a Comment