View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
M Thompson M Thompson is offline
external usenet poster
 
Posts: 37
Default Absolute reference in excel tables

Hello...I'm not familiar with tables in Excel, but can you use the F4 key to
get your absolute references, or is that also not available like the Shift+4
method?
--
OneFineDay


"ANIL ERDINC TUFEKCI" wrote:

Hi,

I have a problem in copy formulas including refence to excel table columns.
In a normal formula I can use $ sign for ablosute reference, but in tables ı
can not use 4 sign. So when i want to copy formulas with absolute reference
of table column it chages to other columns.

How can i solve this problem?

thanks...