Shortcut to Fixed cell conversions in a table...

**bldfaith** · 01-21-2014, 06:57 PM

copying data from one spreadsheet to another using +, then sorting that data in multiple levels...problem...need to make each cell in the copied table FIXED...ie, +a3 to +$A$3...is there a shortcut to entering each cell by hand?? Thank you friends

**NeedForExcel** · 01-22-2014, 02:40 AM

Try these steps -

F5, Alt+S, F, Enter (This will select cells with formulas)

Without deselecting, in the activecell, in the formula bar, single click and hit F4.

Then commit by using Ctrl+Enter.

It should work.

Thank You,

Deep

**bldfaith** · 01-25-2014, 07:16 PM

Hi "Deep".....I tried this and it only copied one cell....what could I be doing wrong...I am doing this for quite a few cells so knowing how to do this would b very helpful to me...thanks...