# Perspective - View Canvas - replicate Excel spreadsheet - freeze top and left headers?

**URL:** <https://forum.inductiveautomation.com/t/perspective-view-canvas-replicate-excel-spreadsheet-freeze-top-and-left-headers/50400>\
**Category:** Ignition\
**Tags:** perspective, ignition80\
**Created:** [August 27, 2021, 10:59pm UTC](https://forum.inductiveautomation.com/t/perspective-view-canvas-replicate-excel-spreadsheet-freeze-top-and-left-headers/50400 "2021-08-27T22:59:10Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [August 31, 2021, 6:53am UTC](https://forum.inductiveautomation.com/t/perspective-view-canvas-replicate-excel-spreadsheet-freeze-top-and-left-headers/50400/6 "2021-08-31T06:53:17Z")

</div>

here ya go:  
Sorry for the terrible quality, i couldnt upload the big video and seems i reduce it way to much xD the spacing columns and rows is a bit off but its just a demo 😛

[https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/b/9b1ab7a4c0e0a910d5a1c2a72c9c48e3fd3a5a60.mp4](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/b/9b1ab7a4c0e0a910d5a1c2a72c9c48e3fd3a5a60.mp4)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/a/4a36cd54b264c155a72a5defef715e5e5cebee3c.png)

important things are:  
for the header `position:sticky top:0 left:null`  
for the left one: `position:sticky top:null left:0`  
for the rest: position:absolute or position:relative

```auto
[
  {
    "position": "sticky",
    "top": "0px",
    "left": null,
    "bottom": "auto",
    "right": "auto",
    "zIndex": "auto",
    "width": "auto",
    "height": "auto",
    "viewPath": "header",
    "viewParams": {},
    "style": {
      "classes": ""
    }
  },
  {
    "position": "sticky",
    "top": null,
    "left": "0px",
    "bottom": "auto",
    "right": "auto",
    "zIndex": "auto",
    "width": "auto",
    "height": "auto",
    "viewPath": "left",
    "viewParams": {},
    "style": {
      "classes": ""
    }
  },
  {
    "position": "absolute",
    "top": "50px",
    "left": "50px",
    "bottom": "auto",
    "right": "auto",
    "zIndex": "auto",
    "width": "auto",
    "height": "auto",
    "viewPath": "row",
    "viewParams": {},
    "style": {
      "classes": ""
    }
  }
]

```

---

_[View the full topic](https://forum.inductiveautomation.com/t/perspective-view-canvas-replicate-excel-spreadsheet-freeze-top-and-left-headers/50400)._