Page History

{description}
{excerpt}An anchor represents the position of a floating \(non\-cell data\) object within a spreadsheet. The position is maintained as a row number \+ a percentage of the row's width and a column number \+ a percentage of the column's height.{excerpt}
{signature:C#}
 public sealed class Anchor
{signature}{signature:vb.net}
Public NotInheritable Class Anchor
{signature}
{remarks}To create an [Anchor|Anchor] object, use [Worksheet.CreateAnchor|Worksheet.CreateAnchor(Int32, Int32, Double, Double)] or [Cell.CreateAnchor|Cell.CreateAnchor(Int32, Int32)].

{remarks}
{example}{code:csharp|title=C#}

          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          Worksheet ws = wb.Worksheets[0];
          Anchor anc = ws.CreateAnchor(2, 4, 0, 0);
        {code}
{code:vbnet|title=vb.net}

          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Create()
          Dim ws As Worksheet = wb.Worksheets(0)
          Dim anc As Anchor = ws.CreateAnchor(2, 4, 0, 0)
        {code}

{example}
{properties}
||Name||Description||
|[Column|Anchor.Column]|{excerpt-include:Anchor.Column|nopanel=true}|
|[OffsetX|Anchor.OffsetX]|{excerpt-include:Anchor.OffsetX|nopanel=true}|
|[OffsetY|Anchor.OffsetY]|{excerpt-include:Anchor.OffsetY|nopanel=true}|
|[Row|Anchor.Row]|{excerpt-include:Anchor.Row|nopanel=true}|

{scrollbar}