Power KPI
  • PowerKPI for Qlik Sense
  • What's new
  • Compatibility
  • Installation
  • Activation
    • Online activation
    • Offline activation
  • Getting started tutorial
    • Preparation steps
    • Template design
    • Measures binding
    • Formatting
    • Hypercubes
    • Visualizations
    • Actions
    • The final result
  • Video tutorial
  • Features overview
  • Properties
    • HyperCubes
    • Data
    • Sorting
    • Add-ons
    • Appearance
    • Visualizations
    • About
  • Visual editor
    • Cells
    • Data
    • Borders
    • Alignment
    • Font
    • Visual editor keyboard shortcuts
  • Actions
    • Apply symbol
    • Apply styles
    • Set Variable
    • Activate View
    • Go to sheet
    • Next sheet
    • Previous sheet
    • Go to story
    • Go to URL
    • Select values
    • Select all
    • Select match
    • Select alternative
    • Select possible
    • Select excluded
    • Toggle select
    • Clear
    • Clear other
    • Clear all
    • Lock
    • Unlock
    • Lock all
    • Unlock all
    • Create bookmark
    • Apply bookmark
    • Remove bookmark
    • Reload
    • Partial reload
    • Export data
    • Value color
    • Mini chart
    • Zoom in
    • Zoom out
    • Sort
    • Alternative dimensions/measures
    • Searchable dimension
    • Select dimension value
    • Show dialog
    • Show tooltip
    • Show sidebar
    • Show popover
  • Demo Apps
  • FAQ
Powered by GitBook
On this page

Was this helpful?

  1. Visual editor

Cells

PreviousVisual editorNextData

Last updated 6 years ago

Was this helpful?

“Cells” section of the toolbar allows you to add/insert/remove rows, columns, merge/split cells, change background color and even copy styles settings between cells.

It has the following buttons:

  • - add row;

  • - add column;

  • - merge several selected cells;

  • - split merged cells;

  • - insert row and/or column depending on current cells selections (it will insert one row above the current selected one, or insert one column before the selected one, or insert one row and one column before the selected cell);

  • - copy styles settings from the current selected cell and apply them on the cell which will be selected;

  • - change background color on the selected cell/cells

To be able to merge cells, you should select cells from the top left cell to the bottom right cell holding the left mouse button.

To apply some operations on several cells, you should select them holding "Ctrl" key.

To select an entire column, you should click the column header (cell with a column number). In such a way, by clicking the row number, you can also select an entire row. It is possible to select several columns/rows by selecting the corresponding column/row headers.

To quickly add a copy of columns or rows, select the appropriate columns or rows and then click the corresponding button (to add columns) or (to add rows).