| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Short cuts for converting formulas to values
Dear Sir,
May I know how to convert formulas to values under Excel 2002 and Excel 2007 ? Is Copy and Paste Special is the only way ? Any keyboard short cut or single button for this ? Is there any short cut way of filling up the blank cells with the reference just above it ? <Usually I copy and paste reference by reference Eg. Before AFD220 BLANK BLANK BLANK AFD221 BLANK BLANK AFD222 BLANK BLANK €¦. After AFD220 AFD220 AFD220 AFD220 AFD221 AFD221 AFD221 AFD222 AFD222 AFD222 Thanks Low -- A36B58K641 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change font size in Excel with keyboard short cuts? | Excel Discussion (Misc queries) | |||
| Easily convert all formulas in 3d spreadsheet to values? | Excel Worksheet Functions | |||
| copy formulas without associated values | Excel Worksheet Functions | |||
| Excel query via ODBC cuts values | Excel Discussion (Misc queries) | |||
| delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
